Role Description 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. Responsibilities - 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. Qualifications - 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. Requirements - 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, and basic geoprocessing for QA/QC and reporting workflows. - Survey123 & 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. Benefits - 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.

Role Description We are seeking a Senior GIS Data Analyst to join our Water Asset Management team and own the GIS application-development side of the practice. This role takes the lead on building the tools that make work scalable, including: - Designing Survey123 collection forms from scratch - Developing Operations Dashboards and Experience Builder apps for client-facing visualization - Writing custom integrations against the ArcGIS API for Python and JavaScript This is where engineering-grade GIS development meets utility data delivery, driving how M&C ships its analytics products, mentoring analysts, and contributing to modern AI integrations. Qualifications - 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 years in a hands-on GIS development role - Demonstrated portfolio of deployed Survey123 forms, Experience Builder apps, or ArcGIS API integrations - Strong analytical and problem-solving skills - Excellent written and verbal communication skills - 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 Requirements - Production-grade Python — modular, tested, automated workflows for data ingestion, transformation, and analysis (Pandas, SQLAlchemy, HTTP libraries, Matplotlib / Plotly) - Advanced SQL — schema design, query optimization, indexing strategy, and integration with operational data stores - 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 - ArcGIS API for Python & JavaScript: Build custom integrations, automation scripts, and web applications - Experience connecting LLMs, ML services, or other modern tooling into Esri workflows Benefits - 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 - Growth opportunities & training: Mentoring & training options available - Professional development: Tuition reimbursement, early career professional program, online courses & more - Work that makes a difference: See the direct impact on communities - Collaborative, supportive team: People to help you solve problems and encourage you

• Design, develop, and maintain scalable data pipelines and ETL (Extract, Transform, Load) processes. • Collect, clean, and transform raw data from multiple sources into usable formats for analytics and reporting. • Create and manage data integration workflows using tools such as Apache Spark, Python, SQL, or similar technologies. • Develop and optimize data models and database structures to ensure efficient data storage and retrieval. • Implement data validation and quality assurance procedures to ensure data accuracy and consistency. • Monitor and improve data performance, scalability, and reliability within cloud environments such as AWS, Azure, or GCP.

• Ingesting and unifying business data • Generating insights and supporting decision-making across the organization • Developing and maintaining dashboards and reporting solutions using enterprise platforms