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='E89DA786'
Lead Teacher
YM -YWHA of Union County
501 Green Ln
Union, NJ 07083
We are seeking a dedicated and passionate Teacher to join our educational team. The ideal candidate will have experience working with children from infancy through Pre-K in a classroom setting and possess strong skills in classroom management and curriculum development. This role involves educating young minds, fostering a positive learning environment, and implementing engaging lesson plans tailored to the needs of preschool children.
Duties
Join us in making a difference in the lives of young learners!
$18
Ym/Ywha of Union County (aka Union Y)
The YM-YWHA is guided by the principles of Judaism and democracy, and shall create an atmosphere especially congenial to Jewish thought, beliefs and values. Its purpose shall be to enrich the life of the Jewish and general community by developing and implementing programs for the recreational, educational, cultural, physical and social needs of those communities and, by doing so, stimulate and amplify in individuals their sense of responsibility to the local community and to society in general.