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='B0B40C84'
Personal Trainer
JCC of Binghamton, NY
500 Clubhouse Rd
Vestal, NY 13850
Are you passionate about fitness and committed to helping others achieve their health and wellness goals? The Binghamton JCC is seeking motivated personal trainers with all levels of experience and specialties. A unique opportunity to join a growing team and build offerings for our members and community.
Personal trainers also serve as the Trainer on duty, where they offer support and educating on the safe and correct use of cardio and weight training equipment. The TOD is tasked with cultivating a sense of community through positive interactions with members and fostering an environment where members can develop necessary habits to lead to a long-term healthy lifestyle. They ensure the continued culture of cleanliness is followed by all.
Personal Trainer
Trainer on Duty (Floor Hours)
Under $25,000
Since it's 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.