Data (GIS & Cityworks) Analyst

Job Description

• Client is seeking to recruit a Data (GIS & Cityworks) Analyst 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.

Minimum Qualifications and Requirements

• Associate's degree in Geography, GIS, Engineering, Computer Science, or related field.
• Three years of relevant experience, preferably within a water utility.

Must possess or have the ability to obtain within 6-8 months:

• 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 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.
• Effective collaborator who proactively explores emerging technologies that may benefit the organization.
• Ability to work onsite 3 days per week (5 days total workweek).