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

Location and Job Title:

Facilities Assistant
Greater Raleigh JCC /Jewish Federation of Greater Raleigh
David R. Kahn Community Campus
12804 Norwood Rd
Raleigh, NC 27613

Principal Responsibilities:

The JCC of Greater Raleigh at the David R. Kahn Community Campus is looking for an enthusiastic individual to join our organization as full-time Campus Facilities Assistant. As part of our facilities team, you will be an integral part of helping us to meaningfully connect, care for and strengthen our community.In this position you will be performing a variety of tasks related to the operation and maintenance of the Campus 's buildings, facilities and grounds as well as being a friendly face able to assist our members, renters and guests. This can be a physically demanding position at times. You must enjoy working outdoors, be able to stand and walk for extended periods and occasionally lift items up to 50 lbs. throughout a standard shift. Our ideal candidate has a strong work ethic and experience with facilities maintenance, is self-motivated with excellent time management skills with the ability to shift priorities as necessary, is competent using both hand and power tools, and is friendly with strong verbal communication skills.

Work Schedule: Tuesday-Saturday

Minimum Qualifications:

Duties and Responsibilities

• Attend to the grounds and facilities, maintaining a safe, clean, and well-kept campus appearance
• Open and/or Close access to Campus as needed
• Ensure Opening procedures are maintained daily
• Monitor and help direct traffic and parking lot flow as needed
• Ensure appropriate directional signage is displayed
• Monitor and maintain restrooms and public area trash receptacles
• Assist Camp and Program Leaders, JCC Members, renters and visitors as needed
• Identify maintenance issues and work as part of a team to implement strategies to resolve problems and promote an optimal work environment
• Landscape/grounds maintenance
• Painting
• Trail maintenance
• Other tasks as needed

Experience & Qualifications

• Ability to perform physically demanding tasks outdoors
• Exhibits good judgment, self-confidence, cool headedness, and common sense
• Must demonstrate competency using and maintaining hand tools and power tools
• Valid driver's license, good driving record, and reliable transportation
• Background check required

Salary:

$35,000 - $45,000

Agency Information:

The Jewish Federation of Greater Raleigh is the central hub of Jewish life in Wake County and surrounding areas. The Jewish Federation includes our agencies: Jewish Family Services, Jewish Community Center, Jewish Community Relations Council, and the Jewish Community Foundation. Our agencies of the fulfill the Jewish Federation's mission, Welcome, engage, and enhance Jewish life through connection care, and community. We welcome, respect and value the participation of all people including, multi-faith families, people of all abilities, religious practices, backgrounds, sexual orientation, gender identity, race and socio-economic status.

To learn more about JCC programs and services visit www.RaleighCaryJCC.org.