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

Location and Job Title:

Division Leader- Summer Camp
Shorefront YM-YWHA of Brighton Manhattan Beach
3300 Coney Island Ave
Brooklyn, NY 11235

Principal Responsibilities:

Individuals that possess the special qualities that are required to lead a group of staff/children who are in their desired age range of choice. Division leaders must have exceptional organizational skills, exemplary time management, the ability to work with large groups of both children/staff, and the keen ability to be a leader at all times. It is a division leader's responsibility to map out the direction their groups summer will take, by planning everything from daily activities for children, to planning/running staff meetings with their counselors in appropriate areas related to camp.

This position entails supervising a group of staff from 10-25 personnel, and a group of campers varying from 60- 140 (depending on the division). A division leader's main responsibility is to supervise staff and the programs that they have instituted for the summer.

Minimum Qualifications:

Division Leader Requirements

• Position Overview: This position is an excellent opportunity for high school graduates interested in gaining leadership experience and contributing to a dynamic team environment. The Division Leader will serve as a role model and help ensure the safety and well-being of participants while fostering a positive and engaging atmosphere.

Additional Skills and Responsibilities:

• Lead by Example; Be a role model for campers and staff.
• Ability and willingness to work as a "team".
• Organized and possess excellent interpersonal communication skills.
• Enthusiastic and High Energy.
• Willing to follow directions and take initiative.
• Flexible and able to adjust tasks in accordance with changing priorities.

Working Conditions/Physical requirements:

• Ability to recognize and respond to critical incidents and the physical ability to act swiftly in an emergency situation.
• Ability to adequately observe participant activities, enforces safety regulations, and applies appropriate policies and procedures.
• The physical ability to lead and interact in group activities and perform related skills.
• While performing the duties of this job, the employee is regularly required to talk and hear. The employee regularly is required to stand, walk, sit, stoop, kneel, or crouch. Also required to climb, push, and pull. The employee must occasionally lift and/or move up to 40 pounds.
• Ability to work both in an outside and inside environment, different temperature extremes.
• Ability and willingness to get in the swimming pool and Beach to supervise during swimming times.
• The working conditions described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Salary:

Under $25,000

Agency Information:

Located in the heart of the largest Russian speaking community in North America, the Shorefront YM-YWHA has been committed to serving the diverse population of Brighton-Manhattan Beach for over half a century. A vibrant Jewish community center and social service agency, the Shorefront Y integrates immigrants into American society, inspires families and individuals to reconnect to their Jewish roots and provides a full array of cultural, educational, wellness, immigrant and human social services for people of all ages year-round.