select * from jccworks.dbo.tbl_positionregion

select * from jccworks.dbo.tbl_PositionCategory order by positioncategoryname

        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='BE9F9048'
    

Location and Job Title:

Director of Camp, Youth and Family Services
The Memphis Jewish Community Center (MJCC)
6560 Poplar Ave.
Memphis, TN 38138

Principal Responsibilities:

Position Summary:

The Memphis Jewish Community Center's Camp, Youth and Family Services department is focused on meeting the growth and developmental needs of our participants. We are a nurturing community that creates a safe and fun environment for our participants, with Jewish values at our core. Our caring staff fosters every participant's self-esteem and confidence.

The Director of Camp, Youth and Family Services will lead the department through development and implementation of short and long-term program goals in keeping with the mission and operating goals of the Memphis Jewish Community Center, including but not limited to Day Camp, J Club After School Program, Family Programming, Camp 365, and Kid's Night Out.

Essential Duties and Responsibilities:

• Essential Duties and Responsibilities: · Lead the planning and execution of Day Camp, Vacation Camp, After School Programs & Clubs, Family Programming, Kid's Night Out
  · Develop, implement and manage departmental budgets
  · Lead hiring, onboarding, training and supervision of year-round and seasonal staff
  · Supervise the Camp, Youth and Family Services Department full-time and part-time Camp and Youth Programming Staff
  · Develop and execute year-round camp and youth engagement opportunities
  · Ensure annual American Camp Association Accreditation is maintained
  · Perform all other duties as assigned
• Position Status:
• Full-time; Salaried; Exempt
  
  
• Benefits:
  401k
  Medical, Dental, and Vision Insurance
  Paid Time Off
  MJCC Membership
  Discounted MJCC Programs
  Professional Development Opportunities

Minimum Qualifications:

Minimum Qualifications:

1. Bachelor's degree required; Masters preferred
2. 2-5 years of related work experience
3. CPR, First Aid, and AED Certification or willingness to obtain
4. Experience managing budgets and program operations preferred
5. Demonstrated ability to train and manage staff, including seasonal and leadership staff
6. Demonstrated ability to develop creative programming for youth and teens
7. Dynamic and innovative with strong organizational skills and outstanding interpersonal skills relating to adults and children
8. Ability to work flexible hours, including evenings, weekends, and extended hours during Day Camp season
9. Independent judgment, initiative and advanced administrative skills required

Salary:

$57000

Agency Information:

Located on 24 amazing acres in the heart of East Memphis, The Memphis Jewish Community Center has something for everyone of all shapes and sizes. We have an amazing Early Childhood Center, an expanded Fitness Center, a large outdoor water park, an Art House, Senior Adult gatherings, Summer Camp, After School activities, and most importantly a welcoming environment.