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='1555CEDB'
    

Location and Job Title:

After School Counselor | Special Needs Program
Shorefront YM-YWHA of Brighton Manhattan Beach
3300 Coney Island Ave
Brooklyn, NY 11235

Principal Responsibilities:

As a Special Needs after school counselor, you will be responsible for providing support, guidance, and a safe environment for children with developmental disabilities during the after-school hours. Your primary goal is to facilitate their social, emotional, and cognitive development through various activities while ensuring a positive inclusive experience.

Responsibilities of the counselor include but are not limited to:

• Counselors are responsible for 1-2 children on a daily basis.
• Counselors must ensure the children's safety, manage children's behavior, and act as a role model and mentor.
• Model constructive participation in all daily activities.
• Work closely with the senior counselors to ensure safety of all children.
• Counselors must be at least 17 years of age.

Minimum Qualifications:

Minimum Qualifications:

• Language skills: ability to effectively present information and respond to questions from supervisor, senior counselors, co-workers, and parents.

Additional Skills and Responsibilities:

• Lead by example: be a role model for campers and interns.
• 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.
• Show empathy and compassion to every student.
• Exhibit patience.
• Have the interest to learn about the individual needs of each child.
• Maintain a clean work environment.
• Assist students with homework.
• Assist students during bathroom breaks.

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, enforce safety regulations, and apply appropriate policies and procedures.
• Ability to work both indoors and outdoors, different temperature extremes, and be physically able to take children to indoor and outdoor activities and engage with them.
• Required to stand, walk, kneel, or crouch. Additionally, employee may also climb, push, pull, and occasionally lift and/or move up to 40 pounds.
• Ability to get into the swimming pool during pool hours (for the camp season).
• 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.

All Prospective Employees Must:

• Complete all mandatory trainings.
• Pass the CBC clearance

Disclaimer: The duties described are not to be interpreted as being all-inclusive to any specific employee. Management reserves the right to add, modify, change or rescind the work assignments of different positions and, when possible, to make reasonable accommodations so that qualified employees can perform the essential functions of the job.

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.