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='12CAF205'
Maintenance Tech, Nights
I.J. & Jeanne Wagner Jewish Community Center
2 North Medical Drive
Salt Lake City, UT 84113
Essential Duties & Responsibilities:
The PT Close Maintenance position is to maintain high standard of cleanliness throughout the building to insure that customers enjoy continued cleanliness and neat appearance including all public areas, restrooms, locker rooms, lobbies, and hallways. Check building equipment in the morning and take the pool readings throughout the day. Set up and break down banquet parties as required.
Education and/or Work Experience Requirements:
Previous experience in maintenance is a plus, but not required.Training is available and encouraged.
Physical Requirements:
Under $25,000
We are a vibrant community center full of people of all ages, faiths and family configurations, coming together in peace to strengthen their minds, bodies and spirits.
Mission Statement
Enriching the life of the Jewish community and the community at large by offering educational, cultural and recreational opportunities in a place where people of all backgrounds, cultures and beliefs gather in peace and understanding.