Data Analytics & Visualization Lead

Core responsibilities:

• Build, maintain, and optimize data pipelines using SQL Server, stored procedures, and ETL frameworks
• Integrate EAM, GIS, operational, maintenance, and engineering datasets into centralized analytical models
• Develop operational and strategic KPI frameworks for engineering and utility management
• Lead development, enhancement, and maintenance of Power BI dashboards supporting operations, engineering, maintenance, capital planning, and leadership decision-making

This role transforms a major public utility into a more data-driven organization by developing analytics solutions and dashboards that turn engineering, operations, and maintenance data into actionable insights that directly improve daily operations and long-term planning.

Required skills and qualifications:

• Experience with SQL Server, stored procedures, and ETL frameworks
• Proficiency in Power BI dashboard development and maintenance
• Ability to build semantic data models and optimized data sets
• Experience mentoring junior data analysts or engineers and providing technical oversight

No compensation, perks, or culture highlights mentioned in the description.

AECOM is supporting the Chicago Department of Water Management's Capital Improvement Program through data analytics and visualization solutions.