Sql jobs in Canada

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.

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 a team that collaborates to deliver both large projects and small improvements. The analyst must understand the business, financial, and IT aspects of the requirements, and lead the design and delivery stages of initiatives end‑to‑end. The analyst is responsible for requirements for transactional data warehouses, including policies, claims, expenses, IBNR and related topics. Daily tasks involve documenting data integration, transformation, and optimizing data flows in financial systems.

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

• 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 work experience in Canada is required but must have the authorization to work in Canada.
• Bilingualism (French and English) – requires regular interaction with colleagues across the country.

• A financial rewards program that recognizes your success.
• An industry‑leading Employee Share Purchase Plan; we match 50% of net shares purchased.
• An extensive flex pension and benefits package, with access to virtual healthcare.
• Flexible work arrangements.
• Possibility to purchase up to 5 extra days off per year.
• An annual wellness account that promotes an active and healthy lifestyle.
• Access to tools and resources to support physical and mental health, embracing change and connecting with colleagues.
• A dynamic workplace learning ecosystem complete with learning journeys, interactive online content, and inspiring programs.
• Inclusive employee‑led networks to educate, inspire, amplify voices, build relationships and provide development opportunities.
• Inspiring leaders and colleagues who will lift you up and help you grow.
• A Community Impact program, because what you care about is a part of what makes you different. How you contribute to your community is just as unique.

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.