Utility Data and Modeling Analyst

HDR; Madison (WI); On-site; USD 73,206 - 104,580; Full time

Benefits offered by this job

Comprehensive benefits package

Paid time away

Retirement savings plan with employer match

Job summary

A leading engineering firm is seeking an entry-level Utility Data Analyst to support water and wastewater utility projects through hydraulic modeling, data analytics, and GIS. The successful candidate will handle data acquisition, conduct exploratory analysis, and contribute to technical reports. This full-time position requires proficiency in data engineering tools and strong communication skills, offering a range of employee benefits and a starting salary between $73,206 and $104,580 based on location and expertise.

Qualifications

• Self-motivated and detail-oriented.
• Ability to multitask and prioritize.
• Experience with data science tools.

Responsibilities

• Assist with hydraulic model data management.
• Perform data cleaning and exploratory analysis.
• Support technical report development.

Skills

Data analytics

GIS

Hydraulic modeling

SQL

Python

R

Power BI

Communication skills

Organizational skills

Education

Bachelor’s Degree

Tools

ArcGIS Pro

Power BI

SQL

Python

Job description

About The Role

HDR is seeking an entry‑level Utility Data, Asset Management & Hydraulic Modeling Analyst to support water and wastewater utility projects through applied hydraulic modeling analysis, data analytics, GIS, and asset management. This position contributes to system evaluations, capital planning, regulatory analysis, and development of technical deliverables for municipal utility clients. The successful candidate will demonstrate strong analytical capability, technical rigor, and an interest in advancing data‑driven utility planning.

Key Responsibilities

Hydraulic Modeling & System Analysis

• Assist with building and maintaining hydraulic model data for water distribution and wastewater collection systems using GIS datasets, as‑built drawings, and field data.
• Support hydraulic simulations, system performance evaluations, and scenario analyses for planning studies and operational assessments.
• Utilize data from industry modeling tools such as InfoWater, InfoSewer, InfoSWMM, InfoWorks ICM, SewerGEMs, WaterGEMs, EPANet, and ArcGIS Pro.

Data Engineering, Analytics & Visualization

• Perform data acquisition, cleaning, validation, and exploratory analysis on large datasets including SCADA data, metering data, GIS layers, and monitoring records.
• Develop analytical and visualization outputs using SQL, Power BI, Python, R, and GIS platforms to support technical evaluations.
• Support database management, data structuring, and creation of modeling‑ready datasets to improve study reliability and documentation.
• Handle highly sensitive and confidential information with professionalism and discretion.
• Collaborate with stakeholders to improve business decisions by identifying patterns and trends in data.
• Develop data products including reports, visualizations, and dashboards.
• Adhere to software and data science development standards.
• Perform data acquisition, sourcing, cleaning, and exploratory data analysis (EDA).
• Transform raw data into usable attributes for machine learning modules through feature engineering.
• Manage model lifecycle including development, deployment, data drift detection, model retraining, and model inference.
• Create automated data pipelines and data engineering solutions.
• Develop advanced and custom predictive models (classification, regression, time series, neural networks, natural language processing, and computer vision).
• Tune models with training, hyperparameters, comprehensive validation, and testing processes.

Asset Management & Capital Planning

• Contribute to asset inventory development, condition assessment processes, and risk prioritization activities supporting water and wastewater capital planning.
• Assist in preparing asset management and capital improvement plan documents, including risk modeling graphics, lifecycle analysis summaries, and decision‑support exhibits.
• Integrate asset, condition, and geospatial data to support long‑term strategic planning for utility infrastructure.

Utility Planning, Policy Analysis & Technical Reporting

• Support development of technical reports, planning documents, regulatory analyses, and client presentations.
• Assist with evaluating impacts of evolving state and federal environmental policies on client utility systems.
• Leverage predictive models to optimize business results.
• Contribute to studies involving financial planning, rate evaluation, and long‑range system needs assessment.

Professional Collaboration

• Actively participate in HDR’s employee‑owned, collaborative culture by working closely with multidisciplinary teams including engineers, planners, analysts, and project managers.
• Communicate findings through written reports, visualizations, engineering graphics, and presentations.
• Maintain high standards of quality control, documentation, and analytical accuracy.

Preferred Qualifications

• Bachelor’s Degree
• A minimum of 3 years experience in a data science role
• Foundational knowledge or academic experience in hydraulics, environmental systems, data analytics, GIS, or related disciplines.
• Familiarity with or academic exposure to hydraulic modeling concepts or tools.
• Experience with ArcGIS Desktop, ArcGIS Pro, or ArcGIS Online.
• Oracle Spatial or SQL Server Spatial back‑end data processing experience.
• Understanding of asset management principles such as condition assessment, risk scoring, or lifecycle planning.
• Interest in environmental regulations and policy frameworks related to water and wastewater utilities.

Required Qualifications

• A degree in a closely related field or combination of education and relevant experience.
• Self‑motivated, detail‑oriented professional, ability to multitask.
• Proficiency with MS Office (Word and Outlook).
• Proficiency with data engineering tools and languages such as SQL, Power Query, and Pandas.
• Proficiency with business intelligence tools such as Power BI, Tableau, Plotly, Seaborn, and Matplotlib.
• Proficiency with data science languages such as Python and R.
• Ability to handle confidential information.
• Excellent writing and people skills.
• Strong math and organizational skills.
• Flexibility and ability to prioritize and handle multiple tasks and various managers in a fast‑paced environment.
• Excellent verbal and written communication skills including grammar, punctuation, proofreading, spelling, and telephone skills.
• An attitude and commitment to being an active participant of our employee‑owned culture.

Benefits

We provide a comprehensive benefits package that promotes employee ownership, employee health, performance, and success, which includes medical, dental, vision, short and long‑term disability, life insurance, an employee assistance program, paid time away, parental leave, paid holidays, a retirement savings plan with employer match, employee referral bonus and tuition reimbursement. The expected compensation range for this position depends upon skills, experience, education and geographical location. (Stated benefits are for full‑time regular positions. Temporary and part‑time roles eligible for limited benefits.) Minnesota: $73,206 - $104,580.

Location

Primary Location: United States-Minnesota-Saint Louis Park
Other Locations: United States-Wisconsin-Madison, United States-Wisconsin-Milwaukee

Industry

Water

Schedule

Full‑time

Employee Status

Regular

Business Class

Utility Management Services

Job Posting

Mar 30, 2026

Equal Employment Opportunity Statement

At HDR, we are committed to the principles of employment equity. We are an affirmative action and equal opportunity employer. We consider all qualified applicants, regardless of criminal histories, arrest and conviction records.