Senior Data Developer

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 101,800 - 124,400

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 Data Developer (Engineer) to help establish the data foundation for Contact Distributor, Intact’s new platform for broker and distributor master data. The platform will replace fragmented legacy sources including the Halcion and Classic mainframes, Microsoft Access databases and Excel-based tools with a trusted, governed view of brokerages, broker codes and organizational hierarchies.

As a key member of the initial product squad, you will play a hands-on role in profiling, cleansing, migrating and integrating legacy data. You will also help embed data quality, governance and operational reliability into the product from day one. You will work in a self-managed, cross-functional product team alongside a Tech Lead, software engineers, architects, business experts and a Product Owner.

The ideal candidate is a hands-on senior data engineer who can independently design, build and operate production-grade data pipelines. You are comfortable working with incomplete information, validating assumptions against real data, taking ownership from discovery through production support, and challenging decisions constructively. You bring ideas forward and collaborate effectively with both technical and business stakeholders.

Key Responsibilities

• Data Modeling: Co-design and implement the target data model with the Data Architect: multi-level hierarchies, effective dating and history, audit/versioning, and legacy-to-golden-record crosswalks. Validate the model against real legacy data rather than assumptions.
• ETL / ELT Development: Design, build and operate batch and incremental ETL/ELT pipelines on AWS, from mainframe extracts, flat files and databases into a layered data lake (raw, standardized, curated). Make pipelines config-driven, so a new source means new configuration, not new code. Build them to be restartable, idempotent and monitored, with clear error handling, orchestration and scheduling.
• Data Migration: Lead extraction, profiling, cleansing, normalization, match/merge and reconciliation through parallel run and cutover.
• Data Quality & Governance: Turn business rules into automated data quality controls. Ensure lineage, cataloging, security and cost control across pipelines.
• Integration: Publish trusted data to downstream consumers, such as EDP for reporting and legacy systems through file-based backfeeds, working closely with the Java backend team.
• Quality & DevOps: Implement unit, integration and automated data tests. Apply CI/CD and Infrastructure as Code principles, in line with security and governance standards.
• Leadership & Collaboration: Provide technical guidance, promote best practices (code reviews, standards, tests, documentation), and challenge decisions with evidence from real data. Contribute to design discussions and sprint planning, and communicate effectively with the Product Owner and s