Senior Utilities Data Analyst

Mckim & Creed
Wilmington, NC, United States
3 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours
Job source

Tech stack

JavaScript (Programming Language) Geographic Information Systems Application Programming Interfaces (APIs) Artificial Intelligence Business Analytics Applications Applications Architecture ArcGIS (Software) Computer Vision Automation of Tests Software Documentation Code Review Information Engineering
+27 more
GIS Applications Hypertext Transfer Protocols (HTTP) Supervisory Control and Data Acquisition (SCADA) Python (Programming Language) Operational Data Store Query Optimization Power BI Azure Machine Learning Software Engineering SQL Databases SQLAlchemy Systems Integration Web Applications Esri GIS (Software) Data Classification Data Ingestion Sql Optimization Large Language Models Grafana Pandas Matplotlib Information Technology Enterprise Integration Plotly Dynamic Content Data Delivery Api Management

Job description

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. DURING YOUR WORK DAY, YOU WILL: Application Development

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

Solution Design

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

Technical Leadership

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

Client Engagement

  • Lead technical conversations with utility clients during scoping, demos, and implementation reviews.
  • Translate utility-side requirements into the application architecture that delivers them.

Mentorship

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

WHAT YOU’LL NEED: Technical Skills

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

Requirements

Do you have a valid Driver’s License license?, Do you have experience in Writing skills?, 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.

WHAT WILL MAKE YOU STAND OUT:

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

Benefits & conditions

Pulled from the full job description

  • Tuition reimbursement
  • Military leave
  • Employee stock ownership plan
  • Paid holidays, Ranked as one of the Best Firms to Work For, here are just some of the reasons to become part of the McKim & Creed team:
  • Employee Stock Ownership Plan (ESOP): All employees are owners & benefit from profits earned.
  • Competitive pay: Paid holidays, bereavement, and parental, medical, and military leave.
  • Multiple office locations to work from: Stick close to home or travel for a change of scenery.
  • Growth opportunities & training: Grow confidently in your career with our mentoring & training options.
  • Professional development: Tuition reimbursement, early career professional program, online courses & more.
  • Work that makes a difference: See the direct impact your work has on our communities.
  • Collaborative, supportive team: People to help you solve problems, cheer successes & encourage you along the way.

McKim & Creed is an Equal Opportunity and Affirmative Action Employer, and VEVRAA Federal Contractor and will consider all qualified applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status or disability status and maintains a Drug Free Workplace.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:28 min

Identifying root causes through global and local SHAP plots

Bernhard Bernhard +1 ¡ WWC 2025

2:03 min

Accelerating pandas dataframes using cudf module plugins

Ankit Patel Ankit Patel ¡ WWC 2024

10:40 min

Visualizing Prometheus open metrics using custom Grafana dashboards

Stijn Polfliet ¡ LIVE

4:10 min

Introduction to technical background and geospatial roles

Joana Simoes ¡ LIVE

9:52 min

Live Matplotlib rendering and data plotting within Deepnote environments

Radovan Kavický ¡ LIVE

4:38 min

Visualizing source data with the TensorFlow visualization component

Hükan Silfvernagel ¡ LIVE

Videos

See all

Related articles

See all