Specialist, Workforce Analyst

Job Description

The Specialist, Workforce Analyst plays an integral role in the workforce planning process leveraging his expertise in multiple tools and languages such as Python, Power BI, SQL, and Power Query. This role is pivotal in advancing our data-driven HR strategies, with a strong focus on modeling and analyzing data related to attrition, recruitment, hiring, internal movement, and equity, diversity & inclusion (ED&I). The Specialist is accountable for preparing corporate attrition forecasts, identifying key and vulnerable positions, comparing current skills with future demands, and analyzing workforce trends and changes in workforce demographics. The Specialist is accountable for supporting Negotiations, corporate projects, and corporate strategy renewal initiatives by providing attrition and other employee information used to assess risks and opportunities related to headcount reductions. The Specialist is also responsible accountable for automating workforce data collection, using statistical models—including forecasting and regression techniques—and designing and maintaining complex data capture and reporting systems. 

Job Responsibilities

Below are the main job requirements and responsibilities for the Specialist, Workforce Analyst.

• Plans and prepares corporate, regional and business area attrition forecasts for various employee groups using statistical forecasting model; analyzes actual attrition as compared to forecasted attrition; identifies variances and makes appropriate adjustments to attrition forecasts.

• Supports Negotiations, corporate projects and corporate strategy renewal initiatives in assessing risks and opportunities related to headcount reductions by providing attrition forecasts and related employee information as required.

• Develops automated Excel spreadsheets to capture complex workforce data; designs and maintains advanced reporting systems using SAP and other computer systems or applications; modifies programming of forecasting model to enhance data capture capability; instructs Human Performance Management end users on SAP Pension Eligibility Report’s functionality and use in attrition forecasting.

• Co-ordinates the collection of internal data from business areas related to key & vulnerable positions and existing or potential skill gaps; evaluates information according to established criteria to determine relative degree of vulnerability; ensures that key and vulnerable positions are identified in SAP; communicates results to deployed HR and business areas in report or presentation format.

Job Responsibilities (continued)

• Researches and writes reports on internal and external workforce trends and labour market issues including skill shortages, changes in workforce size and composition, employment rates, demographic characteristics, retirement trends and macroeconomic factors, consulting with economists and labour market experts; uses statistical models in creating demographic profiles.

• Liaises with regional Human Performance Management regarding workforce adjustment costs, specifically, voluntary and involuntary termination payments issued to unionized and non-unionized employees; instructs end users of Workforce Management System on system functionality; and resolves technical problems to ensure termination payments are processed on a timely basis.

• Liaises with regional Human Performance Management to verify other workforce adjustment costs such as career/financial counselling services provided to unionized and non-unionized employees; processes invoices in SAP and monitors usage and spending levels in accordance with Purchase Order.

• Provides functional direction to regional Human Performance Management on Work Options Program; interprets program offerings and provides procedural advice on program administration.

Qualifications

Education

• Completed post-secondary, preferably in Economics, Data Science, Computer Science OR a combination of equivalent professional experience and training

Experience

• 1 to 3 years of relevant functional experience
• One or more years of experience in a unionized environment an asset

Other Candidate Requirements

• Proficient in Python, Power BI, SQL, and Power Query
• Experience or knowledge in labour econometrics is a strong asset
• Knowledge of machine learning models and time series analysis is a strong asset
• Proficient computer skills and competent with Microsoft Office programs
• Strong communication, analytical, and customer service skills

Other Information