select * from jccworks.dbo.tbl_positionregion

select * from jccworks.dbo.tbl_PositionCategory order by positioncategoryname

        Select
            case
                when
                    salaryrange like '%Under%'
                    or salaryrange like '%over%'
                then
                    replace(replace(salaryrange,'Under ','Under $'),'Over ','Over $')
                when
                    len(isnull(salaryrange,''))>0
                then
                    '$'+replace(salaryrange,'- ','- $')
            end as salaryrange,
            (
                select top 1
                    PositionCategoryID
                from
                    jccworks.dbo.tbl_PositionDesired
                where
                    positionid=p.positionid
                order by
                    case
                        when PositionCategoryID='3E73' then 1 else 0
                    end desc
            ) as PositionCategoryID,
            convert(varchar,dateentered,101) as dateentered,
            p.*,
            replace(j.jccname,'Not-Yet-Affiliated','') as jccname,
            ja.address,
            ja.address2,
            ja.city,
            ja.state,
            ja.zip,
            m.firstname,
            m.lastname,
            m.email,
            m.jccid
        from
            jccworks.dbo.tbl_positions p
        left join
            jcca.dbo.tbl_jcc j on
            p.jccid=j.jccid
        left join
            jcca.dbo.tbl_jccaddress ja on 
            j.jccid=ja.jccid
        left join
            jcca.dbo.vw_jccmasterfile3 m on
            p.masterid=m.masterid
        where
            p.positionid='25EE3D59'
    

Location and Job Title:

LKSA Swim Instructor
Shorefront YM-YWHA of Brighton Manhattan Beach
3300 Coney Island Ave
Brooklyn, NY 11235

Principal Responsibilities:

The Shorefront Y is looking for a swim instructor for Lenny Krayzelburg Swim Academy. We are looking for someone who is passionate about swimming and dedicated to developing children in all aspects of life. If you want to make a difference in a young athlete's career, this is the job for you. We are looking for someone to guide and motivate our swimmers to become great athletes and exceptional human beings.

This job is a part time position. We pay a competitive salary.

To apply please send your resume to mantoi@shorefronty.org

Minimum Qualifications:

• Red Cross Water Safety Instructor Certification (or a certification of equal standing.)
• Red Cross Lifeguard Certification (or a certification of equal standing.)
• Red Cross CPR PRO/First Aid/AED Certification (or a certification of equal standing.)

Salary:

Under $25,000

Agency Information:

The Shorefront YM-YWHA of Brighton-Manhattan Beach, Inc. builds community, strengthens families and empowers individuals to achieve their potentials and enhance their quality of life by providing a wide range of programs and services rooted in Jewish traditions and values to meet the evolving needs and interests of the Brooklyn community.