Workforce Planning, Senior Analyst

Intact FC • Montreal, QC

23h • CA$69,200 - CA$84,600 • Hybrid

About The Position

This strategic role, at the intersection of analysis and influence, was designed with you in mind. It focuses on turning complex data into clear decisions, with comfort in both Excel spreadsheets and 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 professional experience in Canada is required, but a valid Canadian work permit is necessary.
• Bilingualism (French and English) – required to communicate regularly with colleagues across the country.

Nice To Haves

• 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—you’re not one to settle for the status quo.
• Maintain and optimize our 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
• Annual bonus target, based on the base salary, with a potential payout of up to double the target (subject to personal and company performance)
• Employee Share Purchase Plan (ESPP) – with Intact matching 50% of your net shares
• Defined benefit pension plan offering guaranteed income for life

What This Job Offers

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