IN_Senior Associate_ Workforce Analytics _OC Central _Advisory_ Gurgaon

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Operations

Management Level

Senior Associate

Job Description & Summary

At PwC, our people in sustainability focus on integrating environmental, social, economic, and governance considerations into business strategies and operations. They provide guidance and support to organisations by managing sustainability risks, identifying opportunities, and driving positive social and environmental impact.

In climate and energy at PwC, you will focus on providing consulting services related to climate change mitigation and adaptation, as well as energy efficiency and renewable energy solutions. You will analyse client needs, develop strategies to reduce greenhouse gas emissions, and offer guidance and support to help clients transition to a low-carbon economy.

Why PWC

At PwC, you will be part of a vibrant community of solvers that leads with trust and creates distinctive outcomes for our 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 for each 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 firm’s 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 world’s 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: 4–7 years of proven expertise in Advanced Excel (VBA, Macros, Power Query, Power Pivot) Workforce Analytics. · Qualification - Master’s 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:

Master’s degree in HR, Operations, Analytics, or related discipline.

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

Degrees/Field of Study required: MBA (Master of Business Administration)

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

Workforce Analytics

Optional Skills

Accepting Feedback, Accepting Feedback, Active Listening, Analytical Thinking, Carbon Accounting, Carbon Footprint, Carbon Offsets, Carbon Pricing and Trading, Carbon Taxes and Incentives, Climate Change Adaptation Program Design, Climate Change Impacts and Risks, Climate Change Scenarios, Climate Finance, Climate Policy, Climate Reporting, Communication, Creativity, Embracing Change, Emission Trading, Emotional Regulation, Empathy, Energy Efficiency, Energy Policy and Regulation, Energy Transition, Energy Transition Financing and Investment {+ 10 more}

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Available for Work Visa Sponsorship?

Government Clearance Required?

Job Posting End Date