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

Location and Job Title:

After School Program Director
Hebrew Educational Society
9502 Seaview Ave
Brooklyn, NY 11236

Principal Responsibilities:

Position Summary

The Program Director serves as the onsite supervisor of the DYCD COMPASS Elementary program with overall responsibility for program implementation, including the hiring, supervision, and development of program staff. The Program Director ensures the program operates in full compliance with DYCD, SACC, and H.E.S. standards and serves as the primary liaison between the program, the host school, families, and DYCD.

Responsibilities:

• Provide onsite supervision and oversight of all COMPASS program operations during program hours
• Hire, onboard, supervise, and evaluate program staff in accordance with DYCD staffing requirements
• Ensure DYCD required staff-to-student ratios are maintained at all times, including during activities, transitions, arrival, and dismissal (Grades K-5: 1:10)
• Oversee program compliance with the SACC license, health and safety protocols, and all contractual obligations
• Serve as the primary point of contact for the host school, families, DYCD Program Manager, and community partners
• Support the planning and delivery of high-quality enrichment, academic, and recreational activities? Ensure staff complete required professional development hours (COMPASS Elementary: 129 hours per year)
• Hold regular team meetings and attend DYCD lead sessions

Minimum Qualifications:

• Bachelor Degree
• Minimum of 2 years of relevant experience
• 1 year of Supervisor experience
• Full-time position
• Monday through Friday from 10:00AM - 6:00PM
• Holiday Programming
• Must be onsite during all program hours

Salary:

$70000

Agency Information:

The Hebrew Educational Society, a thriving multi-service, comprehensive community center located in southeast Brooklyn, provides a diverse array of programs and services within a multicultural, multi-ethnic environment that is inclusive of people of all ages and ability levels. Programs include Early Childhood, After School, Camps, Athletic and Aquatic Activities, Older Adults & People with disabilities.