Data (GIS & Cityworks) Analyst

Ampcus Inc.•Woodbridge, VA

2d•Hybrid

About The Position

Ampcus Inc. is seeking a Data (GIS & Cityworks) Analyst to support software applications used in managing GIS-based horizontal and vertical asset registries. The client utilizes ESRI ArcGIS and Trimble Cityworks for managing and reporting on these asset registries and associated work. This role involves advanced data analysis, script development, and supporting a GIS environment.

Requirements

Associate’s degree in Geography, GIS, Engineering, Computer Science, or related field.
Three years of relevant experience, preferably within a water utility.
Knowledge of ESRI ArcGIS Pro, ArcGIS Server, and Trimble Cityworks (or ability to obtain within 6–8 months).
Ability to mentor and review the work of another team member.
Knowledge of geodatabase versioning workflows and the ability to learn and demonstrate SDE versioning data flows.
Experience using SQL Developer, TOAD, SQLPlus, PyWin; and LucidChart, Visio, GitHub (for diagramming).
Knowledge of database design best practices, including design for the three degrees of cardinality.
Demonstrated willingness to embrace changing technology landscapes and quickly learn new skills.
Effective collaborator.

Nice To Haves

Experience publishing varying services using ArcGIS Server.
Ability to share content online using ArcGIS Pro or ArcMap to ArcGIS Online or ArcGIS Portal.
Ability to perform installations and configurations of ArcGIS desktop software.
Ability to support administration of a three-tiered GIS environment.
Experience developing runbooks, SLAs, and SOPs to support knowledge sharing and redundancy.

Responsibilities

Create complex spatial and tabular visualizations and reports using GIS and Cityworks data.
Develop spatial database tables for testing, analysis, and map creation.
Conduct statistical analysis (e.g., parametric testing, geo-statistical analysis, variance) using business data.
Publish varying services using ArcGIS Server.
Share content online using ArcGIS Pro or ArcMap to ArcGIS Online or ArcGIS Portal.
Conduct advanced data analysis (spatial and tabular).
Develop and maintain scripts using Python and PSQL for task automation.
Perform installations and configurations of ArcGIS desktop software.
Support administration of a three-tiered GIS environment.
Validate GIS or CMMS data against business logic related to collection and distribution networks (e.g., tee main size, sewer flow direction).
Develop runbooks, SLAs, and SOPs to support knowledge sharing and redundancy.
Lead GIS, asset management, and governance projects, including identifying risks and dependencies, breaking down tasks into activities, schedules, and durations, and leading collaborative project meetings.
Proactively explore emerging technologies that may benefit the organization.