Specialist, Workforce Analyst

Canada Post; Ottawa; On-site; CAD 60,000 - 90,000; Full time

Job summary

A leading organization is seeking a Specialist, Workforce Analyst to enhance HR strategies through data-driven forecasting and analysis. The role will focus on attrition forecasting, workforce planning, and using advanced tools like Python and Power BI. Candidates should have relevant experience and educational background to succeed in this pivotal position.

Qualifications

• Education in Economics, Data Science, or Computer Science preferred.
• 1 to 3 years of relevant experience is required.
• Proficiency in statistical models is beneficial.

Responsibilities

• Plans corporate attrition forecasts using statistical models.
• Supports HR negotiations by providing attrition forecasts.
• Develops automated Excel spreadsheets for workforce data capture.

Skills

Python

Power BI

SQL

Power Query

Analytical Skills

Communication

Education

Post-secondary in Economics, Data Science, or Computer Science

Job description

Job Requisition Id: 192257
Business Function: Human Resources
Primary City: Ottawa
Other Location(s):GTA and Montréal
Province:Ontario
Employment Type: Full-Time
Employment Status:Permanent
Language Requirement: English Essential
Employee Class and Level: CPMGA01
Number of Vacancies 1
Job Closing Date (YYYY-MM-DD): 2025-06-19

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

Canada Post’s values and behaviours

Our Values - Trust, Respect and Deliver represent our fundamental promise to ourselves, our expectations of one and another and our shared duty to our country.

Our behaviours – Make the call, Know the destination, Deliver for others, Ignite our pride; embody our values, bringing them to life and guiding our actions.

We’re committed to living these values and practicing these behaviours every day. Learn more about the values and behaviours by visiting the Canada Post website.