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='62D1C36D'
    

Location and Job Title:

Facilities Technician - Full Time
JCC of Binghamton, NY
500 Clubhouse Rd
Vestal, NY 13850

Principal Responsibilities:

The Opportunity: The Binghamton JCC is seeking a dynamic and experienced individual to oversee our facility. You will ensure that our 60,000 square foot facility sitting on 8-acres is well maintained and in good working condition. As part of your responsibilities, you will be hands-on for routine electrical, plumbing, HVAC, carpentry, painting, renovations, preventative maintenance, landscaping, snow plowing & salting, etc... When necessary, you may coordinate with contractors to handle non-routine projects. Our facility has over 200 children in our Early Childhood education programs. You will need to learn to schedule your work in classrooms around the children. Safety is our number one concern for the children. Overtime hours may be required, particularly during snow events. Opportunity exists for advancement to a supervisory position.

Salary: $20 per hour

Minimum Qualifications:

Who You Are: Our ideal candidate will have working knowledge of equipment and tools used to keep a large commercial size facility running efficiently and effectively. You should have a strong skillset that includes plumbing, HVAC, carpentry, electrical, painting, mowing, landscaping, plowing, salting, etc... Able to lift at least 75 pounds comfortably. All equipment and tools are provided. Clean driver's license is required. Reliable transportation is a must.

Hours are Monday - Friday, 6:30 AM - 3 PM with a 30-minute lunch break, for 40 hours per week.

Salary:

$35,000 - $45,000

Agency Information:

Why Join Us?

• Positive Impact: Contribute directly to the well-being and safety of our community.
• Dynamic Environment: Work in a supportive and vibrant environment that values innovation and dedication.

If you are passionate about working in a community-based organization and have a strong desire to contribute to the success of the Binghamton JCC, we encourage you to apply! Please submit your resume to Kathy Kiekel via email at kathyk@binghamtonjcc.org. We look forward to hearing from you!

Since its inception in 1927, the Jewish Community Center (JCC) of Binghamton, NY has grown to become an essential part of the Broome County community. As a full-service, non-profit organization, the JCC provides educational, cultural, recreational, and physical fitness programs to enhance the quality of life for all ages, from infants to senior citizens. As a non-sectarian United Way partner, the JCC welcomes participants regardless of age, race, religion, sexual orientation, nationality, or ability to pay.

The JCC's facility houses a natatorium with a 2,250 square foot pool, fitness center, men's and women's health clubs with steam & sauna rooms, a fitness loft with spin bikes and Pilates reformers, auditorium, and beautiful gymnasium. Over 200 children are served daily at our award-winning Early Childhood Center. Our year-round educational childcare includes UPK, after-school program, summer camp, and youth sports offerings.

The 8-acre land also features outdoor tennis/pickleball and basketball courts, pavilion, nature preserve, soccer field, and three age-appropriate playgrounds.