Public Works GIS Data Steward Analyst

City of Corvallis, OR - Corvallis, OR

Full-time - Entry Level

Corvallis, OR

Executive, Legislative, and Other General Government Support

About the position

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.

Responsibilities

• 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.
• Creates new codes for asset data and 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.
• Generates standard and ad-hoc reports using the standard report structure of the asset data system.
• Provides information for the preparation and distribution of periodic standard location and equipment reports.
• 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.
• Provides daily user support including routine troubleshooting and system and data maintenance.
• Provides technical assistance and guidance to users of GIS products.
• Performs departmental-focused project management.
• 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.
• Operates printers, copiers and large-format plotters.
• Acts ethically and honestly; applies ethical standards of behavior to daily work activities.
• Delivers excellent customer service to diverse audiences.
• Maintains effective work relationships.
• Arrives to work, meetings, and other work-related functions on time.
• Complies with all Administrative Policies.

Requirements

• 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.

Nice-to-haves

• 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.
• 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.

Benefits

• Comprehensive benefits package to employees and eligible dependents.
• AFSCME Benefits Summary.