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='8BAEBF8D'
    

Location and Job Title:

Program Coordinator
Jewish Community Center, Sonoma County
3421 Bonita Vista Lane
Santa Rosa, CA 95404

Principal Responsibilities:

We are seeking a motivated and organized Program Coordinator to support the day-to-day operations of our programs and events. JCC SoCo is a community-based organization "without walls" -- meaning we don't operate out of a traditional center. Employees work remotely when not on-site, and our events take place primarily in Santa Rosa, with occasional travel to other locations in Sonoma County.

This is an excellent opportunity for someone who cares deeply about community impact and wants hands-on experience in program administration, community engagement, and event coordination -- all within a mission-driven nonprofit environment.

Minimum Qualifications:

Key Responsibilities

• Coordinate and execute community events and programs, from initial logistics through on-site support and follow-up.
• Manage registration and membership processes using our website and organizational tools, ensuring a smooth experience for participants.
• Support the creation and distribution of marketing materials, including flyers, email campaigns, and social media.
• Implement outreach strategies to recruit new participants and members through community events, partnerships, and direct engagement.
• Draft newsletters and program communications to keep participants, sponsors, and partners informed and engaged.
• Coordinate with external partners -- including venues and sponsors -- before and after events.

Qualifications

• Strong organizational skills with the ability to juggle multiple tasks and deadlines.
• Excellent written and verbal communication skills.
• Proficiency in Google Workspace (Gmail, Calendar, Meet, Docs, Sheets);
  experience with databases like CRM and CMS platforms is a plus.
• Demonstrated commitment to equity, inclusion, and community-centered service.
• Ability to work occasional evenings or weekends for events.
• Valid California driver's license and reliable transportation required; regular travel across Sonoma County is expected.
• Ability to lift and carry up to 30 lbs; setup and breakdown of event materials is part of the role.

We welcome applicants from all backgrounds and experience levels, including recent graduates and those transitioning into the nonprofit sector.

Salary:

Under $25,000

Agency Information: