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='74CC5E24'
    

Location and Job Title:

Water Safety Instructor
JCC of Binghamton, NY
500 Clubhouse Rd
Vestal, NY 13850

Principal Responsibilities:

Are you passionate about water safety and committed to helping others learn to swim? The Binghamton JCC is seeking a motivated Water Safety Instructor (WSI) with all levels of experience and specialties. A unique opportunity to join a growing team and build offerings for our members and community.

WSI's have the knowledge to teach safe swimming skills from the most beginner swimmer all the way up to an experienced athlete looking to improve their technique. The WSI is tasked with cultivating a sense of community through positive interactions with members and clients and fostering an environment for all to develop necessary habits to encourage the love of swimming for newcomers in a safe and fun environment.

Water Safety Instructor:

• Conduct swim skill assessments and screenings to determine clients' swim level and skill status
• Develop and implement personalized lesson plans that align with clients' swimming development goals
• Monitor clients' progress and adjust lesson plans as needed
• Demonstrate correct swim stroke techniques and provide feedback to clients.
• Motivate clients and teach them safe habits in and around water.
• Harboring a safe and fun learning environment
• Explaining the proper way to swim each stroke.
• Promote swim lessons and other JCC services where applicable.
• Provide a fun, engaging, enriching and safe environment for our JCC members.

Minimum Qualifications:

Requirements

• Current Red Cross Water Safety Instructor Certification
• Current CPR, First Aid, and AED Certification

Salary:

$15

Agency Information:

Why the JCC?

• Opportunities for professional growth and development within a dynamic organization
• Collaborative and inclusive work environment that values diversity and respect
• Access to JCC facilities and programming for employees and their families
• Discounts on JCC programming such as personal training, swim lessons, preschool, and camp.

If you are passionate about working in a community-based organization and have a strong desire to contribute to the success of the Binghamton JCC, we encourage you to apply! Please submit your resume to Nate Stillman at nates@binghamtonjcc.org

Since its inception in 1927, the Jewish Community Center (JCC) of Binghamton, NY has grown to become an essential part of the Broome County community. As a full-service, non-profit organization, the JCC provides educational, cultural, recreational, and physical fitness programs to enhance the quality of life for all ages, from infants to senior citizens. As a non-sectarian United Way partner, the Center welcomes participants regardless of age, race, religion, sexual orientation, nationality, or ability to pay.

The JCC's facility houses a natatorium with a 2250 square foot pool, full gymnasium, small fitness center, men's and women's health clubs, steam, sauna, a fitness loft with spin bikes and Pilates reformers, full stage and auditorium, and more. Over 300 children are served daily at our award-winning Early Childhood Center. Our year-round educational childcare includes UPK, after school, summer camp, and youth sports programs.

The 8-acre land also features outdoor tennis/Pickleball and basketball courts, pavilion, nature preserve, soccer field, and three age-appropriate playground facilities.