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='478D0957'
    

Location and Job Title:

Swim Instructor
JCC of Stamford
1035 Newfield Ave
Stamford, CT 06905

Principal Responsibilities:

The Stamford JCC is currently looking for experienced swim instructors. Flexible hours, competitive rate. Full time and part time offerings.

Hourly Rate: $40 to $50/hr.

Minimum Qualifications:

Requirements:

- Red Cross lifeguarding, First Aid, CPR and AED.

- WSI certification preferred.

- Ability to work with children of all ages and adult

- Ability to teach parent child classes.

- Weekend availability required.

- Great communications and customer service skills.

- Assist in the evaluation of swim lesson programs.

- Instructor may be required to "shadow" or co-teach to teach, before being give classes of their own.

- Swim Team coaching experience preferred.

Salary:

$65,000 - $75,000

Agency Information:

The Stamford Jewish Community Center is a cultural, educational and recreational center, offering exceptional programs, classes and special events designed to enrich the mind, body and spirit. While we are driven by the Jewish values of welcoming guests, kindness, respect, and communal responsibility, we warmly welcome people of all ages, faiths, ethnicities and backgrounds.