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='D82672B0'
Receptionist
Asheville JCC
236 Charlotte St
Asheville, NC 28801
The Receptionist performs the administrative, financial, and security functions of the JCC's main reception desk. The Receptionist connects JCC members and community members to all of the JCC's programming, services, and engagement opportunities. The Receptionist supports the mission of the JCC by maintaining excellent customer service, following security protocol, and ensuring that every individual contacting the JCC receives a warm welcome, as well as encouragement and support to further engage with the JCC.
Part-time employees enjoy paid holidays, PTO/sick days, one floating holiday, free counseling services through EAN, discounted tuition at the JCC's 5-star early childhood and school aged programs, membership at our state-of-the-art aquatics center, and complimentary use of meeting spaces. You'll join a collaborative team that's been building community in Asheville for more than 80 years.
HR Email: hr@jcc-asheville.org
To apply, email HR at the email above. An automated email will be sent to you with a link to the official JCC application form. You'll be able to attach your resume and cover letter directly through that form.
The full job description will be provided during the interview process.
Under $25,000
At the Asheville JCC, all are welcome to share in Jewish traditions, values and culture. The AJCC has been the home for Jewish life in Western North Carolina since 1940, and today we continue to be a vibrant and diverse community of people. The Asheville JCC strengthens Jewish identity, celebrates Jewish culture and builds community through a wide variety of programs for people from all backgrounds, at every stage of life.