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='0ACF9F85'
Camp Extended Care Counselor
Stroum Jewish Community Center
3801 East Mercer Way
Mercer Island, WA 98040
The Extended Care Supervisor supervises our extended care program while creating a positive and safe environment for all campers and staff.
Pay Range: $20.50 - $22.00 per hour, depending on experience.
Essential Duties and Responsibilities:
Supervisory Responsibilities:
This position supervises Extended Care Counselors.
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.
Education/Experience: Experience and/or training working with children preferred. Attendance at J Camp staff training is required unless approval to train separately is granted in writing by the Camp Director. Supervisory experience is preferred.
Other Skills: Current CPR/AED and First Aid Certification for adults/infants/children, through an approved certifying body, or willingness to get certified.
Under $25,000
To be the Puget Sound's most open and welcoming community-centered Jewish organization.
To offer experiences that amplify profound Jewish connections for every generation.