15 Nov
|
EXL Service
|
India
Job Description: Support business and operational teams by forecasting demand, workload, or volume patterns using historical trends, seasonality, pipeline inputs, and business drivers to enable forward-looking planning. - Develop and maintain capacity and staffing analytics, translating forecasted demand into required resource levels based on productivity, utilization assumptions, skill mix, and service-level expectations. - Perform scenario and what‑if analyses (e.g., growth scenarios, attrition impact, hiring delays, demand spikes) to help leadership understand trade-offs and risks associated with staffing decisions. - Analyze workforce-related data such as capacity, utilization, availability, and performance using SQL and analytical platforms (e.g., Vertica) to identify gaps, excesses, and optimization opportunities. - Execute data preparation, transformation, and integration activities using SQL and Alteryx, ensuring clean, consistent, and reliable inputs for forecasting and staffing models. - Design and maintain Tableau dashboards and analytical reports that provide clear visibility into demand vs. capacity, staffing gaps, utilization trends, and forecast Docusign Envelope ID: EDB61647-A540-48D8-8733-8A8C8C371BFA accuracy for operational and leadership stakeholders. - Continuously refine forecasting methodologies, assumptions, and models based on actuals, variance analysis, and feedback to improve accuracy and reliability over time. - Identify and flag workforce-related risks such as skill shortages, attrition trends, capacity constraints, or forecast volatility, and support mitigation planning through data-backed insights. - Ensure data quality, governance, and transparency by maintaining documented assumptions, calculation logic, model versions, and explicit traceability from source data to reported outcomes. - Enable reuse and adoption of analytics by documenting dashboards, data definitions, and forecasting approaches, supporting consistent interpretation across stakeholders. Responsibilities:
Support business and operational teams by forecasting demand, workload, or volume patterns using historical trends, seasonality, pipeline inputs, and business drivers to enable forward-looking planning. - Develop and maintain capacity and staffing analytics, translating forecasted demand into required resource levels based on productivity, utilization assumptions, skill mix, and service-level expectations. - Perform scenario and what‑if analyses (e.g., growth scenarios, attrition impact, hiring delays, demand spikes) to help leadership understand trade-offs and risks associated with staffing decisions. - Analyze workforce-related data such as capacity, utilization, availability, and performance using SQL and analytical platforms (e.g., Vertica) to identify gaps, excesses, and optimization opportunities. - Execute data preparation, transformation, and integration activities using SQL and Alteryx, ensuring clean, consistent, and reliable inputs for forecasting and staffing models. - Design and maintain Tableau dashboards and analytical reports that provide clear visibility into demand vs. capacity, staffing gaps, utilization trends, and forecast Docusign Envelope ID: EDB61647-A540-48D8-8733-8A8C8C371BFA accuracy for operational and leadership stakeholders. - Continuously refine forecasting methodologies, assumptions, and models based on actuals, variance analysis, and feedback to improve accuracy and reliability over time. - Identify and flag workforce-related risks such as skill shortages, attrition trends, capacity constraints, or forecast volatility, and support mitigation planning through data-backed insights. - Ensure data quality, governance, and transparency by maintaining documented assumptions, calculation logic, model versions, and clear traceability from source data to reported outcomes. - Enable reuse and adoption of analytics by documenting dashboards, data definitions, and forecasting approaches, supporting consistent interpretation across stakeholders. Qualifications: Data science & Staffing models experience
📌 Forecasting & Staffing Analyst (India)
🏢 EXL Service
📍 India