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='04368A12'
Camp JCC General Counselor
Greater Raleigh JCC /Jewish Federation of Greater Raleigh
David R. Kahn Community Campus
12804 Norwood Rd
Raleigh, NC 27613
Camp JCC Madrichim (counselors) are positive role models who supervise and engage campers, plan activities, and work as part of a team with a positive attitude, flexibility, and energy throughout each day.
ESSENTIAL FUNCTIONS
REQUIREMENTS
WORK SCHEDULE:
Applicant must be available to work Monday through Friday, June 8 through August 14 (8 weeks of camp plus staff week) from 8:30 a.m. to 4:00 p.m.
Under $25,000
The Jewish Federation of Greater Raleigh is the central hub of Jewish life in Wake County and surrounding areas. The Jewish Federation includes our agencies: Jewish Family Services, Jewish Community Center, Jewish Community Relations Council, and the Jewish Community Foundation. Camp JCC is a department of the Jewish Federation and fulfills the Jewish Federations mission Welcome, engage, and enhance Jewish life through connection care, and community. To learn more about Camp JCC visit www.raleighcaryjcc.org/campjcc.