Junior Project Controls Analyst: BI, Python & AI

Aecom Philippines, Inc.; Pateros; Hybrid; PHP 500,000 - 900,000; Full time

Job summary

Aecom Philippines, Inc. seeks a Data Analytics professional to develop and maintain Power BI dashboards, collect and transform data, and apply Python for automation. You will work with stakeholders and support project controls with cost and performance insights.

This role may require night shifts and three onsite days per week, with hybrid work arrangements in Metro Manila. Strong Excel and data modeling skills are essential, along with SharePoint experience.

Qualifications

• 2–4 years of experience in BI, data analytics, reporting, or related field.
• Strong Excel skills with advanced formulas, PivotTables, data analysis.
• Power BI expertise including query, DAX, data modeling, relationships, dashboards, and reports.

Responsibilities

• Develop and maintain Power BI dashboards and reports for performance tracking.
• Collect, clean, transform, and analyze data from multiple sources.
• Use Python for data processing, analysis, and automation where applicable.
• Perform data validation to 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.
• Identify opportunities to automate processes and enable data-driven solutions.
• Leverage AI tools like Microsoft Copilot for analysis and troubleshooting.
• Develop and maintain SharePoint-based data repositories and reporting solutions.
• Translate stakeholder requirements into actionable reports.

Skills

Power BI

Python

Excel

SharePoint

AI Copilot

Data analysis

Data validation

Stakeholder management

Tools

Power BI

Job description

Aecom Philippines, Inc. seeks a Data Analytics professional to develop and maintain Power BI dashboards, collect and transform data, and apply Python for automation. You will work with stakeholders and support project controls with cost and performance insights.

This role may require night shifts and three onsite days per week, with hybrid work arrangements in Metro Manila. Strong Excel and data modeling skills are essential, along with SharePoint experience.