AECOM is seeking a Data Analytics & Visualization Lead to support the Chicago Department of Water Management’s (DWM) Capital Improvement Program. This hands-on technical role will lead the development of analytics solutions and dashboards that transform engineering, operations, and maintenance data into actionable insights that directly improve DWM’s daily operations and long-term planning.In this position, you will serve as a technical team lead who develops BI/analytics solutions, ensures data quality, collaborates with DWM stakeholders, and guides junior staff without needing full managerial oversight responsibilities. This position plays a pivotal role in transforming a major public utility into a more data-driven organization.Key ResponsibilitiesBuild, 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.Build semantic data models and optimized data sets for end users and dashboards.Lead development, enhancement, and maintenance of Power BI dashboards supporting operations, engineering, maintenance, capital planning, and leadership decision-making.Ensure dashboards are intuitive, user-friendly, and designed according to strong visualization and UX best practices (formal HCI/UI training not required).Collaborate with stakeholders to refine requirements, prototype, iterate, and deliver value-driven visual tools.Work closely with DWM staff and internal teams to gather business requirements, develop prototypes, and iterate rapidly.Serve as a technical lead and mentor for junior data analysts or engineers; provide design review and technical oversight.Coordinate with cross-functional teams (Engineering, GIS, EAM, Water Quality, Program Controls) to ensure data alignment.