Public Works GIS Data Steward Analyst

Position Summary
Perform a variety of routine and complex skilled and technical work in the maintenance of a Geographic Information System (GIS) relating to the Public Works Computerized Maintenance Management System (CMMS) and asset management program. Act as the primary contact for Public Works CMMS data stewardship. Apply GIS technology to provide GIS and CMMS data related technical support. Perform research, analysis, design and creation of data and applications for use in the Geographic Information System. These tasks are illustrative only and may include other related duties.
Full-time 40 hours per week
AFSCME-represented position
12-month probationary period

Must meet all qualifications and requirements as listed in the position description.

Essential Functions
Collects, inputs, edits, and verifies spatial data from a variety of internal and external data inputs. Integrates associated attribute data. Manipulates, models, and analyzes spatial data in the geographic information system. Documents data entry and related procedures.

Maintains Public Works GIS datasets and mapping system. Applies GIS technology to produce and perform advanced data entry and manipulation, produces documentation, and performs spatial analysis. Develops and runs spatial queries and produces reports.

Modifies and maintains CMMS data to support asset data analysis. Collaborates with Asset Management staff 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.

Coordinates with Public Works program supervisors to efficiently and accurately enter data into the system. Collects and enters asset data into the CMMS and related databases from various sources including direct field investigation; documents such as as-built drawings, invoices, and O&M manuals.

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.

Performs quality control checks of asset data to ensure the accuracy of all data within the system.

Provides implementation and ongoing operational support for GIS/CMMS and GIS/CMMS users.

Provides system and data troubleshooting. Collaborates with IT to resolve system or data issues.

Develops programs, procedures, and applications using GIS and related software tools.

Applies software such as, CAD, database, spreadsheet, word processing, communications, graphics and web publishing software to the production and delivery of GIS related products.

Provides daily user support including routine troubleshooting and system and data maintenance for asset data analysis, working closely with Information Technology to evaluate responsibility for addressing specific requests.

Provides technical assistance and guidance to users of GIS products. Performs departmental-focused project management. Meets with GIS users to define project requirements and set priorities.

Participates on interdepartmental teams and committees for GIS and CMMS projects. Contributes to work group GIS software design projects. Maintains an understanding of the ESRI product portfolio and provides guidance for Public Works' use of available tools.

Operates printers, copiers and large-format plotters, and has ability to load large rolls of paper into plotters.

Acts ethically and honestly; applies ethical standards of behavior to daily work activities and interactions. Builds confidence in the City through own actions.

Conforms with all safety rules and performs work is a safe manner.

Delivers excellent customer service to diverse audiences. Maintains positive customer service demeanor and delivers service in a respectful and patient manner.

Maintains effective work relationships.

Arrives to work, meetings, and other work-related functions on time and maintains regular job attendance.

Complies will all Administrative Policies. Performs work in accordance with Council Policies and Municipal Code sections applicable to position.

Qualifications and Skills
Education and Experience
High School diploma or equivalent. Four years of professional experience in designing, supporting and implementing GIS applications. A post-secondary degree in GIS or closely related field may substitute for up to 4 years of experience.

Strong computer background in GIS software, Computer Aided Drafting software, related third party GIS software applications, database management systems software and windows based operating systems.

Municipal experience is desired.

Knowledge, Skills and Abilities
General 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.

Advanced skills in use of GIS and CMMS related software in a production environment.

Ability to program in GIS, relational and spatial database, and web languages is desired.

Good oral and written communication skills; ability to communicate technical information to a non-technical audience, ability to research, interpret and summarize data.

Ability to prioritize multiple projects from numerous customers.

Knowledge of cartographic principles, spatial analysis techniques, and data management practices.

Ability to research and recommend new methods, equipment, or programs to better accomplish tasks.

Ability to travel among City worksites.

Special Requirements
Demonstrable commitment to sustainability.

Demonstrable commitment to promoting and enhancing equity, diversity and inclusion.

The individual shall not pose a direct threat to the health or safety of the individual or others in the workplace.

Ability to pass a pre-employment background and/or criminal history check.

How to Apply
Qualified applicants must submit an online application located on the City of Corvallis website (click on "Apply" above).
Position is open until filled. Applications must be received by 5:00 PM on Wednesday, October 2, 2024, to be considered with the first review.
Applicants are encouraged to include a cover letter and resume with the online application; however, resumes will not be accepted in lieu of a completed online application. Late or incomplete applications will not be accepted/considered.
An Affirmative Action/Equal Opportunity Employer in Compliance with ADA.