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='9C2265B4'
    

Location and Job Title:

Camp Simchah Assistant Director
JCC of the North Shore
4 Community Rd
Marblehead, MA 01945

Principal Responsibilities:

The JCCNS is hiring for an Assistant Director for Camp Simchah summer camp. Candidate will be responsible for assisting the Director in day-to-day operations of our full-day summer camp program. Duties include daily scheduling of programs, administrative support, and staff management.

Camp Simchah Assistant Director position begins in April and is part-time (hours to be determined) until the start of camp at which point the position transitions to full-time, 40 hours per week through the end of the camp season. Camp season runs from June 26th-August 25th.

Responsibilities include, but are not limited to:

• Ensuring the safety and security of campers and staff at all times;
• Supervising counselors in implementation of daily camp activities;
• Helping to execute a fun and exciting program for campers each week;
• Creating a dedicated and fun atmosphere for both campers and staff;
• Maintaining weekly/daily activities schedule that coordinate with the weekly theme;
• Ability to adapt quickly to unforeseen situations, like inclement weather;
• Assisting in the management and care of physical facilities and equipment;
• Providing guidance to campers and staff for specific programs as required;
• Ensuring that all equipment is properly stored at the end of each day;

Communication

The Camp Simchah Assistant Director represents Camp Simchah and the JCCNS as a member of the leadership team.As such, they are expected to:

• Represent the department when interacting with participants, parents, and community members;
• Observe participant behavior and enforce appropriate safety regulations and emergency procedures;
• Report concerns and incidents to the Camp Simchah Director in a timely manner and according to departmental protocols;
• Provide parents with appropriate and timely feedback and information;
• Follow and support the policies, procedures, and expectations of the JCCNS and the Marblehead Board of Health.

Knowledge, Skills, and Abilities

The Camp Simchah Assistant Director must have:

• Basic understanding of youth development;
• Ability to manage large groups of elementary-high school aged campers in a dynamic, spirited environment;
• Ability to respond appropriately to emergency situations;
• Ability to communicate and provide necessary instruction to camp staff;
• Ability to observe camper behavior, assess its appropriateness and apply appropriate behavior-management techniques;
• Demonstrated organizational skills and attention to detail;
• Knowledge and experience in Microsoft Office Suite: Word, Excel, and PowerPoint.

The Camp Simchah Assistant Director is a full-time, seasonal position with the potential to extend beyond camp session dates. Salary depending on experience.

To inquire about or apply for this position, please contact heather Gravelese at hgravelese@jccns.com.

Minimum Qualifications:

The Camp Simchah Assistant Director must:

• Be 21 years of age and have attained a high school diploma or equivalent;
• Have a minimum of 1 year of experience as a camp counselor or comparable recreation experience;
• Have a valid Massachusetts driver's license and ability to operate an automobile;
• Hold a CPR/AED and First Aid certification. JCCNS can facilitate this training on-site prior to the start of camp.

Salary:

Under $25,000

Agency Information:

https://jccns.org/