> Markdown version of [/jobs/ext/1990713-systems-analyst-sql-cityworks-gis](https://www.wearedevelopers.com/jobs/ext/1990713-systems-analyst-sql-cityworks-gis). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Systems Analyst - SQL (Cityworks / GIS)

- **Company:** THERON & COMPANY LLC
- **Location:** United States
- **Experience:** Experienced
- **Contract:** Temporary contract
- **Skills:** Data Analysis, Business Logic, ArcGIS (Software), ArcGIS Servers, ArcMap, Computerized Maintenance Management Systems, Database Design, Spatial Databases, Github, Python (Programming Language), PostgreSQL, Microsoft Visio, Query Optimization, Lucidchart, SQL*Plus, SQL Databases, Data Streaming, Systems Integration, Management of Software Versions, Information Technology, Toad (Software)
- **Published:** August 8, 2026
- **Apply:** https://www.dice.com/job-detail/a73d75bb-5e46-436e-9872-348a559272e2

## About the Role

* 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

## Description

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.


## Related Videos

- [What makes Cybersecurity different for critical infrastructure?](https://www.wearedevelopers.com/videos/571-what-makes-cybersecurity-different-for-critical-infrastructure)
- [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next)
- [Your organization as a Graph](https://www.wearedevelopers.com/videos/2051-your-organization-as-a-graph)
- [Bringing AI Model Testing and Prompt Management to Your Codebase with GitHub Models](https://www.wearedevelopers.com/videos/1536-bringing-ai-model-testing-and-prompt-management-to-your-codebase-with-github-models)
- [Tracking vehicles at scale](https://www.wearedevelopers.com/videos/1999-tracking-vehicles-at-scale)
- [CI/CD with Github Actions](https://www.wearedevelopers.com/videos/856-ci-cd-with-github-actions)

## Related Articles

- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Developers are Building the Cities of the Future](https://www.wearedevelopers.com/magazine/536-developers-are-building-the-cities-of-the-future)
- [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london)
- [A Guide to Green Tech and Green IT Careers](https://www.wearedevelopers.com/magazine/374-a-guide-to-green-tech-and-green-it-careers)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)