Senior Business Analyst, Finance and Data Transformation

Posted Yesterday
Be an Early Applicant
2 Locations
Hybrid
94K-115K Annually
Senior level
Insurance • Financial Services
The Role
Leads requirements gathering, data analysis, and financial data integration for transactional data warehouses. Translates finance and technical requirements into documented data transformation solutions, collaborates with multidisciplinary teams, supports testing, tracks delivery, and presents solutions to stakeholders. Requires extensive business analysis experience in finance or financial systems, strong ETL, SQL, data modeling, database, and ERP knowledge, plus excellent communication and project management skills.
Summary Generated by Built In

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 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 of the organization, including management and some external contributors.
  • No Canadian work experience required however must be eligible to work in Canada.
  • For candidates located in Quebec, bilingualism is required considering the necessity to interact on a regular basis with English-speaking colleagues across the country

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

If you are an employee of Intact or belairdirect, please apply for this role on Internal Career Site.

Skills Required

  • Bachelor's degree in business administration, information systems management, business intelligence, or equivalent education and experience
  • Minimum 8 years of relevant experience as a business analyst for a finance team and/or financial systems
  • Excellent communication skills for gathering, synthesizing, documenting, and presenting requirements
  • Strong understanding of ETL principles, data elements, data structures, and data modeling
  • Knowledge of databases, financial systems, IT systems, data warehouses, SQL, SAS, ETL tools, and ERP systems such as Oracle or SAP
  • Proficiency with Microsoft 365, Excel, Visio, Jira, RDBMS, Toad, and Microsoft SQL Server
  • 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, independence, and effectiveness
  • Ability to interact with employees at all organizational levels and external contributors
  • Eligibility to work in Canada throughout employment
  • Bilingualism in Quebec for regular interaction with English-speaking colleagues
  • Studies or minor in finance or accounting
  • CPA designation
  • IFRS 17 experience
  • Knowledge of the property and casualty insurance industry

Intact (intactfc.com) Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Intact (intactfc.com) and has not been reviewed or approved by Intact (intactfc.com).

  • Fair & Transparent Compensation — Pay is often framed as competitive for core roles like tech, underwriting, and claims, with base pay and total compensation commonly positioned above typical sector benchmarks. Salary ranges and bonus targets are frequently presented as explicit components of the package, which supports clarity on what compensation is intended to include.
  • Retirement Support — Retirement offerings stand out through RRSP matching and pension options that emphasize long-term security. A defined benefit pension option is also described, which is often treated as a differentiator versus many large employers.
  • Healthcare Strength — Health coverage is described as comprehensive across medical, dental, vision, and prescriptions, with additional support such as EAP services and access to virtual care. Wellness accounts and reimbursements are also included, adding breadth beyond core insurance coverage.

Intact (intactfc.com) Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Toronto
18,239 Employees
Year Founded: 1809

What We Do

We are here to help people, businesses and society prosper in good times and be resilient in bad times. This is our purpose and the foundation of our company – it drives everything we do and gives meaning to our work. - Nous sommes là pour aider les gens, les entreprises et la société à aller de l'avant dans les bons moments et à être résilients dans les moments difficiles. C'est notre raison d'être et l'essence même de notre entreprise

Similar Jobs

Block Logo Block

Strategic Pricing & Monetization Lead

Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
In-Office or Remote
8 Locations
12000 Employees
208K-312K Annually

Block Logo Block

Data Scientist

Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
In-Office or Remote
8 Locations
12000 Employees
95K-168K Annually

Block Logo Block

Mid-market Account Executive

Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
In-Office or Remote
8 Locations
12000 Employees
164K-297K Annually

Cloudflare Logo Cloudflare

Principal Customer Engineer, Central Majors - Toronto Canada

Cloud • Information Technology • Security • Software • Cybersecurity
Hybrid
Toronto, ON, CAN
4400 Employees

Similar Companies Hiring

Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees
Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
43 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account