Senior Utilities Data Analyst

OVERVIEW: 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.

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.

GIS Development:
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.

WHAT WE OFFER: Join a company that puts its employees first.
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.