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='E62A202E'
Early Childhood Lead Teacher
Hebrew Educational Society
9502 Seaview Ave
Brooklyn, NY 11236
Our Early Childhood Center currently offers full-day, year-round programming for children ages 3-5 including a NYC Early Learn program, Pre-K for All, extended day services and Summer Camp. The Lead Teacher is responsible for general administrative duties as assigned, for supervision of subordinate staff, and for planning, preparing, and implementing daily activities, monitoring children's progress, and maintenance of related records for the assigned classroom. At this time, this is a temporary position.
Responsibilities:
The Hebrew Educational Society, a thriving multi-service, comprehensive community center located in southeast Brooklyn, provides a diverse array of programs and services within a multicultural, multi-ethnic environment that is inclusive of people of all ages and ability levels. Programs include Early Childhood, After School, Camps, Athletic and Aquatic Activities, Older Adults & People with disabilities.