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='97B4BFD9'
Adult Basketball League Coordinator & Referee
Riverdale YM-YWHA
5625 Arlington Ave
Bronx, NY 10471
The Adult Basketball League Coordinator & Referee is responsible for coordinating and overseeing adult basketball league activities while ensuring games are conducted in a safe, organized, fair, and professional manner. The position combines league administration with on- court officiating to provide participants with a positive and competitive basketball experience.
Please submit your resume and cover letter to Careers@riverdaley.org
Under $25,000
We build and strengthen community.
We create a space of belonging, where everyone feels respected and appreciated for who they are.
We have a responsibility to care for one another, in our local community and in our world.
We nurture our minds, bodies and souls.
We are committed to lifelong learning and growth.