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='38C6524A'
Swim Instructors
Marjorie & Lewis Katz JCC
501 North Jerome Avenue
Margate City, NJ 08402
The JCC is seeking Swim Instructors to plan and teach water safety and proper swimming techniques to a diverse range of participants in all age groups.
Responsibilities:
Qualifications:
$25,000 - $35,000
We are a non-profit, and there are lots of room for growth and learning opportunities.
Here at the JCC we are committed to creating an inclusive culture where all employees feel welcomed and valued.
EMPLOYEE BENEFITS
Discounted childcare at our JCC campus in Margate NJ! Free Fitness Center membership
Medical, dental, and vision benefits
Paid sick and vacation time
EEOC & Accommodations Statement
The Katz JCC is dedicated to Equal Employment Opportunity. We provide equal opportunities based on merit and ability, without regard to race, color, religion, gender, sexual orientation, gender identity, gender expression, citizenship and veteran's status, national origin, ancestry, age, disability, genetic information, or any other prohibited factor. Persons with mental or physical opportunities are eligible for employment, provided they can perform essential job functions after reasonable accommodation is made to their known limitations. If accommodation poses undue hardship, eligibility may be reconsidered.