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='91A5C00E'
Day Camp Gardening Specialist
JCC of Stamford
1035 Newfield Ave
Stamford, CT 06905
Day Camps@The J is seeking a passionate and knowledgeable Gardening Specialist to lead engaging, hands-on gardening activities for our campers. This position is ideal for individuals aged 21 and older with experience in gardening or farming. The Gardening Specialist will inspire campers to connect with nature, learn about sustainable practices, and develop an appreciation for growing their own food.
Key Responsibilities:
Work Environment:
Benefits:
How to Apply:
Submit your application on the Day Camps@The J website under the "Work at Camp" section. Only completed applications will be considered.
Join us this summer at Day Camps@The J to cultivate curiosity and a love for nature among our campers!
Job Type: Temporary
Work Location: In person
Qualifications:
Under $25,000
The Stamford Jewish Community Center is a cultural, educational and recreational center, offering exceptional programs, classes and special events designed to enrich the mind, body and spirit. While we are driven by the Jewish values of welcoming guests, kindness, respect, and communal responsibility, we warmly welcome people of all ages, faiths, ethnicities and backgrounds.