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='470A40D3'
Advancement-Development Director
Surprise Lake Camp
382 Lake Surprise Road
Cold Spring, NY 10516
Major Duties & Responsibilities
Skills & Knowledge/General Comments
$75,000 - $85,000
Surprise Lake Camp is one of the oldest Jewish Children's Camps in the United States. Since 1902, Surprise Lake Camp has provided a haven for children in the beautiful mountains of Cold Spring, NY. What makes SLC the best is the beauty of the site, the richness of the people and the program, the sense of history and tradition, and the magic we create when the whole thing comes together. We blend a commitment to traditional, rustic camp experiences with state-of-the-art recreational facilities and are particularly proud of our open, inclusive community that is sensitive to the needs of interfaith and diverse families.
Over 8 weeks each summer, nestled in a valley between two mountains and around a lake, we host over 600 campers and staff who come from all over the world. We have a very strong alumni base and many of our campers are the children and grandchildren of former campers.
Surprise Lake Camp is looking for an Advancement/Development Director who will help usher camp into the next generation.