Utilities Data Analyst

OVERVIEW: We are seeking a highly motivated Utilities 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, 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.

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

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

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.