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='3F2D1776'
Program Coordinator-Hillel
Joan and Alan Bernikow Jewish Community Center of Staten Island
1466 Manor Road
Staten Island, NY 10314
ABOUT YOU
The Program Coordinator will play a central role in bringing Jewish life to campus by planning, implementing, and supporting programs and events for Hillel Staten Island at the College of Staten Island (CSI) and Wagner College.
WHAT YOU'LL DO
Program Planning and ImplementationHours: 40 hours per week; including weekends as needed.
$50000
BENEFITS
The JCC of Staten Island is committed to keeping you and your family healthy and happy through a comprehensive benefits program. Offerings include: subsidized options for Medical; offerings for Dental and Vision coverage, FSA and Dependent Care. We also offer free LTD, STD, Life Insurance, a Pension, 403B, generous program discounts, free membership, ample time off and much more!
ABOUT US
The Jewish Community Center of Staten Island was founded in 1929 with the goal of creating a home for the Jewish community by offering social, recreational, and educational activities. Over time, that mission expanded to help anyone who walked through the doors of any of our facilities. The JCC has become a true community center--not just for the Jewish community, but for the entirety of Staten Island.