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='II40E29'
Camp Specialist
Shorefront YM-YWHA of Brighton Manhattan Beach
3300 Coney Island Ave
Brooklyn, NY 11235
Specialist: Specialists are a select group of individuals whose role is to enrich, inspire, and strengthen campers through their area of expertise over the course of the camp season.
For more information and to apply, go to
https://shorefronty.fedwebpreview.org/summer-camp/...Additional Skills and Responsibilities:
Working Conditions/Physical requirements:
Disclaimer: The duties described are not to be interpreted as being all-inclusive to any specific employee. Management reserves the right to add, modify, change or rescind the work assignments of different positions and, when possible, to make reasonable accommodations so that qualified employees can perform the essential functions of the job.
Under $25,000
The Shorefront YM-YWHA of Brighton-Manhattan Beach, Inc. (SFY) builds community, strengthens families & empowers individuals to achieve their potential & enhance the quality their lives. Our programs & services reflect the richness of the Shorefront YM-YWHA's Community Center & Settlement House traditions. We reach out to & serve people of all backgrounds & abilities throughout their life spans.
We provide a wide range of exemplary educational, recreational, preventive & rehabilitative health, vocational, cultural, citizenship, Jewish identity-building & human service programs to meet the evolving strengths, needs & interests of the rich mosaic of people in southern Brooklyn.
The Shorefront YM-YWHA maximizes the impact of its resources & expertise by forming partnerships & alliances with other organizations, government agencies & philanthropic institutions that share our commitments & values.