Junior Project Controller - Reporting & Performance Analytics

Location: City of Taguig, BONIFACIO STOPOVER, ph Employment Type: {'id': 'permanent', 'label': 'Full-time'}

Company Description

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.

Job Description

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

Qualifications

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

Additional Information

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.