Systems Analyst - SQL (Cityworks / GIS)

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.

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

CONTRACTOR, FULL_TIME, PART_TIME