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='CA68EF88'
Hourly Group Fitness Instructor/Personal Trainer
Kaiserman JCC
45 Haverford Rd
Wynnewood, PA 19096
The Kaiserman JCC is looking to hire new Certified Group Exercise Instructors and Certified Personal Trainers passionate about delivering quality, safe, and fun fitness classes. Pay is hourly for each class and starts at $25/h and varies on certification level and experience. Our ideal candidate can lead exercise classes for adult and older adults. Areas of interest include: Zumba, Dance, Pilates, Yoga, Seated Yoga, Aerobics, Weight Training and more. If you have an idea for a new type of class, we'd love to consider it!
Under $25,000
The Kaiserman JCC is located in Wynnewood, PA, in the heart of the Main Line. We are a vibrant Jewish Community, just a few miles from Center City Philadelphia. We are home to the award-winning Camp Kef summer day camp and one of the most respected preschool & kindergarten programs in the region.
The mission of the Kaiserman JCC is to ensure a welcoming and inclusive environment where Jewish values inspire excellent social, recreational, educational, cultural, and humanitarian activities that embrace our identity and connection to Israel. The JCC is committed to serving our entire community and does not discriminate based on race, religion, sexual orientation or disability.
Since 1971, the Kaiserman JCC has worked to build a vibrant, inclusive, and supportive Jewish community and enhancing and deepening the commitment to Jewish philanthropy. We have also worked with people and partners across the region to nurture Jewish life and learning, help those in need and build connections with Israel and Jews around the world.