Data Analyst II

Intact

Data Analyst II at Intact, responsible for creating reports, monitoring trends, and analyzing data. Collaborating on data solutions using Power BI and SQL to support business insights.

Posted 4/15/2026full-timeCalgary • 🇨🇦 CanadaMid-LevelSenior💰 CA$69,200 - CA$84,600 per yearWebsite

Tech Stack

Tools & technologies

SQL

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 and 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 PowerBI, SQL, and Excel.
Support ad hoc reporting as new needs arise.

Requirements

What you’ll need

Bachelor’s degree in data-related field (i.e., Mathematics, Science, Statistics, AI, Computer Science, etc.), or any combination of equivalent education and experience.
An advanced SQL and Power BI skillset is required.
Familiarity with Snowflake or SQL Server Management Studio is considered an asset.
Minimum three years or more, of relevant work experience as a data analyst.
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.
Bilingualism (English French) - For candidates located in Quebec, bilingualism is required considering the necessity to interact on a regular basis with English-speaking colleagues across the country.

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 (ask how you could earn guaranteed income for life)

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 & Tools

SQLPower BIExceldata analysisdata cleaningKPI monitoringreportingtechnical solutionsdata consolidationtrend analysis

Soft Skills

communicationtime managementorganizationcritical thinkinganalytical skillsattention to detailinitiativecollaborationpresentation skillsbilingualism