Role Overview
We are looking for a Workforce Analytics Analyst to support Resource Management, Workforce Planning, MIS, and business analytics initiatives. The role will manage and analyze workforce data, develop automated reporting solutions, and create Power BI dashboards to support business and leadership decision-making.
The ideal candidate will have strong hands-on expertise in advanced Excel, Excel automation, and Power BI, along with a valuable understanding of workforce/resource management metrics such as utilization, demand, capacity, deployment, bench, hiring fulfillment, and headcount.
The role will work closely with Finance, HR, Talent Acquisition, Delivery, and Business teams to analyze data, identify trends and revenue-impacting gaps, and provide actionable insights.
Key Responsibilities
1. Workforce Analytics & Resource Management
- Maintain and analyze workforce data covering demand, supply, utilization, deployment, capacity, bench, headcount, and hiring fulfillment.
- Support resource allocation and workforce planning activities.
- Monitor open demand, aging positions,



bench levels, utilization, and fulfillment status.
- Identify trends, gaps, and opportunities for improving resource utilization and deployment.
- Prepare weekly, monthly, and ad-hoc workforce reports for business and leadership reviews.
- Support capacity planning and workforce forecasting through data-driven analysis.

2. Excel Automation & MIS
- Develop, maintain, and automate complex Excel-based trackers, reports, dashboards, and analytical models.
- Automate repetitive reporting activities using VBA/Macros.
- Build scalable Excel solutions using Pivot Tables, Power Query, Power Pivot, VBA/Macros, XLOOKUP / INDEX-MATCH, SUMIFS / COUNTIFS, Dynamic Arrays, and LET / LAMBDA.
- Develop automated templates for resource allocation, demand tracking, bench management, utilization tracking, capacity planning, and hiring fulfillment.
- Review existing reports and identify opportunities to impro

📌 Workforce Analytics Analyst (Pune)
🏢 NewVison
📍 Pune