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='C75DF04F'
After School Program Coordinator
Jewish for Good at the Levin JCC
1937 W. Cornwallis Road
Durham, NC 27705
POSITION OVERVIEW:
The After-school Manager is a fulltime, salaried exempt position. This position is responsible for the oversight of the afterschool program including enrichment classes and summer camp aftercare, and support of other engagement programs.
This role supervises enrichment instructors and after-school staff.
RESPONSIBILITIES:
School year:
Summer:
REQUIRED QUALIFICATIONS:
PREFERRED QUALIFICATIONS:
$53000
Information Jewish For Good at the Levin JCC can be found at www.jewishforgood.org.
More about Durham, NC:
Considered to be one of the best places to live in North Carolina and one of the best mid-sized cities in the United States, Durham is well recognized for its record of low unemployment, top-of-the-line education system, and exceptional housing market.
Located just west of the state capital Raleigh and north of Chapel Hill, Durham is a popular city that makes up Research Triangle Park with a growing population of over 276,000 people.
Not only is Durham regarded as a good place to live, but it is also described as a cool city with a beautiful historic downtown and youthful vibe by locals and tourists alike.