Geographic Information Systems Analyst

ESRI/Arc/Cityworks experience is good to have. Willingness to learn the environment.

We are seeking to recruit a Systems Analyst (Cityworks - GIS Integration) to support software applications used in the management of our GIS-based horizontal and vertical asset registries. Client uses ESRI ArcGIS and Trimble Cityworks to manage and report on our GIS-based asset registries and the work performed on those assets.

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

• Knowledge of ESRI ArcGIS Pro, ArcGIS Server, and Trimble Cityworks.
• 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 Lucid Chart, Visio, Git Hub (for diagramming).
• Experience publishing varying services using ArcGIS Server.
• Ability to share content online using ArcGIS Pro or Arc Map 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.

• 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.
• Effective collaborator who proactively explores emerging technologies that may benefit the organization.