Senior Data Developer

Senior Data Developer

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