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='A270A5C5'
After School Group Leader
YM & YWHA of Washington Heights & Inwood
54 Nagle Ave
New York, NY 10040
Working at Y's SONYC Afterschool Program at Columbia Secondary School.
SALARY
REQUIRED KNOWLEDGE, SKILLS, AND ABILITIES:
To perform this job successfully, an individual must be able to perform each essential function satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.
Under $25,000
Established in 1917 as one of the first Jewish community centers in New York City, the YM & YWHA of Washington Heights and Inwood (the Y) is a thriving and visionary not-for-profit human services organization in Northern Manhattan. We welcome people of diverse ethnicities and all ages, from pre-school to older adults, into the Y family with a wide range of educational, recreational and social services and programs that focus on improving the quality of their lives. With a long and distinguished history, the Y is a multi-service community center that is well known for its nurturing environment and non-judgmental philosophy.