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

• Associates 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 68 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).