Salary: $28.35 – $36.12 Hourly
Location : Albany, OR
Job Type: Regular, Full-time
Job Number: 00778
Department: Public Works
Division: Facilities Maintenance Services
Opening Date: 07/17/2023
General Description
The City of Albany Facilities Maintenance Division within the Public Works Department seeks a full-time professional Computer Maintenance Management Systems (CMMS) Analyst. This position performs a variety of technical work in the day-to-day operation of the Public Works Computerized Maintenance Management System (CMMS) and Geographical Information System (GIS); provides support and training to end users as assigned.
Screening Timeline:
Initial application review will take place on Friday, August 4, 2023. Applications received after this date will be reviewed as needed.
NOTE: This position is full benefits eligible. Out-of-pocket cost for medical, dental, and vision coverage is approx. $48/mo. for employee only coverage up to a max of $137/mo. for family coverage.
Essential Functions/Duties & Responsibilities
The duties listed are intended only as illustrative examples of the various types of work that may be performed by individuals in this classification. Any of the following duties may be performed. These examples are not necessarily performed by all incumbents and do not include all specific essential functions and responsibilities the incumbent may be expected to perform.
- Modifies and maintains CMMS and GIS data to support asset data analysis. Works independently with vendors, and Public Works supervisors to assist in program development by gathering information for assets and other new and old data and information needed to allow the asset data system to function effectively; creates new codes for the above areas mentioned and when necessary, modifies asset characteristics and descriptions.
- Provides daily user support including routine troubleshooting and system and data maintenance for asset data analysis, working closely with information technology staff and Technical Services Supervisor to evaluate responsibility for addressing specific requests.
- Assists CMMS Analyst II with the establishment and maintenance of user profiles within the CMMS, e.g., security settings and access controls for each program user.
- Assists with establishing equipment and asset records; associates the manufacturer’s maintenance recommendations with the records. Defines, compiles, and incorporates maintenance activities in the CMMS system. Provides guidance and support to end users in the operation, use, and capabilities of the CMMS.
- Coordinates with Public Works program supervisors to enter data efficiently and accurately into the system. Transposes data from source documents such as as-builts into the CMMS, ArcGIS, or related databases.
- Generates standard and ad-hoc reports using the standard report structure of the asset data system, and other end user reporting tools, provides information for the preparation and distribution of periodic standard location and equipment reports to support maintenance teams and management requests.
- Assists with hardware and software upgrades for the asset data analysis system.
- Performs quality control checks of asset data to ensure the accuracy of all data within the system.
- Provides input to Technical Services Supervisor on system needs, the performance of asset data software and hardware, and improvements to the asset data analysis system.
- Gathers and creates system requirements documentation by taking input from system users, customers and other stakeholders that outline what the CMMS will do to help a business achieve their objectives.
- Provides in-house training programs and manuals for asset data analysis software.
- Maintains professional networks and attends training sessions and conferences as necessary to advance skills and keep abreast of issues and practices in all areas of responsibility.
- Represents the City of Albany by responding to the public, citizens, its employees, and others in a prompt, professional, and courteous manner while continuously maintaining a positive customer service demeanor. Regards everyone, internal and external, as a customer and deliver the best service possible in a respectful and patient manner.
- Works to create a high-performance work culture by demonstrating a positive attitude and modeling the City’s mission, vision, and values. Conducts self with high integrity, proactive in conserving City resources, and seeks and incorporates customer feedback for ongoing performance improvement. Demonstrates continuous effort to improve operations, decrease turnaround times, streamline work processes, and work cooperatively and jointly to provide quality customer service.
- Serves as a member of various City committees as assigned.
- Assists other staff in the performance of their duties as assigned; and may provide training and orientation to new assigned personnel.
- Maintains regular job attendance and adherence to working hours.
- Adheres to appropriate attire, grooming, and hygiene standards established for the position.
- Operates a motor vehicle safely and legally.
- Performs other related duties as required/assigned.
Supervision/Lead Work Exercised
This is a non-supervisory position. Lead work/coordination of the work of others is not a typical function assigned to this position. Incumbents in this position may provide training and orientation to newly assigned personnel.
Qualifications & Requirements
EDUCATION AND EXPERIENCE
A high school diploma or its equivalent and five years of related experience including significant responsible experience in the maintenance and use of a database application system, GIS software; or an equivalent combination of education and experience that provides the required knowledge, skills, and abilities.
Special Requirements:
- Possession of or ability to obtain a valid Oregon driver’s license.
- The individual shall not pose a direct threat to the health or safety of themselves or others.
KNOWLEDGE, SKILLS, AND ABILITIES
Knowledge of: the principles, theories and methods of database concepts, structures, and programming logic; and the various types, classes, uses, and interrelationships of assets within a typical municipal Public Works department.
Skill in: operation of listed tools and equipment used; CMMS software including creating, editing, and reporting on assets; GIS software including editing and modifying new and existing infrastructure; and demonstrated effective verbal, written, presentation, and communication skills.
Ability to: be a member of a self-directed, customer-oriented work team; listen to and interpret non-technical user requests or problems; operate and use various computers, computer-aided devices and software such as graphic workstations, GIS or CAD, and digitizers; communicate effectively, verbally and in writing; understand and carry out written and oral instructions; establish and maintain effective working relationships with employees, other departments, and the public.
The City of Albany offers a generous benefits package to employees and eligible dependents.
This position is represented by American Federation of State, County, and Municipal employees (AFSCME). For a complete and detailed overview of the AFSCME benefits package,
Salary and benefits are subject to negotiation and, therefore, may change as a result of negotiations.
01
What is your education background? (select the highest level achieved)
- Did Not Complete High School
- High School Diploma or GED
- Technical College
- AA Degree
- BA or BS Degree
- MA Degree
- PhD
02
Does your education include major coursework in database systems or a related field?
- Yes
- No
03
How many years of experience do you have with CMMS systems?
- 1-2 years
- 2-5 years
- More than 5 years
- None
04
Which of the following best describes the experience you have with CMMS systems? Check all that apply.
- Creating and modifying assets
- Creating work orders
- Analysis and reporting on asset data
- Process documentation
- User support and training
- Creating/modifying reports and data entry forms
- None of the above
05
Do you have experience with other enterprise software? If yes, briefly explain the software used. If no, indicate “N/A.”
06
How many years of experience do you have with GIS software?
- 1-2 years
- 2-5 years
- More than 5 years
- None
07
Which of the following best describes your experience with GIS systems? Check all that apply.
- Using maps
- Creating simple map documents
- Creating maps of moderate complexity with data filters and symbology
- Modify GIS data and graphics
- Using GIS systems for analysis
- None of the above
08
Select the areas in which you have 2 or more years of experience:
- Data entry
- Data analysis
- Collect and document asset data
- Data modeling and analysis
- Report writing
- End user training
- Implementing preventative maintenance programs
- Using cartography software
- Microsoft Excel
- SQL
- None of the above
09
Check the Public Works infrastructure below with which you have experience:
- Wastewater Lift Station Equipment
- Water Distribution Systems
- Wastewater Treatment Facilities
- Water Treatment Facilities
- Wastewater Collection System
- Storm Water Collection Systems
- Street Facilities and Equipment
- Other Industrial Facilities
- None of the above
10
If you checked “other” in question above, briefly list experience. If you did not check “other,” write NA in box below.
11
This position may occasionally require you to work after hours, possibly on a weekend, or on a holiday as needed. Are you able to work outside the routine work schedule as needed/required?
- Yes
- No
12
Do you possess a current Oregon Driver’s License or have the ability to obtain this upon hire?
- Yes
- No
13
Have you received any of the following traffic convictions? Select all that apply.
- One class “A” infraction conviction during the past thirty-six (36) months?
- More than one class “A” infraction conviction between the past (36) and (60) months?
- More than one class “B” infraction conviction during the past twelve (12) months?
- More than two class “B” infraction convictions during the past thirty-six (36) months?
- More than two class “C” infraction convictions during the past twelve (12) months?
- More than three class “C” infraction convictions during the past thirty-six (36) months?
- Any misdemeanor driving convictions within the past twenty-four (24) months?
- Any felony driving convictions within the past sixty (60) months?
- None
Required Question