Aecom
Trusted global infrastructure consulting firm delivering engineering, design, construction management services.
13 days ago
$120,000 - $150,000
Expert & Leadership (13+ years), Experienced (8-12 years)
Full Time
Chicago, Illinois, United States
Office Full-Time
Company Size
51,000 Employees
Service Specialisms
Sector Specialisms
Description
sql pipelines
data integration
data modeling
power bi
kpi framework
ux design
We are seeking a Data Analytics & Visualization Lead to support the Chicago Department of Water Management’s Capital Improvement Program. The hands‑on technical role will lead the development of analytics solutions and dashboards that turn engineering, operations, and maintenance data into actionable insights for daily operations and long‑term planning. You will act as the technical team lead, guiding junior staff while collaborating closely with DWM stakeholders.
The role involves building and optimizing SQL Server pipelines, integrating EAM, GIS, and operational datasets into unified analytical models, and creating KPI frameworks for utility management. You will design semantic data models and develop Power BI dashboards that are intuitive, user‑friendly, and aligned with visualization best practices. Ongoing collaboration with cross‑functional teams and mentorship of junior analysts are essential to ensure data quality and alignment.
- Build and optimize SQL Server data pipelines, stored procedures, and ETL processes.
- Integrate EAM, GIS, operational, maintenance, and engineering data into centralized analytical models.
- Develop KPI frameworks for engineering and utility management.
- Design semantic data models and optimized datasets for dashboards.
- Lead creation and maintenance of Power BI dashboards for operations, engineering, maintenance, capital planning, and leadership.
- Ensure dashboards follow visualization and UX best practices.
- Collaborate with stakeholders to refine requirements, prototype, and deliver visual tools.
- Mentor junior data analysts/engineers and provide design reviews.
- Coordinate with cross‑functional teams (Engineering, GIS, EAM, Water Quality, Program Controls) for data alignment.
Requirements
bachelor’s
8+ years
power bi
sql
gis
data modeling
Candidates must hold a bachelor’s degree in data analytics, computer science, engineering, or a related field and have at least eight years of relevant experience. Preferred experience includes GIS data integration, utilities or public‑infrastructure backgrounds, and informal or formal leadership of a BI/analytics team. Strong proficiency with Power BI, SQL, data modeling, and excellent communication skills with non‑technical stakeholders are required, along with any relevant certifications.
- Minimum: Bachelor’s degree in relevant field and 8+ years experience.
- Preferred: GIS integration experience; utilities or public infrastructure background; experience leading/mentoring a BI team.
- Familiarity with UI/UX design best practices.
- Experience with predictive analytics, forecasting, or statistical modeling.
- Relevant certifications (Power BI, SQL Server, PMP, BI/Analytics).
- Strong proficiency in Power BI, SQL, and data modeling.
- Excellent communication skills with non‑technical stakeholders.
Benefits
AECOM offers a comprehensive benefits package that may include medical, dental, vision, life, disability, paid time off, flexible work options, wellness resources, retirement plans, and employee stock purchase opportunities. The company invests in award‑winning training and development programs to expand technical expertise and leadership capabilities. As a Fortune 500 firm with $16.1 billion revenue in FY 2024, AECOM provides a dynamic environment for career growth.
The position is on‑site in Chicago, IL, with a compensation range of $120,000–$150,000 per year. Sponsorship is not available, though relocation may be offered. AECOM is an Equal Opportunity Employer and treats all applicant information confidentially.
Training + Development
Interview process
Visa Sponsorship
- sponsorship is not available now or in the future.
Security clearance
Overview
Born 1990
Year of Formation
The company was formed in 1990 through the merger of five legacy firms.
$16B annual revenue
Annual Revenue
The company generates over $16 billion in revenue annually and ranks highly in ENR's global design firm lists.
150+ countries
Global Presence
The company operates in over 150 countries worldwide.
Megaprojects delivery
Project Scope
The company is known for delivering megaprojects such as cable-stayed bridges, Olympic venues, ports, transit hubs, and disaster recovery works.
- Launched as a bold independent infrastructure consultancy from a merger of five legacy firms dating back over a century.
- Handles everything from geotech to electro-mechanical systems, as seen in the award-winning Romaine Hydroelectric Complex in Canada.
- Guides projects through every lifecycle stage in transportation, buildings, water systems, energy, and environmental sectors.
Culture + Values
- Safety first - We put safety at the core of everything we do.
- Integrity - We act with the highest ethical standards.
- Collaboration - We believe in the power of teamwork.
- Innovation - We embrace creativity and foster new ideas.
- Sustainability - We are committed to creating a sustainable future.
Environment + Sustainability
2040
Net Zero Carbon Target
Committed to achieving net zero carbon emissions by 2040.
50%
Emission Reduction Target
Committed to reducing operational carbon emissions by 50% by 2030.
- Focus on decarbonization across client projects and operations.
- Developed strategies for climate resilience and adaptation.
- Initiated projects that contribute to sustainable infrastructure and urban planning.
Inclusion & Diversity
50% gender parity
Gender Parity Target
Aim to achieve gender balance in leadership positions by 2030.
35% increase
Women Leadership Growth
Achieved significant growth in women representation in leadership roles in 2022.
- Committed to increasing racial and ethnic diversity across the company.
- Implemented programs to foster a diverse and inclusive workplace culture.