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='0DFA4148'
    

Location and Job Title:

Swim Instructor
Peninsula JCC
800 Foster City Blvd
Foster City, CA 94404

Principal Responsibilities:

Summary: The Swim Instructor is expected to teach safe and effective group and/or private swim classes for our members and are required to purpose and maintain educational standards commensurate with PJCC's quality and commitment to aquatics safety.

Essential Duties and Responsibilities include the following:

• Teaches various levels and age groups in accordance with PJCC's instructional guidelines.
• Plan lessons, select appropriate drills, and evaluate the student's progress.
• Present proper demonstrations and explain skills, analyze and correct performance, minimize fear, and use appropriate teaching devices.
• Maintain a safe and positive teaching environment.
• Attend all in-service trainings.
• Maintain accurate records and prepare course completion certificates.
• Perform all swimming strokes and skills taught in all levels.
• Effectively communicate each student's progress either to the student directly, or to the student's parents where appropriate.

Other Functions:

• Be knowledgeable about all programs and activities offered
• Promote club services and activities
• Assist with keeping the club well stocked and clean
• Inventory of food items as well as locker and laundry service
• Maintain safety book/emergency log, and lost and found ledger

Minimum Qualifications:

Certifications, Licenses, etc.:

Swim Instructors must maintain the following:

• American Red Cross CPR for the Professional Rescuer (or equivalent training).
• American Red Cross First Aid for Public Safety Personnel (or equivalent training).

Performance Testing*:

All Swim Instructors are required to perform the following performance test prior to employment and may be tested at any time throughout their employment.

Performance test are as follows:

• Demonstrate all swim strokes, including freestyle, breaststroke, backstroke, butterfly, sidestroke, elementary backstroke, and treading water.
• Demonstrate all skills taught in all levels.

Salary:

$25,000 - $35,000

Agency Information:

Welcoming with joy people of all ages, faiths, and backgrounds, our innovative Center provides programs and services designed to meet the needs of everyone from infants to seniors.

Come work out in our 50,000 square foot Byer Athletic Center; take a class at our Koret Learning Center; create a lifetime of memories for your children at our award-winning preschool or at Camp Keff.

At the PJCC we believe in a 'Wellness Your Way' approach to overall wellness. Wellness Your Way is an integrated approach to help youth and adults of all ages experience greater well-being by helping you identify your own, unique wellness formula and create a plan to put that formula to work in your life.

Your personal wellness formula serves your whole life, and it is unique to you. Your formula includes Nourish, Move and Engage activities that are the building blocks of a life well-lived.