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

Location and Job Title:

GE Instructor
JCC Rockland
450 West Nyack Road
West Nyack, NY 10994

Principal Responsibilities:

JCC Rockland is currently looking for highly motivated and energized individuals to instruct group fitness classes in a variety of modalities, including rowing, cycling, circuit training/strength, cardio, mat Pilates, dance, yoga, boxing, etc. If you possess the following skills, we need to hear from you!

• Enthusiastic, creative and enjoy delivering new, fresh and innovative routines.
• Excellent customer service and communication skills.
• Have a positive attitude, and exhibit the passion to motivate and encourage others.
• Experience in teaching to varied demographics and for clients of all levels.
• A team player.

We offer:

• Competitive pay
• Flexible schedule
• FREE membership-for those who hold classes on our regular schedule or run scheduled small group training programs.

Minimum Qualifications:

Qualifications:

• Must hold a current certification by a nationally accredited organization.

Current CPR/AED certification

To apply, please send resume/cover letter to divap@jccrockland.org

Salary:

$25,000 - $35,000

Agency Information:

JCCRockland.org