Aecom
Trusted global infrastructure consulting firm delivering engineering, design, construction management services.
Data Engineering Specialist
Design, develop, and maintain data pipelines and reporting for construction projects.
Job Highlights
About the Role
• Ensure data is accessible, reliable, and efficiently processed. • Combine, optimize, and manage multiple big data sources. • Create automated reporting systems. • Provide software solutions that move data from its source to an internal database such as a data warehouse or data lake. • Implement data frameworks and/or architectures. • Design, develop, and maintain data pipelines to enable strong data analysis and reporting. • Utilize a myriad of solutions to ensure problem resolution with data warehousing and data sources. • Utilize algorithmic and statistical assessments, data processing tools, and AI to support data consumption. • Create resourceful dashboards using Power BI, Tableau, Looker, or similar tools.
Key Responsibilities
- ▸data integration
- ▸etl development
- ▸data architecture
- ▸pipeline development
- ▸automated reporting
- ▸dashboard creation
What You Bring
The role does not offer U.S. work‑authorization sponsorship, is on‑site (not hybrid or remote), and candidates must pass a pre‑employment substance‑abuse test. • BA/BS in Computer Science, Information Science, Data Engineering or related field and 4 years of relevant experience or demonstrated equivalency. • Proficiency in data programming languages. • Knowledge of data optimization tools, data structures, architecting, and data warehousing solutions. • Knowledge of API support for data access, gathering, distribution, transformation, and ELT. • Experience in data engineering, BI, or analytics development. • Strong proficiency in SQL and experience with relational and analytical databases. • Proficiency in Python or similar scripting language. • Familiarity with CMiC, Workday, Oracle, Bridgit Bench, SmartRecruiters, Blue Beam, Navisworks, or other construction‑related software. • Advanced Excel skills.
Requirements
- ▸sql
- ▸python
- ▸data engineering
- ▸advanced excel
- ▸cmic
- ▸workday
Benefits
AECOM provides comprehensive benefits that may include medical, dental, vision, life, disability, paid time off, flexible work options, well‑being resources, retirement plans, and employee stock purchase opportunities, tailored to employment status. Employees join a global team that supports growth and career ambitions, working on groundbreaking local and global projects with cutting‑edge technology and extensive training programs that develop technical and leadership skills. This on‑site position is located at 130 East Randolph, Chicago, IL, with a salary range from $85,674 to $158,498 annually.
Work Environment
Office Full-Time