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='3E396401'
    

Location and Job Title:

Basketball & Soccer Scorekeeper/ Coach
J Los Angeles
5870 West Olympic Boulevard
Los Angeles, CA 90036

Principal Responsibilities:

JLA Basketball Scorekeeper/ Coach will report to the Sports and Recreation Coordinator. The position supports our men's basketball league as stats and score keeper and staff liaison, and our youth sports programs like basketball and soccer. The ideal candidate understands basketball and soccer, has experience in teaching different sports, is a mentor to young children, and can adapt on the fly. They are a team player with excellent communication skills, and have experience working with children, and their families. This is a part-time non-exempt position.

Minimum Qualifications:

The primary responsibilities of the Basketball Scorekeeper/ Coach include, but are not limited to:

• Facilitate team basketball practices and youth clinics.
• Coach teams in games
• Assist in set up of multiple different sports programs
• Function a stats and scorekeeper for men's basketball league
• Develop sound professional relationships with children and parents
• Collaborate as a member of the sports staff

Key Qualifications:

• 1-2 years of basketball playing experience(preferred)
• 1-2 years of coaching experience(preferred)
• 1-2 years of soccer playing experience
• Prior experience in working with children and their families
• Exceptional skill and capacity for engagement and relationship building with both children, and adults
• Proven ability to plan, originate and organize practices
• Be a leader, self-starter, and strong collaborator
• Ability to accept guidance, constructive feedback, and support

Salary:

Under $25,000

Agency Information:

The J Los Angeles (formerly the Westside Jewish Community Center) has been serving the Los Angeles community for almost 70 years. We host a variety of programs for the community, including an early childhood center, basketball leagues and classes, swim lessons, summer and winter day camp, fitness classes, family holiday programs, teen leadership and Israel programs, senior wellness and adult programs. The JLA's Weinberg Aquatic Center, featuring two saline pools, is home to the popular SwimRight Academy.

For information on J Los Angeles programs please visit our website at thejla.org.