Workforce Planning, Senior Analyst

Intact FC • Montreal, QC

7d • CA$69,200 - CA$84,600 • Hybrid

About The Position

This strategic role is at the intersection of analysis and influence, designed for individuals who enjoy turning complex data into clear decisions and are comfortable working with Excel spreadsheets as well as presenting to senior management.

Requirements

• Bachelor’s degree in business administration, finance, mathematics, statistics, business intelligence, or a related field; or an equivalent combination of education and experience.
• Advanced proficiency in Excel (modeling, pivot tables, complex formulas).
• Proficiency with Power Query and Power BI data processing tools (reporting, dashboards, DAX—a significant asset).
• Good knowledge of SharePoint.
• Proficiency in PowerPoint.
• Knowledge of SQL query languages—a plus.
• Strong analytical skills and attention to detail.
• Diligence and ability to research, gather, and organize information.
• Excellent communication skills, particularly when presenting to executive-level audiences.
• Strong organizational skills and ability to prioritize.
• Ability to work independently and manage multiple projects simultaneously.
• Ability to quickly identify inconsistencies and anomalies in data and reports.
• Keen attention to detail, enabling the detection of errors before they reach stakeholders.
• Natural inclination to get to the bottom of issues and propose concrete, effective solutions.
• No Canadian work experience required however must be eligible to work in Canada.
• Bilingualism (French and English) – required to communicate regularly with colleagues across the country.

Nice To Haves

• Proficiency with Power Query and Power BI data processing tools (reporting, dashboards, DAX—a significant asset).
• Knowledge of SQL query languages—a plus.

Responsibilities

• Collect, analyze, model, and interpret data from various sources to formulate strategic recommendations for workforce planning.
• Maintain capacity plans and present them clearly and effectively to executives at external firms and agencies.
• Produce structured performance analyses and optimization recommendations tailored to different business sectors and their stakeholders.
• Formulate hiring recommendations aligned with budgets and organizational objectives.
• Support business units throughout the budgeting process.
• Adapt and use forecasting models and tools.
• Establish and maintain excellent relationships with various partners both within and outside the workforce planning team.
• Serve as the primary point of contact for the firms and agencies we serve.
• Build and maintain strong, lasting relationships with executives and external partners.
• Proactively participate in initiatives to improve systems and processes.
• Find ways to streamline work methods.
• Maintain and optimize data environments, primarily in SharePoint, Power BI, and Excel.
• Design, develop, and update Power BI dashboards to enable real-time tracking of performance and capacity metrics.
• Ensure the quality, integrity, and consistency of data across various platforms.
• Identify and implement opportunities for automation and process improvement related to data.

Benefits

• Flexible work arrangements and a hybrid work model
• Possibility to purchase up to 5 extra days off per year
• Multiple benefits offered to support physical and mental wellbeing, including telemedicine, Wellness account and much more
• Share plan & other savings: up to 12% of salary or even more (ask how you could earn guaranteed income for life)
• Annual bonus target, based on the base salary, with a potential payout of up to double the target (subject to personal and company performance): 7.5%
• Employee Share Purchase Plan (ESPP) – with Intact matching 50% of your net shares.
• Defined benefit pension plan offering the opportunity to receive guaranteed income for life.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior