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

Location and Job Title:

Maintenance Specialist
Louis S. Wolk Jewish Community Center of Greater Rochester
1200 Edgewood Ave
Rochester, NY 14618

Principal Responsibilities:

• Support the maintenance, upkeep of buildings, grounds, equipment, vehicles, and roads by performing the "hands-on" work needed through-out the year.
• Perform preventative and corrective maintenance functions for the camp.
• Commitment to availability and responsiveness for on-call maintenance needs.
• Maintain property to meet the requirements for New York State Health Department and American Camping Association.
• Ensure all facilities and the grounds are safe for campers and staff. Maintain a high quality of cleanliness in all facilities.

• Support the Assistant Director in opening/closing day luggage moving and logistics, including pick up and drop off luggage in Rochester
• Support maintenance team in moving campers' luggage within camp during drop off to appropriate villages

• Attend required meetings or training.
• Perform other duties as assigned.

Minimum Qualifications:

Key Competencies for Success:

• Represent a positive image of the CSL when interacting with campers, camp families and the CSL/JCC staff
• Demonstrated ability to effectively communicate with a diverse group of staff and campers
• Creativity and ingenuity to effectively achieve a wide variety of maintenance needs in an outdoor summer camp setting, at times with a limited budget
• Solid teamwork skills

Education:

• High school diploma or general education degree (GED) preferred.

Experience:

• 2+ years related experience or training
• Mechanical aptitude and experience with carpentry, electrical, or plumbing, preferred

Other Requirements:

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.

Physical Demands: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job the employee is regularly required to:

• Physical mobility and endurance to perform tasks while standing/walking for extended periods of time
• Stand, walk, sit, reach with hands and arms, grasping and twisting, climb or balance.
• Stoop, kneel, crouch or crawl
• Lift and/or move over 75 pounds on a repetitive basis
• Use of computer keyboard
• May handle chemicals as part of the daily operational duties

Work Environment: The work environment characteristics described here are representative of those an employee encounters while performing the essential function of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform within the described work disabilities to perform within the described work environment.

While performing the duties of this job the employee is regularly exposed to:

• Indoor and outdoor environments
• Remote locations and uneven terrain on camp property
• Exposure to noise, dust, dirt
• Exposure to critters (rodents, deer, etc)
• Natural weather elements
• Risk of electrical shock, fumes, toxic or caustic chemicals
• Ability to assist children and staff in an emergency

EOE/Disability/Veteran

Salary:

Under $25,000

Agency Information:

The Jewish Community Center of Greater Rochester is located alongside the Erie Canal in Brighton and is a 200,000 square foot facility that houses our state-of-the-art fitness, wellness and recreation programming, an aquatics center, a Professional Theatre (live stream), Children's Center and our Premier Camping Program! We pride ourselves on providing our members with quality educational, cultural arts and social programming, and we are an inclusive community center that welcomes people of all faiths, backgrounds, and ages.

Camp Seneca Lake is Western NY's premier Jewish overnight camp providing generations of campers with transformative Jewish experiences for 99 summers. Nestled on the shores of Seneca Lake, our beautiful 200-acre property provides the perfect backdrop for campers from around the country and beyond with fun, adventure and friendship.