Junior Project Analytics & BI Specialist

AECOM; Bonifacio; On-site; PHP 600,000 - 1,000,000; Full time

Benefits offered by this job

Medical

Dental

Vision

Life insurance

AD&D

Disability benefits

Paid time off

Leaves of absences

Voluntary benefits

Flexible work options

Well-being resources

Employee assistance program

Business travel insurance

Service recognition awards

Retirement savings plan

Employee stock purchase plan

Job summary

AECOM is seeking a data analytics professional to develop and maintain Power BI dashboards, analyze diverse data, and automate reporting using Python and AI tools. You will collaborate with stakeholders to translate requirements into insightful reports and maintain SharePoint data repositories.

The role emphasizes data accuracy, analytical thinking, and effective communication within cross‑functional teams on infrastructure projects.

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.

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.

Skills

BI Analytics

Excel Pro

Power BI proficiency

SharePoint knowledge

Python for data analysis

Copilot AI tools

Analytical thinking

Communication skills

Tools

Power BI

SharePoint

Python

Copilot AI

Job description

AECOM is seeking a data analytics professional to develop and maintain Power BI dashboards, analyze diverse data, and automate reporting using Python and AI tools. You will collaborate with stakeholders to translate requirements into insightful reports and maintain SharePoint data repositories.

The role emphasizes data accuracy, analytical thinking, and effective communication within cross‑functional teams on infrastructure projects.