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='6A722381'
Youth & Camping Services Manager & Camp Director
JCC of Youngstown
505 Gypsy Ln
Youngstown, OH 44504
JOB PURPOSE: Develop, lead, and schedule activities for the Youth Programs and serve as the Camp Director during the summer. Spend hands-on time with students and staff, getting to know them, and assisting staff with programming and behavior management.
DUTIES AND RESPONSIBILITIES:
OTHER RESPONSIBILITIES:
Bachelor's degree preferred. The ideal candidate will have experience working with camp, school age children and teens, enjoy working with children and their families and have a high level of interpersonal communication skills. Ideal candidate has a lot of positive energy, a high level of organization, able to manage multiple projects at once, and experience with GoogleSuite and Microsoft Office. Candidates must pass an FBI/BCI background check and drug screen.
$35,000 - $45,000
JCC of Youngstown is in northeast Ohio and has been here for over 70 years. We are a full-service JCC that serves our community based on Jewish values.