Senior GIS Data Analyst; Utilities

OVERVIEW: We are seeking a highly motivated Senior GIS Data Analyst to join our Water Asset Management team, remotely, in the Southeast, supporting data operations in the water conservation, asset management, and IoT sectors. The ideal candidate will play a critical role in collecting, analyzing, and interpreting data from a diverse range of sources, including IoT sensors, GIS systems, utility asset registries, and client platforms.

This position involves developing actionable insights to optimize processes, improve decision-making, and enhance operational efficiency. The Senior Data Analyst will manage and analyze large datasets, maintain utility asset data in Esri geodatabases, design and implement data visualization dashboards, and maintain integrations across various systems. This role also contributes to the ongoing development of McKim & Creed's data platform-collaborating with engineers and project managers to refine analytics, algorithms, and reporting tools that drive our mission of water conservation and smart resource management.

DURING YOUR WORK DAY, YOU WILL:

Data Quality Assurance and Control

• Conduct daily QA/QC of incoming meter, SCADA, and telemetry feeds to ensure consistency, accuracy, and completeness.
• Identify and resolve discrepancies or anomalies to maintain data integrity and reliability.

GIS Asset Data Management

• Maintain and edit utility asset data in Esri geodatabases - including Utility Network and other water/wastewater asset data models - keeping attribution, connectivity, and asset hierarchies accurate and current.
• Support asset registry workflows: as-built and plan-sheet incorporation, attribute population, condition and criticality fields, and reconciliation against client systems of record (Cityworks, Maximo, Lucity, Cartegraph, or similar).
• Run and document data validation, topology and network error resolution, and versioned editing workflows; maintain the supporting data dictionaries and QA checklists.

Client Communication and Insights Delivery

• Provide daily updates to clients regarding event notifications, significant trend identifications, and actionable insights derived from data analysis.
• Establish strong communication channels to foster collaboration and trust.

Inventory Monitoring and Management

• Perform daily inventory checks across all project locations, ensuring minimum field-deployable sensor inventory thresholds are maintained.
• Collaborate with relevant teams to address inventory shortages proactively.

Maintenance Coordination

• Maintain daily correspondence with maintenance staff to coordinate product allocations and schedule maintenance activities.
• Ensure timely interventions to minimize downtime and improve operational efficiency.

Client Relationship Management

• Conduct weekly client meetings to review reports, discuss project progress, and identify opportunities to expand or enhance service offerings.
• Build and sustain strong client relationships through consistent engagement and problem-solving.

WHAT YOU'LL NEED:

Technical Skills

• Python Programming: Proficiency in Python for data manipulation, analysis, and workflow automation (Pandas, Num Py, Matplotlib preferred).
• SQL & Database Management: Strong SQL skills for querying and managing large relational datasets; experience optimizing queries and ensuring data efficiency.
• Spatial Data Engineering: Experience designing and maintaining spatial data pipelines - ingesting, transforming, and publishing geospatial and time-series data across systems; spatial SQL (PostGIS or ArcSDE), coordinate systems and projections, and schema design for large multi-source datasets.
• AI-Assisted Development: Practical use of AI coding assistants and agentic tools (Claude, Copilot, or similar) to build internal applications, analysis…