Posted: Sep 19, 2024
APPLY

Public Works GIS Data Steward Analyst

City of Corvallis - Corvallis, OR
Full-time
Salary: $31.92 - $40.59 Hourly
Application Deadline: N/A
Government

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.

 

 

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 Requirements

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.