INSenior Associate Workforce Analytics OC Central Advisory Gurgaon

Line of Service

Industry/Sector

Specialism

Management Level

Job Description & Summary

Why PWC

At PwC you will be part of a vibrant community of solvers that leads with trust and creates distinctive outcomes forour clients and communities. This purpose-led and values-driven work powered by technology in an environment that drives innovation will enable you to make a tangible impact in the real world. We reward your contributions support your wellbeing and offer inclusive benefits flexibility programmes and mentorship that will help you thrive in work and life. Together we grow learn care collaborate and create a future of infinite experiences foreach other. Learn more about us.

At PwC we believe in providing equal employment opportunities without any discrimination on the grounds of gender ethnic background age disability marital status sexual orientation pregnancy gender identity or expression religion or other beliefs perceived differences and status protected by law. We strive to create an environment where each one of our people can bring their true selves and contribute to their personal growth and the firms growth. To enable this we have zero tolerance for any discrimination and harassment based on the above considerations.

Job Description & Summary: A career within General Consulting services will provide you with the opportunity to help clients seize essential advantages by working alongside business leaders to solve their toughest problems and capture their greatest opportunities. We work with some of the worlds largest and most complex companies to understand their unique business issues and opportunities in an ever-changing environment. We help create sustainable change by stimulating innovation unlocking data possibilities navigating risk and regulatory complexity optimizing deals and aligning costs with business strategy to create a competitive advantage.

Responsibilities:

Senior Associate (Workforce Analytics) Purpose of the Role: Analytically strong and technically advanced Resource Manager with deep expertise in Advanced Excel (including VBA Macros and automation) and professional-grade PowerPoint storytelling. This individual will play a pivotal role in driving workforce analytics forecasting and utilization strategy by transforming data into business intelligence and executive-ready presentations. The ideal candidate will combine operational accuracy automation mindset and presentation excellence to enable leadership decisions and optimize workforce performance. Key Responsibilities Resource Management & Analytics Lead the design maintenance and automation of MIS reports and dashboards on a daily weekly and monthly cadence. Perform detailed analysis of resource allocation utilization availability and variance identifying actionable insights for leadership. Own end-to-end data integrity and validation across RM systems; ensure seamless integration with internal databases or platforms (e.g. Power BI RMG tool SAP). Partner with Business Unit Heads and Project Managers to anticipate workforce needs and design capacity optimization models. Introduce analytical frameworks that link RM metrics to business KPIs (revenue utilization productivity). Excel Mastery & Automation Develop advanced Excel models and tools for forecasting variance tracking and performance analysis. Create and maintain complex VBA macros to automate repetitive reporting and reconciliation tasks drastically reducing manual effort. Integrate Excel tools with other applications (Outlook PowerPoint Power BI databases) to enable real-time data refresh and reporting. Design simulation and scenario models for capacity planning and workforce forecasting. Conduct periodic audits and stress testing to ensure reliability scalability and accuracy of automated solutions. PowerPoint Storytelling & Executive Reporting

Build executive decks that transform data into strategic insights blending visuals storytelling and precision. Create impactful presentations that summarize RM trends forecasting insights and business recommendations. Develop presentation templates automation-enabled charts and dynamic slides directly linked to live Excel data. Maintain consistency with branding standards data accuracy and visual hierarchy to ensure professional impact. Coach junior team members on effective data storytelling and presentation hygiene. Data Visualization & Insight Generation Leverage data visualization tools (Power BI Tableau) to create interactive dashboards highlighting utilization bench trends and workforce metrics. Design intuitive visuals that support decision-making for Business Unit and HR leaders. Introduce automation pipelines and self-service dashboards to democratize access to workforce data. Continuously evolve analytics maturity within the RM function through innovation and adoption of best practices. Qualifications & Experience Experience: 47 years of proven expertise in Advanced Excel (VBA Macros Power Query Power Pivot) Workforce Analytics. Qualification - Masters degree in HR Operations Analytics or related discipline. Technical skills: o Strong proficiency in Advanced Excel & PowerPoint with ability to build leadership-grade decks. o Knowledge of visualization tools such as Power BI or Tableau preferred. Core Competencies: o Analytical Precision: Ability to structure interpret and present complex data with clarity and business context. o Automation Mindset: Passion for streamlining processes through VBA and workflow integration. o Storytelling Excellence: Capability to translate insights into crisp executive-level presentations. o Attention to Detail: Relentless focus on accuracy and timeliness. o Business Acumen: Understands workforce dynamics and their linkage to operational performance.

Mandatory skill sets:

Data Visualization & Insight Generation Advanced Excel (VBA Macros Power Query Power Pivot) Workforce Analytics.

Preferred skill sets:

Knowledge of visualization tools such as Power BI or Tableau preferred.

Years of experience required:

5 years

Education qualification:

Masters degree in HR Operations Analytics or related discipline.

Education (if blank degree and/or field of study not specified)

Certifications (if blank certifications not specified)

Required Skills

Optional Skills

Desired Languages (If blank desired languages not specified)

Travel Requirements

Available for Work Visa Sponsorship

Government Clearance Required

Job Posting End Date