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

Location and Job Title:

Hourly Group Fitness Instructor/Personal Trainer
Kaiserman JCC
45 Haverford Rd
Wynnewood, PA 19096

Principal Responsibilities:

The Kaiserman JCC is looking to hire new Certified Group Exercise Instructors and Certified Personal Trainers passionate about delivering quality, safe, and fun fitness classes. Pay is hourly for each class and starts at $25/h and varies on certification level and experience. Our ideal candidate can lead exercise classes for adult and older adults. Areas of interest include: Zumba, Dance, Pilates, Yoga, Seated Yoga, Aerobics, Weight Training and more. If you have an idea for a new type of class, we'd love to consider it!

Minimum Qualifications:

• Certified in Fitness or Personal Training or other relevant area
• Able to commute to Wynnewood, PA
• Applicants must be over the age of 18

Salary:

Under $25,000

Agency Information:

The Kaiserman JCC is located in Wynnewood, PA, in the heart of the Main Line. We are a vibrant Jewish Community, just a few miles from Center City Philadelphia. We are home to the award-winning Camp Kef summer day camp and one of the most respected preschool & kindergarten programs in the region.

The mission of the Kaiserman JCC is to ensure a welcoming and inclusive environment where Jewish values inspire excellent social, recreational, educational, cultural, and humanitarian activities that embrace our identity and connection to Israel. The JCC is committed to serving our entire community and does not discriminate based on race, religion, sexual orientation or disability.

Since 1971, the Kaiserman JCC has worked to build a vibrant, inclusive, and supportive Jewish community and enhancing and deepening the commitment to Jewish philanthropy. We have also worked with people and partners across the region to nurture Jewish life and learning, help those in need and build connections with Israel and Jews around the world.