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='98980F5B'
    

Location and Job Title:

Maintenance/custodian. Second shift/weekends
JCC of Stamford
1035 Newfield Ave
Stamford, CT 06905

Principal Responsibilities:

This position supports the work at the JCC, a leading nonprofit cultural, educational center offering exceptional programs, classes and special events designed to enrich the mind, body and spirit. Including: cleans and sanitizes assigned areas, mopping, dusting, and trash removal. May complete duties related to window washing, meeting set up, pool cleaning, checking and cleaning Women's locker rooms and bathrooms during and after hours, grounds keeping, and other related responsibilities.

Minimum Qualifications:

• Keeping the JCC clean and attractive by completing all duties listed on the daily schedule and maintaining upkeep for assigned areas and equipment. Main responsibilities include wet mopping, dusting, trash removal, recycling, window washing, pool cleaning, painting, vacuuming, seasonal activities dealing with lawn care and snow removal, and general cleaning.
• Checking and cleaning Women's bathrooms, locker rooms and shower areas during opening and finish cleaning to prepare areas for the next day.

• Record and report all needed repairs; perform repairs as directed.

• Make sure the JCC building and outdoor property is secure, constantly check for trash, any broken playground pieces and other duties during your shift and report incidents and hazardous conditions to supervisor.

• Replace soap, paper towels, and other supplies.

• Setup and break down areas before and after meetings, events and other activities.

• Performs other duties as assigned.
• Able to lift up to 50 lbs.

Salary:

$35,000 - $45,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.