Senior IT Business Analyst, Data Lab

Intact FC; Toronto; Hybrid; CAD 94,000 - 115,000; Full time

Benefits offered by this job

Flexible work arrangements

Hybrid work model

Up to 5 extra days off per year

Employee Share Purchase Plan (ESPP)

Job summary

Intact is seeking a Senior IT Business Analyst to join the Data Lab and drive IT solution definitions for business needs. You will analyze requirements, document user stories, and support backlog prioritization in a collaborative, multidisciplinary environment.

We value data expertise, SCRUM experience, and the ability to work in a hybrid Canada-wide team. Competitive salary and a comprehensive benefits package are offered.

Qualifications

• Bachelor’s degree in information technology, software engineering or equivalent.
• 5–7 years of relevant experience.
• Strong SQL skills and data integration experience.
• Experience with Oracle and Snowflake databases.
• Familiarity with data warehousing, ETL and data modeling.
• Knowledge of JIRA and Confluence.
• Work authorization to work in Canada.

Responsibilities

• Analyze business needs to define IT solutions.
• Facilitate workshops to specify IT solutions.
• Document IT solutions and system impacts.
• Support QA activities and testing.
• Assist Product Manager with backlog prioritization.
• Document user stories for designers and QA.
• Maintain clear functional documentation for stakeholders.

Skills

Data analysis

SQL queries

Oracle

Snowflake

ETL

Data modeling

JIRA

Confluence

SCRUM

Education

Bachelor’s degree in information technology or software engineering

Tools

Databricks

SAS

Job description

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

94,200 - 115,200

Annual bonus target, based on the base salary, with a potential payout of up to double the target (subject to personal and company performance):

12%

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 are looking for a Senior IT Business Analyst to join our team at the Intact Data Lab. Our data science lab is one of the largest in the country. We have big ambitions and want you to be part of them. Will you join us?

Here’s an overview.

_ _

What you’ll do here:

• Analyze business needs to define IT solutions.
• Facilitate/participate in business needs specification workshops to specify IT solutions.
• Carry out impact analyzes and effort estimates to recommend, have approved, then document the IT solution using effective methods and interacting with both business domain users and the IT project team.
• Support the development of solutions and technical analyzes carried out.
• Support quality assurance activities and acceptance testing.
• Support the Product Manager in defining and prioritizing the product backlog.
• Document user stories so that they are understood by designers and the QA team.
• Identify and communicate impacts on business processes in order to support change management in business units in a train-the-trainer mode.
• Build and maintain functional, robust, precise and accessible documentation for all company stakeholders.

_ _

What you bring to the table:

• Bachelor’s degree in information technology, software engineering or any combination of equivalent education and experience.
• At least 5 to 7 years of relevant experience.
• Good experience with Oracle databases.
• Good experience with Snowflake databases (cloud)
• Experience in data integration (data warehouse and store).
• Very good knowledge of data extraction, transformation and loading techniques.Very good experience with SQL queries.
• Good experience with AI agents such as Chat GPT, Cortex code, Rovo.
• Experience with data modeling, star schema and relational models.
• Experience with SAS (an asset).
• Experience with Databricks (an asset).
• Project experiences with scrum methodology.
• Experience and knowledge in the insurance field.
• Mastery of JIRA, CONFLUENCE.
• For candidates located in Quebec, bilingualism is required considering the necessity to interact on a regular basis with English-speaking colleagues across the country.
• No work experience in Canada required, but must have authorization to work in Canada.

_ _

You are:

• A person passionate about data.
• Visionary with an innovative spirit.
• A committed team player.
• Someone who is versatile, autonomous and resourceful.
• Who learns quickly and is curious about new technologies.
• Comfortable in complex environments and multidisciplinary teams.

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