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='4E0007AC'
    

Location and Job Title:

Summer Camp Counselor
JCC of Stamford
1035 Newfield Ave
Stamford, CT 06905

Principal Responsibilities:

Day Camps@The J, a summer camp in Stamford, CT is looking for enthusiastic high school and college aged students to be counselors this summer. This job is a great way to learn skills, build community and have fun in the sun. Staff will partake in swimming, adventure, sports, trips and more.As a counselor you have the opportunity to:

• Make a positive impact on others
• Develop serious leadership skills
• Spend the summer outside, playing games and swimming
• Work in a dynamic environment that is warm, welcoming and rewarding

Benefits include:

Minimum Qualifications:

1. Enthusiastic High School or College Student: Candidates should be currently enrolled in high school or college.
2. Passion for Making a Positive Impact: A genuine desire to positively influence the lives of campers and contribute to their growth and development.
3. Leadership Skills: While not explicitly stated as a prerequisite, the opportunity to develop leadership skills implies that candidates should possess or be willing to cultivate leadership abilities during the camp experience.
4. Comfortable with Outdoor Activities: Candidates should be comfortable spending extended periods outdoors, engaging in activities like games and swimming.
5. Ability to Work in a Team: Given the emphasis on community building and working in a warm and welcoming environment, candidates should be team-oriented and able to collaborate effectively with colleagues.
6. Responsible and Reliable: As camp counselors play a crucial role in ensuring the safety and well-being of campers, candidates should demonstrate responsibility and reliability in their duties.

These requirements reflect the nature of the role and the qualities needed to be successful in providing a positive and engaging summer camp experience for campers.

Salary:

Under $25,000

Agency Information:

The Stamford Jewish Community Center is a cultural, educational and recreational center, offering exceptional programs, classes and special events designed to enrich the mind, body and spirit. While we are driven by the Jewish values of welcoming guests, kindness, respect, and communal responsibility, we warmly welcome people of all ages, faiths, ethnicities and backgrounds.