Senior IT Business Analyst, Data and Analytics

Intact

Senior IT Business Analyst specializing in Data and Analytics for Intact, defining IT solutions and supporting quality assurance activities. Engaging with business users and IT teams to recommend best IT practices.

Posted 5/29/2026full-timeMontréal • 🇨🇦 CanadaSenior💰 CA$94,200 - CA$115,200 per yearWebsite

Tech Stack

Tools & technologies

CloudETLOracleSQL

About the role

Key responsibilities & impact

Analyze business needs to define IT solutions.
Facilitate/participate in business requirements workshops to specify IT solutions.
Perform impact analyses and effort estimates to recommend, obtain approval for, and document the IT solution using effective methods, interacting with both business users and the IT project team.
Support solution development and technical analyses.
Support quality assurance activities and user acceptance testing (UAT).
Support the Product Manager in defining and prioritizing the product backlog.
Document user stories so they are clearly understood by designers and the QA team.
Identify and communicate impacts on business processes to support change management in business units using a train-the-trainer approach.
Build and maintain functional documentation that is robust, accurate, and accessible to all business stakeholders.

Requirements

What you’ll need

Bachelor’s degree in Information Technology, Software Engineering, or any equivalent combination of education and experience.
At least 5 to 7 years of relevant experience.
Strong experience with Snowflake (cloud) databases.
Strong experience with Oracle databases.
Experience in data integration (data warehouse and data mart).
Strong knowledge of data extraction, transformation, and loading (ETL) techniques.
Strong experience with SQL queries.
Experience with data modeling approaches, star schemas, and relational models.
Experience with AI tools such as Cortex Code, Claude, GitHub Copilot, ChatGPT, etc.
Project experience using Scrum methodology.
Experience and knowledge in the insurance industry.
Proficiency with JIRA and Confluence.
Bilingualism required for candidates located in Quebec 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

data integrationETL techniquesSQL queriesdata modelingstar schemasrelational modelsSnowflakeOracle databasesAI toolsScrum methodology

Soft Skills

business analysiscommunicationfacilitationdocumentationchange managementcollaborationprioritizationquality assuranceuser acceptance testingtrain-the-trainer

Certifications

Bachelor’s degree in Information TechnologyBachelor’s degree in Software Engineering