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='60602BFA'
Camp Support Counselor
Stroum Jewish Community Center
3801 East Mercer Way
Mercer Island, WA 98040
Camp Support Counselors assist with mental, emotional, social, and spiritual health (MESSH) support of J Camp campers, providing direct support under the direction of the Camp Care Coordinator.
Essential Duties and Responsibilities:
Supervisory Responsibilities:
This position has no supervisory responsibilities.
Qualifications:
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 required. Registered Behavior Technician training or other similar behavior training preferred.
Other Skills: Current CPR/AED and First Aid Certification for adults/infants/children, through an approved certifying body. Openness to learning.
Physical Demands and Work Environment:
The information described below represents the physical activities and surroundings one may encounter when performing the duties of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
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.