GIS Data Analyst (Utilities)

McKim & Creed, Inc.•,

11d•Remote

About The Position

We are seeking a highly motivated GIS Data Analyst to join our Water Asset Management team, supporting data operations in the water conservation 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, and client platforms. This position involves developing actionable insights to optimize processes, improve decision-making, and enhance operational efficiency. The Data Analyst will manage and analyze large datasets, 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.

Requirements

Proficiency in Python for data manipulation, analysis, and workflow automation (Pandas, NumPy, Matplotlib preferred).
Strong SQL skills for querying and managing large relational datasets; experience optimizing queries and ensuring data efficiency.
Comfortable with spatial analysis, mapping, and basic geoprocessing for QA/QC and reporting workflows using ArcGIS Pro.
Comfortable using deployed forms, validating field-collected data, and troubleshooting field-side issues with Survey123 & Field Maps.
Comfortable navigating and interpreting client-facing dashboards and apps using Operations Dashboard & Experience Builder.
Bachelor’s degree in Geography/GIS, Data Science, Computer Science, Engineering, or related field.
3–5+ years of professional experience in data analysis, GIS, or IoT-related analytics.
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 with data QA/QC workflows from field collection through delivery.
Experience building API integrations to telemetry vendors (Ovarro, Trimble, Sentryx, Ayyeka, DataGate, etc.) or SCADA systems.
Early exposure to Survey123 form authoring, Experience Builder, or ArcGIS API (Python or JavaScript) work.
Familiarity with Grafana, Power BI, or similar dashboarding platforms for time-series and event visualization.
Demonstrated ability to translate data into clear, actionable insights for clients.

Responsibilities

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.
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.
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.
Maintain daily correspondence with maintenance staff to coordinate product allocations and schedule maintenance activities.
Ensure timely interventions to minimize downtime and improve operational efficiency.
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.