Systems Analyst

This Systems Analyst (Cityworks-GIS) role supports a public utility’s GIS and asset management platforms, with a strong focus on managing, analyzing, and optimizing asset data through ArcGIS, Cityworks, and enterprise databases. The ideal candidate is an SQL expert with advanced experience in SQL Developer, TOAD, SQLPlus, database design, query optimization, reporting, and data analysis, along with the ability to develop automation scripts using Python and SQL. This position also leads GIS and asset management initiatives, supports system integrations, and partners with stakeholders to improve operational efficiency and data-driven decision-making., 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. Using ESRI ArcGIS and Trimble Cityworks to manage and report on our GIS-based asset registries and the work performed on those assets.

• 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.
• Extensive 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)., * 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.