Senior Utilities Data Analyst

McKim & Creed, Inc.•Wilmington, NC

2h•Remote

About The Position

We are seeking a Senior Utilities Data Analyst to join our Water Asset Management team and own the GIS application-development side of the practice. While our analyst-level team handles data operations, QA/QC, and client reporting, the Senior role takes the lead on building the tools that make that work scalable — designing Survey123 collection forms from scratch, developing Operations Dashboards and Experience Builder apps for client-facing visualization, and writing custom integrations against the ArcGIS API for Python and JavaScript. This is the role where engineering-grade GIS development meets utility data delivery: senior hires drive how M&C ships its analytics products, mentor the analysts who consume them, and contribute the modern AI integrations that are becoming part of every utility data stack.

Requirements

Python Programming: Production-grade Python — modular, tested, automated workflows for data ingestion, transformation, and analysis (Pandas, SQLAlchemy, HTTP libraries, Matplotlib / Plotly).
SQL & Database Management: Advanced SQL — schema design, query optimization, indexing strategy, and integration with operational data stores.
ArcGIS Pro: Advanced spatial analysis, custom geoprocessing tools, ModelBuilder, ArcPy scripting.
Survey123: Design and deploy custom field collection forms — conditional logic, dynamic content, integration with downstream systems.
Experience Builder & Operations Dashboards: Develop client-facing apps from scratch — data widget configuration, custom theming, embedded analytics.
ArcGIS API for Python & JavaScript: Build custom integrations, automation scripts, and web applications that extend the Esri platform.
AI / Modern Integrations: Experience connecting LLMs, ML services, or other modern tooling into Esri workflows (or strong interest in doing so).
Bachelor’s degree in Geography/GIS, Data Science, Computer Science, Engineering, or related field.
5–7+ years of professional experience in GIS development, data engineering, or utility analytics — at least 3 of those in a hands-on GIS development role.
Demonstrated portfolio of deployed Survey123 forms, Experience Builder apps, or ArcGIS API integrations (work-sample request likely at interview).
Strong analytical and problem-solving skills with the ability to interpret complex data and deliver meaningful insights.
Excellent written and verbal communication skills; comfortable engaging with clients and cross-functional teams.
Highly organized, self-motivated, and able to manage multiple tasks in a remote environment.
Valid driver’s license and acceptable motor vehicle and criminal record.

Nice To Haves

Direct utilities data experience — water, wastewater, or related utility sector.
Background in non-revenue water (NRW) programs, leak detection workflows, or wastewater inflow/infiltration (I&I) work.
Experience integrating telemetry vendors (Ovarro, Trimble, Sentryx, Ayyeka, DataGate, etc.) or SCADA systems into Esri / GIS workflows.
Hands-on experience with AI-augmented GIS workflows — LLM-driven data classification, computer vision for asset inspection, ML for anomaly detection.
Track record mentoring junior analysts into GIS development competence.
Familiarity with Grafana, Power BI, or similar dashboarding platforms alongside the Esri stack.
Demonstrated ability to translate utility-side operational requirements into delivered GIS applications.

Responsibilities

Design, build, and deploy Survey123 collection forms aligned to utility field workflows.
Develop Operations Dashboards and Experience Builder apps that translate raw sensor and meter data into actionable client-facing tools.
Build and maintain custom integrations against the ArcGIS API for Python and JavaScript, including AI/ML-enabled workflows where they earn their place.
Architect end-to-end data + GIS solutions for utility clients — from field collection through dashboard delivery — balancing Esri-native tools with custom Python/SQL plumbing.
Define data models, schemas, and integration patterns that the analyst team can pick up and operate.
Set the technical bar for the WAM team’s GIS development output — code review, pattern reuse, documentation standards.
Triage and resolve the high-complexity issues that the analyst team escalates.
Lead technical conversations with utility clients during scoping, demos, and implementation reviews.
Translate utility-side requirements into the application architecture that delivers them.
Pair with analyst-level team members to accelerate their growth into form authoring, Experience Builder development, and API work.
Maintain a culture where the team’s collective skill ceiling rises over time.