Senior Business Analyst, Finance and Data Transformation

intactfc; Toronto; Hybrid; CAD 94,000 - 115,000; Full time

Job summary

Intact is seeking a Senior Business Analyst with expertise in financial systems and transactional data warehouses to join our Business Data & Design team. You will lead end-to-end initiatives, understand business, financial, and IT impacts, and collaborate across finance and IT to document data integration and transformation solutions.

You will translate requirements, analyze data, and present findings in executive settings while coordinating with cross-functional teams to ensure timely delivery

Qualifications

• Bachelor's degree in business administration, information systems management, business intelligence, or equivalent.
• Minimum of 8 years of relevant experience as a business analyst for a finance team and/or financial systems.
• Excellent communication skills to gather clear requirements and present to colleagues and executives.
• Strong understanding of ETL principles, data elements, data structures, and data modeling.
• Knowledge of databases, financial IT systems, and technologies (data warehouse, SQL, SAS, ETL tools, ERP systems like Oracle, SAP).
• Proficient use of Office 365, Excel, Visio, Jira, RDBMS (e.g., Toad, MS SQL server).
• CPA designation and IFRS17 experience are considered an asset.
• Knowledge of the P&C insurance industry is a major asset.
• Ability to work in a fast-paced environment and manage multiple projects simultaneously.

Responsibilities

• Lead or support requirement gathering meetings with finance or technical advisors and translate them into clear documentation.
• Conduct data queries, perform data analysis, challenge requirements, and find solutions to integrate new data flows or update existing ones.
• Collaborate with multidisciplinary teams to develop, design, and document data integration and transformation solutions to meet business requirements.
• Present in peer reviews, executive meetings, or to technical experts to identify the best solutions and thus deliver functional requirements for development.
• Track progress, list work to be done, meet deadlines, and update the work management tool accordingly.
• Deliver expected results to business and technical stakeholders to meet testing requirements.
• Support the testing team in certain validations and preparing data.

Skills

Communication

Analytics

Leadership

Education

Bachelor's degree in business administration / information systems management / BI

Tools

SQL

SAS

ETL tools

Oracle

SAP

MS SQL Server

Excel

Jira

Toad

Visio

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.

Benefits

• 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 Business Analyst with experience in financial systems, specifically with a transactional data warehouse, to join our Business Data & Design team!

Under the vice‑presidency of the finance, transformation, and systems team, the Senior Business Analyst will be part of one of the teams that collaborate to deliver both large projects and small improvements. We are looking for a candidate who understands the business, financial, and IT aspects of the requirements. In addition to understanding the impacts on financial systems, this person will lead the design and delivery stages of initiatives end‑to‑end. Our team is responsible for the requirements for transactional data warehouses, so the analyst must have a comprehensive understanding across topics such as policies, claims, expenses, IBNR, etc. Documenting data integration, their transformation, and optimizing data flows in financial systems are our daily tasks.

What you'll do here:

• Lead or support requirement gathering meetings with finance or technical advisors and translate them into clear documentation.
• Conduct data queries, perform data analysis, challenge requirements, and find solutions to integrate new data flows or update existing ones.
• Collaborate with multidisciplinary teams to develop, design, and document data integration and transformation solutions to meet business requirements.
• Present in peer reviews, executive meetings, or to technical experts to identify the best solutions and thus deliver functional requirements for development.
• Track progress, list work to be done, meet deadlines, and update the work management tool accordingly.
• Deliver expected results to business and technical stakeholders to meet testing requirements.
• Support the testing team in certain validations and preparing data.

What you bring to the table:

• Bachelor's degree in business administration, information systems management, business intelligence, or an equivalent combination of education and experience.
• Studies/minor in finance or accounting are considered a plus.
• Minimum of 8 years of relevant experience as a business analyst for a finance team and/or financial systems.
• Excellent communication skills to gather clear and complete requirements, synthesize them, and present them to colleagues and executives.
• Strong understanding of ETL principles, data elements, data structures, and data modeling.
• Knowledge of databases, financial, IT systems, and technologies (data warehouse, SQL, SAS, ETL tools, ERP systems like Oracle, SAP, etc.).
• Proficient use of Office 365, Excel, Visio, Jira, RDBMS (e.g., Toad, MS SQL server).
• CPA designation and IFRS17 experience are considered an asset.
• Knowledge of the P&C insurance industry is a major asset.
• Ability to work in a fast‑paced environment and manage multiple projects simultaneously.
• Ability to learn quickly.
• Strong analytical skills, insight, and discipline.
• Leadership skills, team spirit, independent and effective.
• Ability to interact with a variety of people at all levels.