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='B59F0FB6'
    

Location and Job Title:

Gymnastics Coach
Galbut Family Miami Beach JCC on the Simkins Family Campus
4221 Pine Tree Drive
Miami Beach, FL 33140

Principal Responsibilities:

Job Position Summary

Miami Beach Gymnastics is looking for a passionate, energetic, competitive, and dedicated team coach to build & strengthen our Womens Competitive Gymnastics team. The ideal candidates will have experience with coaching both Compulsory and Optional teams, primarily in Vault and the Uneven Bars.

Experience: Must have experience coaching competitive gymnastics

To apply, please send cover letter and resume to janet@mbjcc.org

Minimum Qualifications:

Primary Responsibilities:

• Participate in the day to day coaching of our Womens DP Compulsory & Optional teams
• Train athletes in preparation for competitions
• Must be willing to work weekday afternoon and early evening hours and weekends when needed.
• Must be willing to travel to meets as necessary with the gymnasts

Salary:

Under $25,000

Agency Information:

The Miami Beach Jewish Community Center (JCC) is a non-profit, social service agency founded upon Jewish ethics and values. Our goal is to provide quality programming to the community in everything from Childrens Enrichment and After-school programming to Summer Camp; Fitness to Aquatics; Sports to parenting classes; Adult Educational programs to Arts & Cultural events and more. We strive to employ the most qualified persons and continue to provide them with the support and encouragement needed in order for them to continue to develop and grow professionally as well as assist the MBJCC reach its goals in customer service and satisfaction.