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='82688B3A'
    

Location and Job Title:

Lifeguard
Kaplen JCC on the Palisades
411 E. Clinton Ave.
Tenafly, NJ 07670

Principal Responsibilities:

The JCCOTP is looking for qualified lifeguards to join our team for summer 2025. The primary responsibility is to ensure the safety of patrons in and around the pool. Additional responsibilities will include observing and enforcing all aquatic policies, rules and regulations, recognizing and responding efficiently in emergencies, and participating in monthly staff in-services. Various shifts available. $16.50-$17.50/hour

Minimum Qualifications:

Must hold valid Lifeguarding/First Aid/CPR/AED certification.

Salary:

Under $25,000

Agency Information:

The Kaplen JCC on the Palisades aquatic center includes a six-lane, 25-meter indoor pool; heated indoor kid-sized training pool; a five-lane, 25-meter outdoor pool with a diving board; and an outdoor intermediate and baby pool, as well as a water park.