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='45B7A914'
    

Location and Job Title:

Rhythmic Gymnastics Coaches
Shorefront YM-YWHA of Brighton Manhattan Beach
3300 Coney Island Ave
Brooklyn, NY 11235

Principal Responsibilities:

Shorefront YM-YWHA and Club Dynamics Rhythmic Gymnastics in Brooklyn NY are looking to hire rhythmic gymnastics coaches! If you have experience in rhythmic gymnastics and great communication skills we want you to join our team! Dynamics Rhythmic Gymnastics is a USAG Pro member club that is a part of the Shorefront Y located in Brooklyn, NY. We're fully established with recreational and competitive programs.

To apply send your resume to anna@shorefronty.org

Minimum Qualifications:

We're looking for someone who:
• Loves working with children
• Is passionate about gymnastics
• Has coaching experience
Big Plus: Knowledge of the FIG Code of Points and Development USAG Program, judging background. Experience in Mommy and Me, Toddler, Recreational class instruction.

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.