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

Location and Job Title:

Basketball Coach
Riverdale YM-YWHA
5625 Arlington Ave
Bronx, NY 10471

Principal Responsibilities:

We are seeking a passionate and knowledgeable Basketball Coach to lead and develop players during our weekly basketball sessions. The coach will be responsible for planning and conducting skill development, team building activities, and scrimmages in a supportive and engaging environment.

This part-time position is ideal for individuals with a strong background in basketball and a desire to mentor athletes of varying skill levels.

Minimum Qualifications:

Key Responsibilities:

• Plan and lead basketball practice sessions focused on skill development, teamwork, and sportsmanship
• Provide constructive feedback and coaching to individuals and groups
• Ensure a safe, inclusive, and positive playing environment
• Monitor player progress and adapt drills to suit different skill levels
• Set up and maintain equipment before and after each session
• Maintain professional conduct and represent the organization positively

Requirements:

• Previous experience playing or coaching basketball (youth or adult levels)
• Strong communication and leadership skills
• Ability to motivate and inspire players
• Punctual and reliable with a commitment to Sunday sessions
• CPR/First Aid certification (preferred, not required)

Additional Details:

• Time Commitment: 3 hours per week (every Sunday from 12pm to 3pm)

Hourly Rate: $30/hour

Please send your resume and cover letter to Adriana Rexhepi at Arexhepi@riverdaley.org

Salary:

Under $25,000

Agency Information:

Our Mission:

Riverdale Y enriches lives by cultivating universally-shared values central to Jewish life, through educational, cultural, wellness, and service programs for all.

Our Values:

We build and strengthen community.

We create a space of belonging, where everyone feels respected and appreciated for who they are.

We have a responsibility to care for one another, in our local community and in our world.

We nurture our minds, bodies and souls.

We are committed to lifelong learning and growth.