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

Location and Job Title:

Sports and Recreation Coordinator
JCC of Greater New Haven
360 Amity Rd
Woodbridge, CT 06525

Principal Responsibilities:

Position Overview: The Sports and Recreation Coordinator is responsible for designing and implementing engaging, inclusive, and mission-aligned sports and recreation programs for all ages at the JCC of Greater New Haven. This role includes oversight of the gymnasium, racquetball and pickleball courts, and related storage areas, as well as collaboration with professional instructors to provide high-quality instruction in sports such as basketball and pickleball. The director also plays a key role in year-round summer camp planning, camp leadership building operations, and special event support.

Key Responsibilities:

• Develop and implement sports and recreational programming for youth, teens, adults, and seniors.
• Schedule and supervise professional instructors for high-level lessons and clinics (e.g., pickleball, basketball).
• Ensure cleanliness, organization, and safety of the gym, storage rooms, and court spaces.
• Serve as Manager on Duty several evenings per week, ensuring building security and positive member experiences.
• Participate in Vacation Camp programming as needed.
• Hold a leadership role in the summer camp and assist with year-round camp planning.
• Develop and manage the annual budget for sports and recreation, meeting benchmarks and fiscal goals.
• Design creative programming to engage the community and support revenue growth.
• Support and assist in planning large community events.
• Collaborate with external organizations to create adaptive sports opportunities for individuals with diverse needs.
• Collaborate with external organizations to create successful partnerships which increase revenue and community members served.
• Maintain strong communication with staff, members, families, and partners.
• Take part in the successful planning of annual community events including but not limited to the Bagel Run 5k, Craft Fair, Touch a Truck etc.

Minimum Qualifications:

Qualifications:

• Bachelor's degree in recreation, sports management, physical education, or a related field.
• A minimum of 2 years in planning sports management experience
• Knowledge of adaptive sports and inclusion best practices.
• Strong organizational, leadership, and interpersonal skills.
• Ability to work flexible hours, including evenings and weekends.
• CPR/First Aid certification (or willingness to obtain).

Salary:

$45,000 - $55,000

Agency Information:

The Jewish Federation, Foundation and JCC of Greater New Haven is an EEOC/AA Employer and does not discriminate on the basis of any protected class. We encourage individuals of all backgrounds and faiths to apply for any position for which they feel qualified.