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='05DF0742'
    

Location and Job Title:

Group Fitness Director
The Center
1901 Ocean Pkwy
Brooklyn, NY 11223

Principal Responsibilities:

To apply, please send cover letter and resume to David Jolovitz at DavidJ@scclive.org

About You: Our Ideal Candidate

We are seeking a talented and vibrant Group Fitness Director to manage the day-to-day operations of in-person group fitness classes and some virtual programming.

As our Group Fitness Director, the ideal candidate is:

Friendly, efficient, and growth-oriented

Has a nose for hiring and managing a talented team of group fitness instructors (to include multiple class formats)

Has experience working with operating budgets and overseeing a weekly group fitness schedule

Proficient with social media (photo, video and simple graphic design)

Ready to work with member feedback and a helpful volunteer committee

Interested in ensuring the department's growth with new programs and special events

A skilled communicator with natural problem-solving abilities

Minimum Qualifications:

• Experience managing a top-tier, full-scale group fitness program, its instructors and respective classes
• Familiarity working within the confines of an operating budget
• Proficiency with social media (photo, video and simple graphic design)
• Ability to process member feedback and work with a helpful volunteer committee
• Skilled communication and the ability to problem-solve on the fly
• A genuine interest in ensuring the department's growth with new programs and special events

Salary:

$65,000 - $75,000

Agency Information:

About Us

The Sephardic Community Center is an upscale group fitness studio located in a modern community center in southern Brooklyn.

Since 1982, we have loyally served a community of fitness fanatics who refuse days off and bring their A-game each morning. We are in love with fitness and hope that you are too.

Our Group X department operates five modern rooms, all wired professionally for sound. Our space includes a dedicated yoga room and spin room with 38 Stages cycles. We are fully stocked with the fitness equipment required for unforgettable classes: from weights and bands to stability balls and Viprs.

The music here is loud and the energy is real.

About Your Co-Workers

Will include an impossibly hard-working support staff of front desk workers, responsive maintenance team (for class set-up and breakdown), and a marketing team to support your new projects. You will report to a Director of Health & Wellness.

The "Center": Welcome Home

A fun, modern and clean place to work. Provides you complimentary access to our full-size fitness center, 25-yard swimming pool, locker room amenities, heavy program discounts, and more.