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='FAFA8885'
    

Location and Job Title:

Personal Trainer
JCC Rockland
450 West Nyack Road
West Nyack, NY 10994

Principal Responsibilities:

Full-time and Part-time positions available

JCC Rockland is looking for certified personal trainers to join our team of fitness professionals. We have opportunities to work with a wide range of clients including seniors, teens, and special populations. Trainers will need a professional attitude and a keen understanding of customer service. We offer competitive pay and incentives for training volume.

Principal Responsibilities:

• Ability to design individual and group exercise programs tailored to the needs and attainable goals of specific clients
• Execute individual fitness programs designed in a safe and effective way
• Desire to help clients reach their health and fitness goals through appropriate cardiovascular, flexibility and resistance exercise
• Proactively assist members with fitness equipment; train members in correct use of fitness equipment; correct members on use of fitness equipment as necessary.
• Represent the agency and provide the highest quality of customer service to the individuals and groups with whom he/she comes into contact.
• Strong interpersonal skills with an eagerness to grow client base
• Team player

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

Minimum Qualifications:

Minimum Qualifications:

• Current nationally accredited personal training certification
• Specialization certifications preferred
• Certified in CPR/AED & First Aid

Salary:

Under $25,000

Agency Information:

JCCRockland.org