Reporting Analyst

**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** **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** **Qualifications** **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 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. **ReqID:** J10151256 **Business Line:** Geography OH **Business Group:** DCS **Strategic Business Unit:** GBS **Career Area:** Digital & Engineering Technology **Work Location Model:** Hybrid