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='2206307C'
Toddler Ones Team Leader and Mentor Teacher
JCC of Stamford
1035 Newfield Ave
Stamford, CT 06905
The Toddler Team Leader and Mentor Teacher will have the opportunity to create a classroom environment and learning activities that reflect the knowledge that our youngest learners are natural born scientists and explorers. In this position you will act as the Lead Teacher in our One Year Old Classroom and will mentor other educators on your team who are working with our youngest learners. Salary of up to $60,000 for the ideal candidate
Curriculum Planning
Support and Communication
General
$45,000 - $55,000
The Stamford Jewish Community Center is a cultural, educational and recreational center, offering exceptional programs, classes and special events designed to enrich the mind, body and spirit. While we are driven by the Jewish values of welcoming guests, kindness, respect, and communal responsibility, we warmly welcome people of all ages, faiths, ethnicities and backgrounds.