Junior Project Controller - Reporting & Performance Analytics

Work with Us. Change the World. At AECOM, we're delivering a better world. Whether improving your commute, keeping the lights on, providing access to clean water, or transforming skylines, our work helps people and communities thrive. We are the world's trusted infrastructure consulting firm, partnering with clients to solve the world’s most complex challenges and build legacies for future generations. There has never been a better time to be at AECOM. With accelerating infrastructure investment worldwide, our services are in great demand. We invite you to bring your bold ideas and big dreams and become part of a global team of over 50,000 planners, designers, engineers, scientists, digital innovators, program and construction managers and other professionals delivering projects that create a positive and tangible impact around the world. We're one global team driven by our common purpose to deliver a better world. Join us. Key Responsibilities Develop and maintain Power BI dashboards and reports for business and project performance tracking Collect, clean, transform, and analyze data from multiple sources Use Python for data processing, analysis, and automation where applicable Perform data validation and ensure accuracy and consistency of reports Analyze cost, budget, manpower, labor hours, and performance data Support project and financial reporting, including actual vs. budget analysis and variance tracking Identify opportunities to improve manual processes through automation and data-driven solutions Use AI tools such as Microsoft Copilot to support data analysis, troubleshooting, research, and solution development Develop and maintain SharePoint-based data repositories and reporting solutions Work with stakeholders to understand requirements and translate them into effective reports and analytical solutions Provide analytical support for ad-hoc requests and business/project reviews Communicate findings and recommendations clearly to technical and non-technical stakeholders Required Skills & Qualifications 2–4 years of experience in Business Intelligence, Data Analytics, Reporting, Automation, or a related field Strong proficiency in Microsoft Excel , including advanced formulas, PivotTables, and data analysis Strong working knowledge of Power BI , including: Power Query DAX Data modeling Relationships Dashboard and report development Experience with SharePoint , particularly lists and data management Working knowledge of Python for data analysis, manipulation, or automation Experience using AI tools such as Microsoft Copilot for productivity, troubleshooting, analysis, or solution development Strong analytical and problem-solving skills Strong attention to detail and commitment to data accuracy Good communication and stakeholder management skills Preferred Qualifications Experience with Power Apps and Power Automate Exposure to project controls, cost reporting, or financial analysis Familiarity with WBS, budget monitoring, variance analysis, and earned value concepts Experience working with large datasets or multiple data sources Interest in emerging technologies, AI, and automation At AECOM, we are committed to maintaining a secure and trustworthy recruitment process and take any fraudulent hiring activity seriously. To support this commitment, all newly hired employees are required to attend an in-person Day 1 onboarding at an AECOM office location as a condition of employment.   About AECOM   AECOM is proud to offer comprehensive benefits to meet the diverse needs of our employees. Depending on your employment status, AECOM benefits may include 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, and employee stock purchase plan.  AECOM is the global infrastructure leader, committed to delivering a better world. As a trusted professional services firm powered by deep technical abilities, we solve our clients’ complex challenges in water, environment, energy, transportation and buildings. Our teams partner with public- and private-sector clients to create innovative, sustainable and resilient solutions throughout the project lifecycle – from advisory, planning, design and engineering to program and construction management. AECOM is a Fortune 500 firm that had revenue of $16.1 billion in fiscal year 2025. Learn more at aecom.com.  What makes AECOM a great place to work   You will be part of a global team that champions your growth and career ambitions. Work on groundbreaking projects - both in your local community and on a global scale - that are transforming our industry and shaping the future. With cutting-edge technology and a network of experts, you’ll have the resources to make a real impact. Our award-winning training and development programs are designed to expand your technical expertise and leadership skills, helping you build the career you’ve always envisioned. Here, you’ll find a welcoming workplace built on respect, collaboration and community - where you have the freedom to grow in a world of opportunity.  As an Equal Opportunity Employer, we believe in your potential and are here to help you achieve it. All your information will be kept confidential according to EEO guidelines.