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

Location and Job Title:

Camp Activity Specialist
Stroum Jewish Community Center
3801 East Mercer Way
Mercer Island, WA 98040

Principal Responsibilities:

Bring your passion to J Camp this summer!

We're looking for talented Camp Activity Specialists who love inspiring kids through what they do best--whether that's art, drama, dance, music, cooking, archery, nature exploration, sports, challenge courses, or mystery STEAM. If you're creative, energetic, and excited to share your skills with campers of all ages, this is your chance to turn your talent into an unforgettable summer experience.

Essential Duties and Responsibilities:

• Assume responsibility for a group of campers under their care to ensure a positive and safe camp experience.
• Plan and lead activities. The activities must be appropriate for each age group.
• Ensure that the spaces used for J Camp are thoroughly cleaned before leaving.
• Share activity plans with supervisor by agreed upon date in advance of each activity.
• Provide a materials list to supervisor by agreed upon date in advance of each activity.
• Ensure that equipment is stored and used adequately and properly.
• Assist with special event planning and implementation.
• Support the emotional and social wellbeing of the kids through positive behavior management, supportive interactions, and conflict resolution.
• Communicate regularly and appropriately with the rest of the J Camp staff team, both verbally and in writing.
• Ensure children get to where they need to go as directed by the J Camp leadership team. Including playing an integral role during arrival and dismissal.
• 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 has no supervisory responsibilities.

Minimum 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 preferred. Attendance at J Camp staff training is required unless approval to train separately is granted in writing by the Camp Director.

Other Skills: Current CPR/AED and First Aid Certification for adults/infants/children, through an approved certifying body, or willingness to get certified.

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.