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='61AF424D'
    

Location and Job Title:

Assistant Nutrition Site Manager
Marjorie & Lewis Katz JCC
501 North Jerome Avenue
Margate City, NJ 08402

Principal Responsibilities:

The Milton and Betty Katz JCC maintains seven Senior Centers throughout Atlantic County and is seeking an Assistant Meal Site Manager for our Egg Harbor Township location. Centers are open 8:30 am - 2:00 pm and serve a population of approximately 30-60 seniors (aged 60 plus) by providing a daily lunch and engaging activities to encourage participation from our seniors. It is the Assistant Manager's responsibility to aid the manager to coordinate a daily count of meals, order supplies, organize volunteers, and maintain a warm and welcoming center for all to attend.

Minimum Qualifications:

Education/Experience: One year experience working with this population (60 plus). Food service experience is a plus. Bi-lingual encouraged to apply.

• Ability to motivate others and work with a team
• Must provide proof of COVID 19 vaccination
• Must pass background check

Salary:

$35,000 - $45,000

Agency Information:

We are a non-profit, and there are lots of room for growth and learning opportunities.

The mission of the Milton and Betty Katz JCC of Atlantic County is to foster an appreciation of Jewish identity, values and culture, to promote the health, education and welfare of our members, to strengthen Jewish family life, to build a sense of community and ensure Jewish continuity for our children, our children's children, and ourselves.

Here at the JCC we are committed to creating an inclusive culture where all employees feel welcomed and valued.