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—collaborating with engineers and project managers to refine analytics, algorithms, and reporting tools that drive our mission of water conservation and smart resource management.
DURING YOUR WORK DAY, YOU WILL:
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.
WHAT YOU’LL NEED:
Technical Skills
• Python Programming: Proficiency in Python for data manipulation, analysis, and workflow automation (Pandas, NumPy, 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, a