Data Analyst II

Intact

Data Analyst II in Claims Supply Chain team turning complex data into insights. Creating reports, monitoring trends, and collaborating for actionable data-driven decisions.

Posted 7/21/2026full-timeToronto • 🇨🇦 CanadaMid-LevelSenior💰 CA$69,200 - CA$84,600 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data analysis, report creation, and KPI monitoring, with a strong proficiency in Advanced Excel and data consolidation. Capable of effectively communicating insights to diverse audiences and developing technical solutions to enhance business performance.

Highest-signal resume keywords

Data AnalysisAdvanced ExcelReport CreationKPI MonitoringBilingualism (English & French)

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data ConsolidationVLOOKUPXLOOKUPPivot TablesMulti-Step FormulasTrend AnalysisTechnical Solution DevelopmentAd Hoc ReportingDocumentation CreationPerformance Insight Identification

Soft Skills

Effective CommunicationTime ManagementOrganizationCritical ThinkingAttention to Detail

Tools & Technologies

Power BIExcel

Industry Keywords

Data-Related FieldFinanceMathematicsScienceStatisticsAIComputer Science

About the role

Key responsibilities & impact

Create and publish reports
Monitor, identify, and analyze trends, explaining outliers and providing influential feedback related to results and productivity
Consolidate data from various sources, ensuring data is clean
Build and maintain an inventory of data and support the monitoring of KPIs
Proactively identify new data elements that may provide further insight into performance or business trends
Analyze and present information clearly and concisely to diverse audiences within the organization
Create and maintain effective documentation to assist in training and reinforcement of workflows & best practices, and to satisfy audit protocol
Conceptualize, develop, and implement technical solutions to meet the evolving needs of our partners
Work in collaboration with project team members, leading the development of new reports using PowerB and Excel
Support ad hoc reporting as new needs arise
Proactively identify new data elements that may provide insight into performance.

Requirements

What you’ll need

Bachelor’s degree in data-related field (Finance, Mathematics, Science, Statistics, AI, Computer Science, etc.), or any combination of equivalent education and experience
Between 3 - 5 years of relevant work experience as a data analyst – is required
Advanced Excel; comfortable building and troubleshooting spreadsheets that use VLOOKUP/XLOOKUP , pivot tables, and multi-step formulas to reconcile data and explain outliers – is required
For candidates located in Quebec, bilingualism is required (English & French) - considering the necessity to interact on a regular basis with English-speaking colleagues and external vendors across the country
Can communicate effectively with diverse audiences verbally and in writing
Excellent time management and organization skills, managing competing priorities to meet deadlines
Strong critical thinking and analytical skills with high attention to detail
Dynamic individual with a high level of energy and strong initiative
No Canadian work experience required however must be eligible to work in Canada.

Benefits

Comp & perks

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