Workforce Planning, Senior Analyst

Intact; Quebec; On-site; CAD 69,200 - 84,600; Full time

Benefits offered by this job

Flexible work arrangements

Telemedicine

Employee Share Purchase Plan

Job summary

Intact in Quebec is seeking a skilled data analyst for a strategic role where you will collect and analyze workforce data to inform decision-making.

This role requires strong analytical skills, advanced Excel proficiency, and experience with Power BI. A competitive salary range of $69,200 to $84,600 is offered, along with a hybrid work model.

Qualifications

• Bachelor’s degree in business administration, finance, mathematics, or related field.
• Proficiency in analyzing and interpreting complex data.
• Strong organizational skills and attention to detail.

Responsibilities

• Collect and analyze data for workforce planning.
• Maintain capacity plans and present to executives.
• Design and update Power BI dashboards.

Skills

Analytical skills

Advanced Excel proficiency

Power BI

Bilingualism (French and English)

Education

Bachelor’s degree in business administration or related field

Tools

Excel

Power BI

SharePoint

Job description

Pay at Intact is about much more than just salary.

• 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)

Salary range (but not limited to): 69,200 - 84,600

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%

As part of our commitment to Win As A Team, we share our success with employees through our annual bonus plan and Employee Share Purchase Plan (ESPP) – with Intact matching 50% of your net shares.

Our pension offerings provide flexibility and long-term security for our employees beyond their careers. We are one of the few companies offering the opportunity to receive guaranteed income for life via our defined benefit pension plan.

Salary for the candidate will be determined taking into consideration a number of factors including: experience, skills, qualifications, anticipated contribution to role, internal equity, etc. The salary range presented above is based on a 35-hour workweek and would represent a majority of different candidate profiles. However, we encourage candidates who may fall outside of this range to apply as well.

About the role

Do you enjoy turning complex data into clear decisions? Are you just as comfortable working with an Excel spreadsheet as you are presenting to senior management? This strategic role, at the intersection of analysis and influence, was designed with you in mind.

Your responsibilities with us:

Workforce Planning and Performance

• 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

Collaboration and Continuous Improvement

• 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

Data Management and Business Intelligence

• 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

What You’ll Bring:

Education and Experience

• Bachelor’s degree in business administration, finance, mathematics, statistics, business intelligence, or a related field; or an equivalent combination of education and experience

Technical Skills

• 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

Professional Skills

• 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

Other

• 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.

Ce poste jouera un rôle essentiel au sein de notre équipe. | This position will fill an essential role in our team.

We are an equal opportunity employer

At Intact, our Value of respect is founded on seeing diversity as a strength. We strive to create an accessible workplace where employees feel valued, included and encouraged to share their unique perspectives.

We encourage applications from individuals who are members of equity-deserving groups, including but not limited to women, Indigenous peoples, persons with disabilities, Black people, and members of the 2SLGBTQI+ community.

As part of Intact’s commitment to reconciliation, we acknowledge that we work, meet and travel across the land currently called Canada, originally inhabited by First Nations, Metis and Inuit people. This history extends through many centuries and continues to evolve today.

We have policies to ensure equal access and participation for people with disabilities, including providing workplace adjustments (accommodations). A copy of applicable policies is available on request.

If we can provide a specific adjustment to make the recruitment process more accessible for you, please let us know when we reach out about a job opportunity. We’ll work with you to meet your needs.

Please note that Intact does not provide sponsorship or other support for immigration-related matters including but not limited to employer‑specific closed work permits. Candidates must be eligible to work in Canada from the anticipated start date and throughout their employment and are solely responsible for maintaining their work eligibility.