Water Conservation Data Analyst

The Water Conservation Data Analyst plays a crucial role in our mission to protect and sustain our water resources. As a key team member in the Water Conservation Department, you will use data analysis to support water conservation goals, create water-saving strategies, and help shape a sustainable future for our community. You will support programs to manage water use across our customer types and influence conservation through data-driven insights.

We’re seeking an individual passionate about using data in an environmental sustainability and water conservation setting. If you thrive on data analysis, enjoy collaborating with diverse teams, and are excited about creating positive change, this role could be a perfect fit.

Why work for us? The work you will do as a Water Conservation Data Analyst will allow you to make a real difference in creating a sustainable future for the community where we live, work and play. In addition, we offer excellent health benefits, a housing program, and opportunities for training and development.

The Schedule

This position is expected to work a hybrid schedule, working on-site 2-3 days per week at our office in Vail, Colorado.

Day to Day Responsibilities:

• Data Analysis & Evaluation: Use data to support business decisions about water conservation and other internal initiatives and track impacts resulting from our work. Assist in building data warehouses and reporting structures related to water usage and account metrics. Lead sophisticated statistical analyses of water use to refine conservation needs and understand how factors such as outreach, weather, and rates affect customer’s water use.
• Data Management & Visualization: Develop and manage interactive dashboards, charts, and reports in Power BI and Shiny to communicate key findings internally and for the public.
• Stakeholder Collaboration: Partner with other departments to design customer communications and integrate Advanced Metering Infrastructure (AMI).
• Research & Reporting: Apply best practices in water conservation and data-driven rate structures, with strong documentation skills for maintaining reports, records, and files.

Qualifications and Competencies:

• Education & Experience:
  • Bachelor's degree from an accredited college or university with significant course work in environmental science, conservation, biological science, data analysis, or related fields, AND
  • Minimum two years of professional experience in a data analysis-heavy field, OR
• Any combination of experience and training that would provide the required knowledge and abilities.
• Problem Solving: Use critical thinking to address data discrepancies, quality-check datasets, and support solution development through comprehensive analysis.
• Teamwork: Ability to work across all departments and manage workloads.

Required Technical Skills:

• Data Modeling: Advanced skills in querying, data extraction, transformation, aggregation, and optimization; experience with complex joins, stored procedures, views, and data validation.
• Programming and Analysis: Experience with R and R Studio/VS Code for data manipulation, statistical analysis, and modeling
• Statistical Software and Libraries: Proficiency in statistical software and libraries (e.g., pandas in Python, dplyr in R) for advanced data manipulation and analysis.
• APIs and Data Integration: Ability to use APIs to integrate data from external sources.
• Git: Ability to incorporate Git version control into workflows for reproducible code, CI/CD DevOps, and collaboration amongst data colleagues.
• Excel: Strong foundational Excel skills for supplemental analysis (Pivot Tables, Conditional Formatting, Index Match, Data Validation).

Nice to Have Skills:

• SQL Server (Data Warehousing, ETL)
• Power Platform
• Virtual Machine (VM) Environment
• Python
• Docker
• Data Security and Compliance: Understanding of data governance, privacy, and security best practices, including compliance with CISA (Cybersecurity and Infrastructure Security Agency) standards.
• Experience with CIS Infinity or another utility-based customer information system.

The Schedule

This position is full-time, typically working Monday through Friday, with some flexibility for special events, photo/video shoots, or campaign launches. Hybrid work is available but must be able to work on site 2-3 days a week

Pay Range

The pay range for this role is $84,406.40 - $118,144.00. Hiring salary depends on qualifications but generally falls within the minimum and midpoint of the pay range.

Benefits

At ERWSD, we value life-work balance and are leaders in the industry with our holistic benefits package, which includes but is not limited to:  

• Comprehensive medical, dental, and vision coverage 
• Employee housing or $522 monthly housing stipend 
• 13.5 paid holidays + generous PTO 
• Paid parental leave 
• Wellness program & recreation benefit ($700/year) 
• 457 & 414h retirement plans (we are social security exempt) 
• Tuition reimbursement & professional development budget 
• Ski pass, EV, and tech loan programs 
• Relocation assistance (if applicable) 

Click here to view our full 2025 Benefits Guide. 

All District employees must possess a valid Colorado Driver License and submit to a pre-employment drug screen, extensive background check including an educational verification, and reference check. For a full position description including work environment and physical demands, email erwsdjobs@erwsd.org. All applicants must apply online at www.erwsd.org by November 14.

We are an Equal Opportunity Employer  

We do not discriminate based on race, color, religion, national origin, sex, age, disability, sexual orientation, marital status, genetic information or any other status protected by law or regulation. It is our intention that all qualified applicants be given equal opportunity and that selection decisions are based on job-related factors.