Senior Data Engineer — Cloud Etl, Governance & Hybrid

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):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 roleWe 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 stakeholders in a Scrum/Kanban product culture focused on incremental delivery.
Qualifications:Required:Bachelor's or Master's degree in Computer Science, Software Engineering or a related field.8+ years of experience in data engineering / software engineering, including 3+ years in a senior or lead role.Proven experience designing, building and running production ETL/ELT pipelines at scale (batch and incremental loads, orchestration, scheduling, error handling and recovery), whether code-based or with ETL tools.Demonstrated experience migrating data from legacy/mainframe or packaged systems (extraction, cleansing, normalization, reconciliation, dual-run/cutover).Excellent SQL and relational data modeling skills (hierarchies, historization), including performance tuning.Strong programming skills in Python or Java for data pipelines, plus AWS ecosystem.Solid understanding of CI/CD, version control (Git), automated data testing and observability.Demonstrated initiative and leadership: able to challenge, influence and bring others along.No Canadian work experience is required;
however, candidates must be authorized to work in Canada.For candidates located in Quebec, bilingualism in French and English is required due to frequent collaboration with English-speaking colleagues across Canada.
Preferred:Experience with AWS data services (Glue, EMR, Step Functions, Athena) and Spark (PySpark or Java/Scala).Experience with ETL/integration tools (e.G. Informatica, Talend, DataStage, SSIS) and enterprise schedulers (e.G. Control-M).Change data capture (CDC) or event-driven integration experience.Knowledge of Master Data Management concepts (golden record, survivorship, reference data).Experience with Databricks or Snowflake.Experience in the P&C insurance industry, especially broker distribution.#LI-HybridIl 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 employerAt 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.
#J-18808-Ljbffr