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='2A311FFF'
    

Location and Job Title:

Camp JCC Art Specialist
Greater Raleigh JCC /Jewish Federation of Greater Raleigh
David R. Kahn Community Campus
12804 Norwood Rd
Raleigh, NC 27613

Principal Responsibilities:

Camp JCC is seeking a qualified, energetic, and compassionate candidate as an ART TEACHER for summer 2026. The art teacher is responsible for planning and conducting art projects that foster an environment of fun and creativity. The position requires an ability to manage day-to-day interactions with children in grades K-9, a strong ability to work collaboratively with the Camp JCC team, and the capacity to be flexible.

Applicant must be available to work Monday through Friday, June 8 through August 14 (8 weeks of camp plus staff week) from 8:30 a.m. to 4:00 p.m.

Minimum Qualifications:

ESSENTIAL FUNCTIONS:

• Plans a variety of art projects for children ages 4 through 15
•  Provides a planned and thoughtful program, infused with Jewish values, that will interest and excite campers
•  Adapts individual and small-group instruction to the needs of campers with varying intellectual and artistic abilities
•  Multitask, prioritize, and manage time efficiently
•  Plans and directs engaging, age-appropriate activities
•  Serves as a positive role model in the camp community
•  Communicates with leadership to order supplies for projects
•  Manages risk, supervises participants, and models safe best practices while working
•  Other duties as assigned by camp leadership

REQUIREMENTS

• Experience working with children in a camp, school or daycare environment
•  Must enjoy playing and interacting with children
•  Organized, enthusiastic, and energetic
•  Must be a creative and innovative thinker and planner
•  Must take initiative, be self-directed, and capable of independently identifying and solving problems
•  Must have excellent communication skills and work well with both children and adults
•  Pass a required background check

Salary:

Under $25,000

Agency Information:

The Jewish Federation of Greater Raleigh is the central hub of Jewish life in Wake County and surrounding areas. The Jewish Federation includes our agencies: Jewish Family Services, Jewish Community Center, Jewish Community Relations Council, and the Jewish Community Foundation. Camp JCC is a department of the Jewish Federation and fulfills the Jewish Federations mission Welcome, engage, and enhance Jewish life through connection care, and community. To learn more about Camp JCC visit raleighcaryjcc.org/campjcc