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='94BF4FDD'
Camp Sabra Assistant Director of Staffing
St. Louis Jewish Community Center
2 Millstone Campus Dr
St Louis, MO 63146-5796
Summary:
The primary function of this role is to recruit, train, manage, and retain responsible, results driven, role models who are committed to operational excellence and forming healthy and meaningful relationships with campers in collaboration with the Senior Director of Camp Sabra and the leadership team.In addition, this position will oversee staff during retreats and rentals of the Camp Sabra facilities to outside groups.
Responsibilities:
Qualifications:
$60000
A tradition of welcoming and excellence for more than 130 years
The St. Louis
Jewish Community Center (the J) is a multigenerational gathering place,
offering a variety of programs and services for the St. Louis Jewish community
and the community at large. We welcome people of all backgrounds and faiths.
The J provides educational, cultural, social, Jewish identity-building and
recreational programming on its campuses in Creve Coeur, Chesterfield and at
Camp Sabra, located at the Lake of the Ozarks.
Throughout our
history, the J, a non-profit organization, has been the central meeting place
of the Jewish Community. It's the one place where families, regardless of
affiliation, can feel comfortable and welcome. We have evolved through the
years to meet the changing needs of our members, our Jewish community and the
entire St. Louis region.
Everyone is
welcome at the J.
Our Mission
The St. Louis Jewish Community Center enriches
lives, builds community, promotes inclusivity and creates meaningful Jewish
experiences.