Data/GIS Analyst

McKim & Creed has a reputation for state-of-the-art engineering and data services that help utilities, municipalities, and energy providers convert facilities to cleaner, more efficient operations; harness the power of renewables; and optimize existing infrastructure and resources. Our respected team of engineers, planners, and data professionals are committed to innovation, sustainability, and resource efficiency-leading the way toward a cleaner, safer, and more sustainable future.

We are seeking a highly motivated 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.

What You Can Expect Day-to-Day:
Data Quality Assurance and Control
* Conduct daily QA/QC of incoming datasets 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 product allocation 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 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: Proficient in spatial analysis, mapping, and geoprocessing.
Survey123: Skilled in designing, deploying, and managing field data collection forms.
Operations Dashboard: Experience developing real-time dashboards to visualize performance and trends.
Web Experiences: Familiarity with creating GIS-based web apps for client-facing visualization.

* 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:
* Experience with data QA/QC workflows from field collection through delivery.
* Familiarity with API integrations for data automation and reporting.
* Background in utility mapping, infrastructure analytics, or water loss management.
* Experience with Power BI or similar data visualization platforms.
* 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, McKim & Creed offers:
* Employee Stock Ownership Plan (ESOP): All employees are owners and share in company success.
* Competitive pay and comprehensive leave, including paid holidays, parental, bereavement, medical, and military leave.
* Multiple office locations: Work close to home or travel for a change of scenery.
* Growth and training opportunities: Mentorship, continuing education, and technical development.
* Professional development: Tuition reimbursement, career advancement programs, and online courses.
* Meaningful work: Directly contribute to water conservation and infrastructure optimization.
* Collaborative culture: Supportive teams that encourage innovation, learning, and shared success.

Watch this video to learn more about what it's like to be part of our team.

McKim & Creed is an Equal Opportunity and Affirmative Action Employer and VEVRAA Federal Contractor. We consider all qualified applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability, and we maintain a Drug-Free Workplace.