Staff Data Analytics Engineer

Accreditation Council for Graduate Medical Education; Denver (CO); On-site; USD 85,000 - 110,000; Full time

Job summary

Metro Water Recovery seeks a data analytics professional to support wastewater operations, regulatory reporting, and enterprise performance management. You will develop data-driven solutions, automate workflows, and build dashboards to improve decision-making across the organization, collaborating with multiple teams in a fast-paced environment.

The role emphasizes data engineering, reporting, and continuous improvement within the Environmental Services Department, with opportunities for growth

Qualifications

• Bachelor’s degree in data science, computer science, statistics, mathematics, engineering or related field.
• Experience conducting data analytics to support wastewater operations and enterprise performance management.
• Ability to build dashboards and automate data workflows across complex data sources.

Responsibilities

• Develop, optimize, and maintain ETL workflows for operations analytics and enterprise analytics.
• Provide analytics and reporting services for wastewater operations and performance management.
• Build and maintain dashboards and reporting tools with reliable adoption.
• Automate data collection, transformation, and reporting processes.

Skills

SQL

Data modeling

Cloud analytics

Machine learning fundamentals

AI applications

Data governance

Data visualization

APIs

ETL tools

Excel

Education

Bachelor’s degree in data science, computer science, statistics, mathematics, engineering

Tools

Power BI

Tableau

PIVision

Alteryx

Python

R

Job description

Metro Water Recovery in Denver, CO - a nationally recognized leader among clean water utilities, provides wastewater conveyance and treatment services for more than 2 million people in the Denver Metro area. At Metro, we help you be your best so we can do our best. You will join a team that offers stability, flexibility, and the opportunity to make a difference. We take pride in being part of an industry-leading team who serves the community by protecting the region’s health and environment.

Description

Why it’s a Great Opportunity:

We are seeking a data analytics professional to join our growing division within the Environmental Services department at Metro Water Recovery. In this role, you will have the opportunity to support environmental compliance, wastewater treatment operations, and regulatory reporting programs. This position provides the opportunity to have a real environmental impact within a complex technical environment, while supporting Metro’s mission to protect the region’s health and environment.

Why It's a Great Department:

This position is situated within the Quality Assurance and Sampling Division of the Environmental Services Department. Our department has a terrific culture that is built on continuous improvement, accountability, collaboration and fun. We believe in fostering a work environment that encourages teamwork, problem solving, creativity, and personal growth. Our team members have the opportunity to work on meaningful assignments and contribute to making a difference across Metro. The Environmental Services Department also includes the Pretreatment, Laboratory Services, Regulatory Compliance, and Water Quality Divisions, making it a dynamic and diverse work environment.

How to be Successful in the Role:

You will thrive in this role if you:

• Have an understanding of the various software used in data analytics and an interest in learning new tools
• Can take a structured and detailed-oriented approach to daily tasks, with an emphasis on thorough documentation
• Enjoy contributing to continuous/process improvement goals
• Work effectively across teams to meet the needs of various stakeholders
• Are comfortable working in a fast-paced, dynamic environment while proactively managing deadlines and competing priorities

We value excellence, integrity, inclusion and collaboration, and we're looking for someone who shares these values.

General Description:

Responsible for conducting data analytics activities that contribute to the development, optimization, and implementation of data-driven solutions for wastewater treatment and operations as well as enterprise performance and business intelligence solutions that support organizational-wide programs and services. The Staff Data Analytics Engineer is expected to perform intermediate-level data engineering, reporting, and automation tasks while contributing to applied research and technology evaluation efforts. This position reports to a Principal Data Analytics Engineer or assigned Senior Manager.

Examples of Duties

1. Develop, optimize, and maintain ETL (extract, transform, load) workflows for operations analytics, enterprise analytics, or other business intelligence functions.
2. Provide sustained analytics and reporting services supporting both wastewater operations and enterprise performance management needs including the automation of data collection, transformation, and reporting.
3. Assist in performing root cause analysis and identifying opportunities for improvement.
4. Build and maintain dashboards and reporting tools. Responsible for sustaining analytics products and dashboards beyond initial deployment, ensuring reliability, usability, and stakeholder adoption.
5. Implement intentional automation solutions to improve efficiency, reliability and decision making in alignment with Metro’s digital transformation goals.
6. Partner with internal and external stakeholders to translate strategic goals into reporting and analytics services. Contribute to enterprise KPI development and performance benchmarking.
7. Ensure analytics programs remain effective and sustainable through ongoing maintenance, stakeholder support, and continuous improvement.
8. Participate in testing and validation of analytics solutions.
9. Write technical documentation for system processes, data integration, and report development.
10. May assist with mentoring junior staff on analytics practices.
11. Contribute to process improvement initiatives by providing data-driven insights.
12. Troubleshoot and debug complex data processing issues, finding solutions with minimal support.
13. Other duties as assigned.

Qualifications

Knowledge/Skills/Abilities

Knowledge of:

• Strong understanding of SQL, data modeling, and cloud-based analytics platforms.
• Intermediate knowledge of machine learning fundamentals and AI applications.
• Cloud-based platforms, process data historians, and data warehouses.
• Data blending, integration, and visualization tools.
• Basic understanding of change management processes.
• Data governance concepts such as data ownership, lineage, or quality standards

Skilled at:

• Working with both operational/process datasets or business/adminstrrative datasets
• Proficiency in Power BI, Tableau, or PIVision, and overall dashboard development
• Experience working with APIs and integrating disparate data sources
• Proficiency in developing automation workflows using ETL tools (e.g., Alteryx, Python, R, etc.)
• Microsoft Excel proficiency, including complex formulas, data validation, and macros
• Writing and maintaining comprehensive technical documentation
• Performing initial data validation and troubleshooting issues

Ability to:

1. Identify trends and insights from large datasets to support decision-making
2. Communicate technical findings effectively to stakeholders and non-technical staff
3. Work effectively in cross-functional teams
4. Learn and implement new technologies independently
5. Implement data integrity techniques for identifying outliers and anomalies

Education, License, and Certification

Bachelor’s degree in data science, computer science, statistics, mathematics, engineering, or related field from an accredited college or university. A combination of education and relevant experience may be considered in lieu of a degree.

Working Conditions

Typical Work Environment

Working on a variety of floor surfaces including tile, carpet, sidewalks; Work in parking lots; Uneven Surfaces; Slippery surfaces; Wet surfaces; Lighting conditions including natural light, fluorescent, head lamps, incandescent, and overhead lighting; Inside environment; Outside environment; Vibration due to vehicle driving

Body Position Demands

Reaching in front; Standing; Walking; Balancing; Object handling; Typing; Simple hand grasping; Driving a vehicle; Sitting; Climbing stairs; Stooping; Kneeling; Crouching; Fine hand coordination; Firm hand grasping

Physical Demands (max forces are expected to be infrequent)

Max Weight Lifted: 40 lbs.
Max Weight Carried: 20lbs
Max Force Pushed: 3 lbs
Max Force Pulled: 3 lbs

Sensory Requirements

Wide field of view; Perception - Spatial; Olfactory (Smelling); Vision - Near; Far, Depth perception; Color discrimination; Perception - Form; Feeling without seeing; Speaking; Hearing

Metro Water Recovery is an Equal Opportunity Employer.

Applicants for employment with Metro Water Recovery must have valid work authorization that does not require sponsorship of a visa for employment authorization in the U.S.