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='4C2C0088'
    

Location and Job Title:

Fitness Instructor
Riverdale YM-YWHA
5625 Arlington Ave
Bronx, NY 10471

Principal Responsibilities:

Group fitness instructors will lead members, in a group environment, through safe and effective fitness classes. This position is responsible for providing group exercise fitness instruction and supervision in a variety of formats. Candidates must be able to instruct multiple fitness levels and ensure the safety of all members in the class. This person will enforce all building policies to group exercise and be able to communicate these to a diverse group of members why policies are in place. The instructor will serve as a resource to educate members on various aspects of fitness and wellness, and are responsible in ensuring that safety of the members is not compromised.

Minimum Qualifications:

Required Qualifications

• Must have a current nationally recognized fitness certification in Personal Training or Fitness Instructor such as NASM, ISSA, ACSM, ACE, NCSF, NFPT, NESTA.
• Current CPR/AED and First Aid Certifications Required
• Basic software skills; (i.e., Microsoft Word, Excel, PowerPoint etc).

Duties and Responsibilities include, but are not limited to:

• Instruct a variety of group exercise classes.
• Knowledge of fitness equipment and exercises.
• Arriving at class 15 minutes early to prepare and set up.
• Communication to the Fitness Director and Membership Director about canceled, arriving late to class or need of a sub.
• Take attendance before starting class.

Pay Rate: $50 per hour

Please submit your resume and cover letters to Adriana Rexhepi at Arexhepi@riverdaley.org

Salary:

$25,000 - $35,000

Agency Information:

Our Mission:

Riverdale Y enriches lives by cultivating universally-shared values central to Jewish life, through educational, cultural, wellness, and service programs for all.

Our Values:

We build and strengthen community.

We create a space of belonging, where everyone feels respected and appreciated for who they are.

We have a responsibility to care for one another, in our local community and in our world.

We nurture our minds, bodies and souls.

We are committed to lifelong learning and growth.