Systems Analyst (Cityworks- GIS)

Ampcus Inc.•Woodbridge, VA

2d•Hybrid

About The Position

Ampcus Inc. is seeking a Systems Analyst (Cityworks - GIS Integration) to support software applications used in the management of GIS-based horizontal and vertical asset registries. The role involves utilizing ESRI ArcGIS and Trimble Cityworks for managing and reporting on GIS-based asset registries and associated work performed on those assets. This is a hybrid position, requiring 3 days onsite per week, with an initial duration of 12 months and possible extension.

Requirements

Associate’s degree in Geography, GIS, Engineering, Computer Science, or related field.
Three years of relevant experience, preferably within a water utility.
Demonstrated experience in database management (design, querying, and optimization).
Proven project management experience, including planning, coordinating tasks, and tracking deliverables across project lifecycles.
Knowledge of ESRI ArcGIS Pro, ArcGIS Server, and Trimble Cityworks (must possess or have the ability to obtain within 6–8 months).
Ability to create complex spatial and tabular visualizations and reports using GIS and Cityworks data.
Ability to develop spatial database tables for testing, analysis, and map creation.
Ability to mentor and review the work of another team member.
Ability to conduct statistical analysis (e.g., parametric testing, geo-statistical analysis, variance) using business data.
Advanced analytical skills, including the ability to think critically.
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).
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 conduct advanced data analysis (spatial and tabular).
Ability to develop and maintain scripts using Python and PSQL for task automation.
Ability to perform installations and configurations of ArcGIS desktop software.
Knowledge of database design best practices, including design for the three degrees of cardinality.
Ability to support administration of a three-tiered GIS environment.
Ability to validate GIS or CMMS data against business logic related to collection and distribution networks (e.g., tee main size, sewer flow direction).
Experience developing runbooks, SLAs, and SOPs to support knowledge sharing and redundancy.
Experience leading GIS, asset management, and governance projects, including: Identifying risks and dependencies between operational tasks and ongoing projects. Breaking down tasks into activities, schedules, and durations within a project lifecycle. Leading and facilitating collaborative, productive, and efficient project meetings.
Demonstrated willingness to embrace changing technology landscapes and quickly learn new skills.

Responsibilities

Support software applications used in the management of GIS-based horizontal and vertical asset registries.
Manage and report on GIS-based asset registries and the work performed on those assets using ESRI ArcGIS and Trimble Cityworks.
Create complex spatial and tabular visualizations and reports using GIS and Cityworks data.
Develop spatial database tables for testing, analysis, and map creation.
Mentor and review the work of another team member.
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.
Identify risks and dependencies between operational tasks and ongoing projects.
Break down tasks into activities, schedules, and durations within a project lifecycle.
Lead and facilitate collaborative, productive, and efficient project meetings.