Data Analyst - Risk Control

Our employees are at the heart of everything we do. Together, we help people, businesses, and society prosper in good times and be resilient in bad times.

Our employee promise represents Intact’s commitment to you in exchange for living our Values, striving to do your best work, being open to change and investing in your career. In return, we promise to provide support, opportunities and performance-led financial rewards at a workplace where you can shape the future, win as a team and grow with us.

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

We’re looking for a Risk Control Data Analyst (or Sr. Risk Control Data Analyst) to join our growing team. This is a high-impact analytics role for someone who wants to strengthen how Risk Control measures performance, demonstrates value, and reduces operational risk through reliable reporting and scalable data foundations.

You’ll combine strong technical skills (SQL, Power BI, data modeling) and business judgment to spot trends early, surface actionable insights, and help leaders make better decisions. You’ll partner closely with Risk Control and stakeholders across the organization to ensure data is trusted, consistent, and easy to use.

About the role

As a Risk Control Data Analyst, you will provide advanced analytics and decision support across divisions and business units, with primary support to Risk Control. You will own and continuously improve KPI/scorecard reporting, deliver deep-dive and predictive analytics, and strengthen reporting governance.

A key part of the role is improving reliability—building documented, sustainable processes and backup capability for core reporting and executive decision support—so leaders have timely, accurate insights.

Key Responsibilities:

KPI Ownership, Scorecards & Monthly Reporting

• Own production, accuracy, and continuous improvement of KPIs, scorecards, and monthly data compilation.

• Create standardized definitions, documentation, and quality controls to ensure consistent reporting.

• Establish redundancy/backup-ready processes to mitigate reporting continuity risk.

Power BI Development, Visualization & Governance

• Design, build, and maintain Power BI dashboards with detailed visualizations and drill-through capability.

• Maintain and enhance Power BI reporting across LC360 and workspace SharePoint environments.

• Implement governance and reliability practices (dataset standards, refresh schedules, workspace organization, version control, monitoring).

Data Extraction, SQL & Data Modeling

• Write and optimize SQL queries across multiple database sources to create analysis-ready datasets.

• Build and maintain semantic models and curated datasets that enable self-service and consistent metrics.

• Automate and streamline recurring reporting to reduce manual effort and improve timeliness.

Data Governance & Scalable “Data-First” Foundation (RC)

• Improve RC data governance and infrastructure so data is structured, centralized, and scheduled.

• Establish repeatable pipelines and documentation (data dictionaries, KPI logic, refresh cadence).

• Enable a scalable and reliable data foundation for ongoing analytics and reporting growth.

Cross-Functional Partnership & Shared-Service Enablement

• Partner with teams across CL and SL, Data Lab, Claims, and other business units to align methodologies.

• Support a shared model covering both Corporate and RC priorities to maximize value across both areas.

Strategic Initiatives, ROI & Value Proposition Measurement

• Support national initiatives by providing data strategy, ROI measurement, and loss savings/mitigation estimation.

• Build measurement frameworks and analytics for initiatives such as Intelliroute, Farm Sentinel, snow removal program, mass prevention campaigns, emerging loss trending, extreme weather targeting, EB loss analysis, etc.

• Monitor (near real-time where feasible) RC value-added benefits such as pre-bind value-add, loss avoidance, risk alerts (Level 1), and premium leakage to support RC value proposition reporting.

Required Qualifications:

• Post secondary education in Data Analytics

• Minimum 3 years experience delivering analytics, insights, and recommendations for leaders – is required.

• Advanced SQL skills; ability to integrate data from multiple sources.

• Advanced Power BI skills (data modeling, DAX, visualization, publishing, governance, refresh management).

• Strong communication skills, including presenting to both technical and non-technical audiences.

• Proven ability to own recurring reporting processes with high reliability and documented standards.

Preferred Qualifications:

• Experience with predictive analytics, forecasting, and building leading indicators.

• Experience in insurance, claims, risk control, loss prevention, or operational performance analytics.

• Experience with data governance practices and building centralized, standardized datasets.

• Experience partnering with analytics Data Labs and cross-functional business units.

• For candidates located in Quebec, bilingualism is required considering the necessity to interact on a regular basis with English-speaking colleagues across the country.

Core Competencies:

• Analytical rigor and business judgment

• Strong stakeholder management and collaboration

• Clear, executive-ready communication and data storytelling

• Ownership mindset and operational reliability focus

• Continuous improvement orientation (automation, standardization, governance)

#LI-Hybrid

Il s'agit d'un nouveau rôle au sein de notre équipe en pleine croissance | This role is a new member of our growing 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.

Learn more about our recruitment process and your candidate journey here.

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.

If you are an employee of Intact or belairdirect, please apply for this role on Internal Career Site.