GIS Data Analyst; Utilities

OVERVIEW

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 by collaborating with engineers and project managers to refine analytics, algorithms, and reporting tools that drive our mission of water conservation and smart resource management.

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

• 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.
• GIS Expertise
  • ArcGIS Pro:
    Comfortable with spatial analysis, mapping, and basic geoprocessing for QA/QC and reporting workflows.
  • Survey
    123 & Field Maps:
    Comfortable using deployed forms, validating field-collected data, and troubleshooting field-side issues.
  • Operations Dashboard & Experience Builder:
    Comfortable navigating and interpreting client-facing dashboards and apps.
• 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.

• 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, Data Gate, etc.) or SCADA systems.
• Early exposure to Survey
  123 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…