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='3D73813D'
    

Location and Job Title:

Program Associate
Moise Safra Center
130 East 82nd Street
New York, NY 10028

Principal Responsibilities:

The Program Associate position is an opportunity for a highly motivated and organized professional with project management skills to work as part of a dynamic team. This individual will help the Programming Department turn the Moise Safra Center's programming vision to life through thoughtful planning, coordination, and execution of engaging events and initiatives. The ideal candidate will have a "can do" attitude, be creative, detail-oriented, proactive, and be able to adapt to the changing needs of the Moise Safra Center's members. This role is ideal for someone who enjoys building community, creating meaningful experiences, and contributing ideas in a collaborative environment.

Minimum Qualifications:

• Manage programs on a semester basis to achieve enrollment, engagement, and program success goals
• Develop, coordinate, and implement new programs and events
• Perform data entry and maintain accurate program records and reporting
• Drive program recruitment and participant outreach to meet registration targets
• Provide hands-on support before, during, and after programs and events to ensure smooth execution
• Coordinate operational details including scheduling, staffing support, supply preparation, and setup/breakdown
• Maintain clear and professional communication with participants, instructors, vendors, and internal departments
• Manage program supplies and assist with inventory organization
• Oversee program invoicing and ensure accurate financial tracking
• Collect, analyze, and evaluate program outcome data to measure success and improve future offerings
• Incorporate feedback and data-driven insights into program planning and development
• Work collaboratively with team members to share ideas, strategies, and best practices
• Provide day-to-day administrative and office support to ensure efficient department operations
• Ensure all programs and events are executed professionally, efficiently, and in alignment with organizational standards
• Hours may vary depending on events and programs

Salary:

$45,000 - $55,000

Agency Information:

Located on 82nd Street and Lexington Avenue, the Moise Safra Center's 65,000 square foot building is a vertical campus of 14 floors with dedicated venues for social, recreational, educational, spiritual and wellness activities. The facility includes a pool, fitness center, synagogue and beit midrash, culinary, dance and yoga studios, elegant banquet space with an outdoor terrace and views of the city. This signature Jewish center combines tradition and innovation to nurture the mind, body, and soul of its membership in a sophisticated urban setting.