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

Hiring Range

The pay range for this role is $81,166.51 - $113,611.89 annually. Starting 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 $479 monthly housing stipend

• Wellness program

• Retirement savings plans (414h and 457)

• 13.5 paid holidays

• Paid time off program

• Relocation assistance (if applicable)

• $650 annual recreation benefit

• Tuition reimbursement

• Loan programs (ski pass, computer, EVs)

All District employees must submit to a pre-employment drug screen and extensive background check. For a full position description, email erwsdjobs@erwsd.org.

This role will remain posted until 12/20/2024

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.

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you.