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

Location and Job Title:

Camp Programming Coordinator
Stroum Jewish Community Center
3801 East Mercer Way
Mercer Island, WA 98040

Principal Responsibilities:

Under the direction of the Camp Director, the Camp Programming Coordinator supervises Camp Specialists, plans special events and creates a safe environment for campers and staff.

Essential Duties and Responsibilities:

• Train camp staff in planning and running activities.
• Work with Specialists to proactively create and implement lesson plans for their designated program each week. Provide additional support for Specialists running week-long programs.
• Review and approve specialist activities.
• Provide constructive feedback to staff on an ongoing basis.
• Plan J Camp special events under the discretion of the Camp Director.
• Work with Camp Care Coordinator and Camp Nurses to ensure appropriate accommodations are made as needed.
• Work with other members of the J Camp leadership team and Specialists to plan and run daily Boker Tov and weekly Shabbat programs.
• Oversee programming budget. Order supplies and track expenses.
• Work with year-round team to create daily schedule.
• Ensure camp goals and values, including indelible Judaism, are integrated in J Camp programs. Collaborate with Character Ambassador.
• Create alternative program plans and adapt when weather or other changes necessitate.
• Support Camp Office Administrator with monitoring phone and email.
• Ensure the safety, health and welfare of campers and staff by providing a safe camp environment and immediately and appropriately responding to any incidents, illnesses or situations that arise.
• Communicate regularly with the Camp Director and other members of the Camp Leadership Team; share recommendations with the Camp Director on an ongoing basis.
• Act as a positive ambassador of the SJCC both inside and outside of the SJCC
• Follow all emergency procedures at the SJCC.
• Perform work on weekends and evenings as needed to meet applicable deadlines or scheduling needs.
• Other duties as assigned.

Supervisory Responsibilities:

This position supervises Camp Specialists.

Minimum Qualifications:

Qualifications:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

Education/Experience: Experience and/or training working with children required. Camp or similar youth recreation experience required.

Other Skills: Current CPR/AED and First Aid Certification for adults/infants/children, through an approved certifying body. Openness to learning

Salary:

Under $25,000

Agency Information:

Our Vision

To be the Puget Sound's most open and welcoming community-centered Jewish organization.

Our Mission

To offer experiences that amplify profound Jewish connections for every generation.

SJCC experiences are:

1. Indelibly Jewish: You can sense 'Jewish' in everything we are.
2. Relevant: We evolve with and in the world around us.
3. Interconnected: We are linked and connected to one another and the community around us.
4. Sustainable: Financially sound, resourced for the future, mindful of the world around us.