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='2431478D'
Young Family Engagement Coordinator
The Marion & Aaron Gural JCC
207 Grove Ave
Cedarhurst, NY 11516
The Marion & Aaron Gural JCC seeks a dynamic, creative, community-oriented Young Family Engagement Coordinator to design relevant and innovative programs for families of preschool-aged children and serve as an ambassador of the JCC in the community.
The Young Family Engagement Coordinator is a newly created, part-time position designed to engage the families of the children in our Early Childhood Center. This is a part-time, 12-15 hours per week position. The role reports directly to the Executive Director with a dotted reporting line to the Associate Executive Director for Early Childhood.
KEY RESPONSIBILITIES
QUALIFICATIONS
Under $25,000
The Marion & Aaron Gural JCC is committed to sustaining and enriching the quality of life for all members of the greater Five Towns community through social, recreational and educational programs and services guided by universally shared Jewish values.