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='8456D884'
    

Location and Job Title:

Afterschool Counselor
Riverdale YM-YWHA
5625 Arlington Ave
Bronx, NY 10471

Principal Responsibilities:

POSITION SUMMARY:

An After School Counselor assists with the implementation of the after school program. The after school staff member is responsible for helping to maintain a safe, clean after school program site, ensures a high level of program quality and works to establish a positive relationship with all program participants and their families. The after school counselor's work days will follow the public school calendar (unless otherwise noted). Counselors will be expected to be available Monday-Friday, from 2:00-6:30 PM. After school staff may be stationed at the Riverdale Y.

Hourly rate will range from $17-18.50 depending on experience.

Responsibilities:

• Picks children up at one of the designated schools and safely transport them to the Riverdale Y on provided bus.
• Accompanies a group of children to their designated enrichment classes.
• Assists enrichment teachers in class by interacting in play.
• Assists certified homework teachers.
• Adheres to schedules in a punctual manner.

Ideal opportunity for college/grad student studying early childhood education.

Minimum Qualifications:

• High School diploma.
• Availability to be part of training program.

Note that this position will begin during the 2026/2027 school year, starting in September, however resume collection is open.

Please send your cover letter and resumes to Careers@riverdaley.org

Minimum Qualifications:

Minimum Qualifications:

• High School diploma
• Availability to be part of training program

Salary:

Under $25,000

Agency Information:

The Riverdale Y is a 75,000 sq. ft. Jewish Community Center that provides educational, recreational, cultural, and wellness programs for children and adults of all ages and backgrounds. The Y features an early childhood center; summer camps; large after school program; senior center; performing arts center featuring theater, dance and music schools; and a health & wellness center that includes cardio and free weight studios, group exercise classes, gymnasium, swimming pool, steam room, sauna and massage therapy.