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

Location and Job Title:

Active Seniors Program Assistant
JCC of Northern NJ
450 West Nyack Road
West Nyack, NY 10994

Principal Responsibilities:

The Active Seniors Program Assistant plays a key role in supporting the delivery of engaging, mission-driven programs that build community and foster meaningful participation for area seniors. This position supports both
daily programming and special events, working closely with the Director to ensure a welcoming, inclusive environment that reflects the mission of the JCC of Northern NJ.

This job is a combination of rewarding hands-on work with seniors, and the creative, organizational, and administrative planning and implementation of the program...all in the context of Jewish nonprofit/communal life.

This is a 20-25 hour/week job: 9:30 AM-2:30 PM; two days/week in River Edge, NJ and two days/week in West Nyack, NY.

Minimum Qualifications:

Salary:

$25,000 - $35,000

Agency Information:

The JCC of Northern NJ deeply values the older adults in our community. Serving them is one of our two signature programs. Our programs are based in central River Edge, NJ in Bergen County. The administrative offices are based out of the Lewis JCC in Rockland County, NY.