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='0DA7536A'
HUMAN RESOURCES MANAGER
Gordon JCC
801 Percy Warner Blvd
Nashville, TN 37205
The Human Resources Manager will be responsible for managing all human resources activities for the Gordon JCC which will create an environment that encourages high performance for employees at all levels of the organization in an engaged, trusting and respectful environment. The HR Manager will be expected to develop and administer policies and procedures which support the mission and goals of the JCC and represent best practices of human resource management for both year-round and summer only staff. The HR Manager will report to the Director of Finance.
This is a flexible part-time position.
JOB TYPE: Part-time, 25 hours/week
BENEFITS:
MINIMUM QUALIFICATIONS
Recruitment and Onboarding
Training
Performance Management
Compensation and Benefits
Compliance with State and Federal Laws
Other
$35,000 - $45,000
The Gordon Jewish Community Center (Gordon JCC) is at the center of Jewish life in Nashville, providing recreational, educational, social and cultural programs and services to over 1,700 member families. Located on a beautiful 52-acre campus in west Nashville, it is a place where non-Jews are welcome to join, play and learn side by side with their Jewish neighbors. Camp Davis, established in 1930s, provides a day camp experience for hundreds of school-age children each summer.
To apply, please submit your resume and cover letter to Interim Executive Director, Dara Freiberg at dara@nashvillejcc.org.