Senior Data Developer

Salary: $101,800 - 101,800 per year Requirements: Bachelors or Masters degree in Computer Science, Software Engineering, or a related field. 8+ years of data engineering or software engineering experience, including 3+ years in a senior or lead role. Proven ability to design, build, and operate production ETL/ELT pipelines at scale, including batch and incremental loads, orchestration, scheduling, error handling, and recovery. Experience migrating data from legacy, mainframe, or packaged systems, including extraction, cleansing, normalization, reconciliation, parallel runs, and cutover. Excellent SQL and relational data modeling skills, including hierarchies, historization, and performance tuning. Strong Python or Java programming skills for data pipelines, plus experience with the AWS ecosystem. Solid knowledge of CI/CD, Git or other version control, automated data testing, and observability. Demonstrated initiative and leadership, with the ability to challenge decisions, influence others, and bring colleagues along. Authorization to work in Canada is required; Canadian work experience is not required. Intact does not provide immigration sponsorship or related support, and candidates are responsible for maintaining work eligibility throughout their employment. Candidates located in Quebec must be bilingual in French and English due to frequent collaboration with English-speaking colleagues across Canada. Preferred: Experience with AWS data services such as Glue, EMR, Step Functions, or Athena, and with Spark using PySpark or Java/Scala. Preferred: Experience with ETL or integration tools such as Informatica, Talend, DataStage, or SSIS, and enterprise schedulers such as Control-M. Preferred: Change data capture (CDC) or event-driven integration experience. Preferred: Knowledge of Master Data Management concepts, including golden records, survivorship, and reference data. Preferred: Experience with Databricks or Snowflake. Preferred: Property and casualty insurance experience, especially in broker distribution. Responsibilities: Co-design and implement the target data model with the Data Architect, including multi-level hierarchies, effective dating and history, audit and versioning, and crosswalks from legacy records to golden records; validate the model against actual legacy data. Design, build, and operate batch and incremental ETL/ELT pipelines on AWS, moving data from mainframe extracts, flat files, and databases into raw, standardized, and curated data lake layers. Make pipelines configuration-driven, restartable, idempotent, monitored, and equipped with clear error handling, orchestration, and scheduling. Lead data extraction, profiling, cleansing, normalization, matching and merging, and reconciliation through parallel runs and cutover. Convert business rules into automated data quality controls and maintain data lineage, cataloging, security, and cost control across pipelines. Publish trusted data to downstream consumers, including EDP for reporting and legacy systems through file-based backfeeds, in collaboration with the Java backend team. Implement unit, integration, and automated data tests; apply CI/CD and Infrastructure as Code practices in keeping with security and governance standards. Provide technical guidance and promote best practices through code reviews, standards, testing, and documentation. Contribute evidence-based input to design discussions, challenge decisions using real data, and participate in sprint planning. Communicate and collaborate with the Product Owner and stakeholders in a Scrum/Kanban environment focused on incremental delivery. Take ownership of work from discovery through production support, validate assumptions against data, and collaborate with technical and business partners. Technologies: AWS Architect Backend CI/CD Databricks ETL Git Informatica Support Java Kanban Product Owner Python PySpark SQL Scala Security Snowflake Spark SSIS Talend Cloud DevOps Excel More: We are Intact, where our employees are central to helping people, businesses, and society prosper in good times and remain resilient in difficult ones. This new Senior Data Developer (Engineer) role will help establish the data foundation for Contact Distributor, our new broker and distributor master-data platform, replacing fragmented legacy sources with a trusted, governed view. You will join an initial, growing, self-managed, cross-functional product squad alongside a Tech Lead, software engineers, architects, business experts, and a Product Owner. We offer flexible and hybrid work arrangements, the option to purchase up to five additional days off annually, wellbeing benefits such as telemedicine and a wellness account, a share plan and savings opportunities, an annual bonus, and pension options that include the opportunity for guaranteed lifetime income through a defined benefit plan. The salary range is $101,800–$124,400 for a 35-hour workweek, with a 12% annual bonus target and potential payout of up to twice the target, subject to individual and company performance. Pay is determined by factors including experience, skills, qualifications, anticipated contribution, and internal equity; candidates outside the stated range are also encouraged to apply. We are an equal opportunity employer committed to respect, accessibility, inclusion, and reconciliation, and we welcome applications from equity-deserving groups. We provide workplace accommodations and can discuss adjustments to support an accessible recruitment process. Intact and belairdirect employees should apply through the internal career site. last updated 41 week of 2026