Reporting Analyst

Responsibilities & Duties

Role Overview

• You will own the full analytics lifecycle: Requirement gathering data acquisition modelling visualization automation governance data accuracy and enablement.

• You will translate HR business questions into metrics models and intuitive reports that inform decisions on headcount attrition recruiting payroll performance and workforce planning.

• You will partner with HR IT and business leaders to prioritize a scalable roadmap of analytics products and automations.

1.      Data Engineering & Modelling

• Build robust ETL pipelines using Power Query (M) and SQL to integrate HRIS ATS (SmartRecruiters or similar Applicant Tracking System) payroll and survey data.

• Implement data quality checks lineage and refresh orchestration.

2.      Analytics & Visualization

• Develop executive and operational dashboards in Power BI with DAX measures drill-throughs and row-level security.

• Create standardized metric definitions (e.g. headcount joiners/leavers retention DE&I time-to-fill offer acceptance).

• Optimize datasets and reports for performance usability and accessibility.

3.      Automation & Process Improvement

• Build Power Automate flows to streamline HR processes (e.g. report distribution alerts approvals data syncs).

• Automate recurring reporting to reduce manual effort and cycle time.

• Integrate with SharePoint for curated data access content lifecycle and self-service.

4.      Governance & Compliance

• Enforce data privacy security and RLS consistent with HR data protection standards.

• Maintain documentation data dictionaries and user guides; establish versioning and release controls.

• Support auditability with metric lineage assumptions and archival practices.

5.      Stakeholder Engagement & Enablement.

• Gather requirements prototype quickly and iterate based on feedback.

• Conduct training and office hours to build HR self-service capability.

• Communicate insights clearly to HR leaders and cross-functional partners.

• Core Tech Stack

• Power BI (DAX data modeling RLS deployment pipelines)

• Power Query (M) for data shaping and ETL

• Power App (Power Automate (scheduled flows approvals notifications integrations)

• SharePoint (content management permissions web parts for analytics access)

• SQL (views stored procedures performance tuning)

• undefined

Qualifications & Requirements

Minimum Requirements:

• 3 to 5 years in HR analytics or people data roles with end-to-end BI delivery.

• Advanced Power BI (DAX measures relationships aggregations performance optimization).

• Strong SQL for data preparation joins and transformation at scale.

• Proficiency in Power Query (M) for complex shaping and incremental refresh patterns.

• Experience building production-grade automations in Power Automate.

• Hands-on with SharePoint for governed report distribution and collaboration.

• HR domain expertise across headcount attrition recruiting funnel pre-hire support performance Payroll & Time.

• Strong data storytelling stakeholder management and documentation skills.

• Commitment to HR data privacy security and ethical use.

Preferred Qualifications

       HRIS data experience (e.g. Workday SAP SuccessFactors Oracle HCM) and ATS platforms.

       Exposure to Azure data services (e.g. Synapse Data Factory SQL Database Dataverse) or APIs/Graph connectors.

       Scripting for analysis/automation (Python or R) and advanced statistical methods (trend cohort survival analysis).

       Experience with semantic modeling enterprise deployment pipelines and CI/CD for Power BI.

       Familiarity with Microsoft Power Platform governance and Center of Excellence best practices.

Attributes:

• Location: Bangalore/Manila

Additional Information :

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 and service recognition awards.

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 . 

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 youll 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 youve always envisioned. Here youll find a welcoming workplace built on respect collaboration and communitywhere 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. 

Remote Work :

No

Employment Type :

Full-time