AECOM · 9 hours ago
Data Analytics & Visualization Lead
Chicago, IL
Full-time
Onsite
Mid, Senior Level
$120K/yr - $135K/yr
4+ years expAECOM is a global infrastructure consulting firm dedicated to delivering a better world. They are seeking a Data Analytics & Visualization Lead to develop analytics solutions and dashboards that enhance operations and planning for the Chicago Department of Water Management.
Civil EngineeringConstructionConsultingEnergyGovernmentInformation Technology
No H1B
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
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
Qualification
Required
Bachelor's degree in data analytics, computer science, engineering, information systems, or related field and 4+ years of relevant experience or demonstrated equivalency of experience and/or education
Preferred
Experience integrating GIS data or understanding geospatial concepts
Experience in utilities, public infrastructure, engineering, construction, or operations
Experience informally or formally leading or mentoring a small BI/analytics team
Familiarity with UI/UX or dashboard design best practices (formal certification not required)
Experience with predictive analytics, forecasting, or statistical modeling
Relevant technical certifications (Power BI, SQL Server, PMP, BI/Analytics)
Strong hands-on proficiency with Power BI, SQL, and data modeling
Experience in integrating data from different operational data systems (i.e. asset management and maintenance systems)
Strong communication skills and ability to work directly with non-technical stakeholders
Benefits
Medical
Dental
Vision
Life
AD&D
Disability benefits
Paid time off
Leaves of absences
Voluntary benefits
Perks
Flexible work options
Well-being resources
Employee assistance program
Business travel insurance
Service recognition awards
Retirement savings plan
Employee stock purchase plan
Company
AECOM
AECOM is a global provider of professional technical and management support services to a broad range of markets.
10001+ employees
Funding
Current Stage
Public CompanyTotal Funding
$1.2BKey Investors
Australian Renewable Energy Agency
2025-07-15Post Ipo Debt· $1.2B
2012-12-31Grant· $0.01M
2007-05-11IPO
Leadership Team
W. Troy Rudd
CEO
Sandra Broughton
Corporate Vice President - Global Head of Travel
Recent News
2026-01-16
Company data provided by crunchbase