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='5A80706C'
After School Counselor
JCC of Binghamton, NY
500 Clubhouse Rd
Vestal, NY 13850
Key Responsibilities:
The After School Counselor is responsible for creating a safe, engaging, and enriching environment for students during after-school hours. The counselor will provide supervision, facilitate activities, and support students' social, emotional, and academic development. This role requires a dynamic individual with strong interpersonal skills and a passion for working with children and adolescents.
Under $25,000
Since its inception in 1927, the Jewish Community Center (JCC) of Binghamton, NY has grown to become an essential part of the Broome County community. As a full-service, non-profit organization, the JCC provides educational, cultural, recreational, and physical fitness programs to enhance the quality of life for all ages, from infants to senior citizens. As a non-sectarian United Way partner, the Center welcomes participants regardless of age, race, religion, sexual orientation, nationality, or ability to pay.
The JCC's facility houses a natatorium with a 2250 sq. ft. pool, gymnasium, small fitness center, men's and women's health clubs, steam, sauna, a fitness loft with spin bikes and Pilates reformers, stage, auditorium, and more. Over 200 children are served daily at our award-winning Early Childhood Center. Our year-round educational childcare includes UPK, after-school program, summer camp, and youth sports offerings.
The 8-acre land also features outdoor tennis/pickleball and basketball courts, pavilion, nature preserve, soccer field, and three age-appropriate playground facilities.