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='5E881A67'
    

Location and Job Title:

Maintenance Technician
B'nai B'rith Camp
6443 SW Beaverton-Hillsdale Hwy
Suite #234
Portland, OR 97221

Principal Responsibilities:

BB Camp seeks a dynamic, experienced Maintenance Technician to perform various non-routine and skilled maintenance activities on the facilities' buildings, grounds, and equipment. The Maintenance Technician is responsible for assisting in maintaining and improving BB Camp's physical spaces. This includes, but is not limited to, assisting in housekeeping and maintenance needs, cleaning common areas, maintaining and improving landscaping, and assisting on large ongoing maintenance projects.

The Maintenance Technician will report to the Facilities Director and work closely and collaboratively with the organization's staff members, campers, and guests.

Minimum Qualifications:

• High School Diploma or Equivalent
• At least 1 year of experience in maintenance work preferred

• Proven leadership and communication skills
• Ability to work in a team environment and to collaborate effectively with several different stakeholders.
• Excellent organizational, project management, and problem-solving skills
• Proven experience in maintenance and repair activities
• Prioritizes inclusivity within the work that is produced
• Ability to be flexible and manage change

Salary:

$35,000 - $45,000

Agency Information:

BB Camp, located on the Oregon coast, is a premier camp and conference center in the Pacific Northwest. Since 1921, BB Camp has been dedicated to providing the finest summer overnight camp experience for today's campers while preparing them to be tomorrow's community leaders. Since 2006, BB Camp has been serving the local community with our day camp program. In addition to our summer camp programs, we rent our facility for conferences, retreats, and special events. BB Camp is open to everyone. BB Camp is licensed by the State of Oregon, accredited by the American Camp Association (ACA), and a member of the JCC Association. www.bb-360.org