Senior Finance Data Transformation Analyst | Hybrid

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

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