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='3FF70224'
Building Engineer
Educational Alliance
197 E Broadway
New York, NY 10002
We are seeking a full-time Building Engineer who will play a critical leadership role at Manny Cantor Center (MCC), a 100,000 square-foot facility that serves thousands of Lower East side residents from Preschool-aged to Older Adults. The Building Engineer will have significant influence over the safety, compliance, and long-term sustainability of MCC, ensuring a safe, well-maintained environment for programs, staff, and community members to thrive.
RESPONSIBILITIES
Building Operations & Systems Management
Fire Safety, Emergency Response Procedures, and Regulatory Compliance
Maintenance, Repairs & Facilities Oversight
Capital Projects & Renovations
Budgeting & Fiscal Management
Safety, Risk Management & Emergency Preparedness
100K-110K
A nonprofit beacon of hope for over 130 years, as a historically Jewish organization Educational Alliance believes in the power of communities to lift up people of all ages and turn strangers into neighbors. We offer high-quality, affordable education programs, health services, and diverse cultural enrichment right where New Yorkers live and raise their families. We make the city a brighter, friendlier and more supportive place. Our community centers offer multi-generational programs that push boundaries and break barriers, sharing critical tools to foster relationships and advance the well-being of people in New York City.
Our pioneering educational programs--like 2Generation Head Start, and courses ranging from art to fitness, career readiness to citizenship--are carefully curated and developed with our city's residents in mind. We offer dozens of options and we never stop innovating to help people of all ages grow, connect, and engage.
Guided by Jewish values, Educational Alliance celebrates the differences and individuality every person brings when they walk through our doors because we know that there is more that connects us than keeps us divided. Today, our reach extends beyond the city as our innovative programs serve as models for other organizations to adopt and implement in their communities. We invite you to join us as we partner with our neighbors, strengthen our city, and pave the way for more generations of New Yorkers to live enriched and fulfilling lives - because you belong here.