IN_Senior Assosiate_Resource management_OC RMG_Advisory_Mumbai

Line of Service Advisory Industry/Sector Not Applicable Specialism Operations Management Level Senior Associate Job Description & Summary At PwC, our people in talent and development focus on finding, deploying, training and enabling talent through talent identification and enhancing employee skills and knowledge, fostering a culture of continuous learning and professional growth.

These individuals collaborate with subject matter specialists and project teams to strategize effective ways to locate, assess, educate and train employees, in line with market developments and firm strategy. In staffing and deployment at PwC, your work will focus on managing and optimising the deployment of employees within the organisation, getting the right talent to the right place at the right time.

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 :Manages day-to-day resourcing operations, ensuring optimal utilization of resources. Collaborates with delivery and HR teams to meet business requirements through proactive resource planning and reporting. Responsibilities: · Senior Associate (Workforce Analytics) 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.

Mandatory Skill Sets : 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.

Technical skills: Strong proficiency in Advanced Excel & PowerPoint with ability to build leadership-grade decks. Knowledge of visualization tools such as Power BI or Tableau preferred. Preferred Skill sets Core Competencies: Analytical Precision: Ability to structure, interpret, and present complex data with clarity and business context.

Automation Mindset: Passion for streamlining processes through VBA and workflow integration. Storytelling Excellence: Capability to translate insights into crisp, executive-level presentations. Attention to Detail: Relentless focus on accuracy and timeliness.

Business Acumen: Understands workforce dynamics and their linkage to operational performance. Years of experience required: Experience : 4-7 years Education qualification