Reporting Analyst

Requirements

• 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
• About AECOM
• 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.

Benefits

Additional Information

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.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at Aecom2? Share your experience