3 days ago
Montréal, CanadaSenior
Responsibilities
- Co-design and implement a governed target data model covering hierarchies, effective dating, history, audit/versioning, and legacy-to-golden-record crosswalks.
- Design, build, and operate config-driven batch and incremental ETL/ELT pipelines on AWS using robust orchestration, scheduling, monitoring, recovery, and error handling.
- Lead legacy-data extraction, profiling, cleansing, normalization, match/merge, reconciliation, parallel runs, and cutover.
- Implement automated data-quality controls and support lineage, cataloging, security, and cost controls.
- Publish trusted data to downstream reporting consumers and legacy systems through file-based integrations.
- Implement unit, integration, and automated data tests while applying CI/CD and infrastructure-as-code principles.
- Provide technical guidance, conduct code reviews, contribute to design and sprint planning, and collaborate with technical and business stakeholders.
Requirements
- Bachelor’s or Master’s degree in Computer Science, Software Engineering, or a related field.
- At least 8 years of data engineering or software engineering experience, including at least 3 years in a senior or lead role.
- Production experience designing, building, and operating large-scale batch and incremental ETL/ELT pipelines.
- Experience migrating data from legacy, mainframe, or packaged systems through cleansing, normalization, reconciliation, dual-run, and cutover.
- Excellent SQL and relational data modeling skills, including hierarchies, historization, and performance tuning.
- Strong Python or Java programming skills for data pipelines and experience with the AWS ecosystem.
- Understanding of CI/CD, Git, automated data testing, and observability.
- Demonstrated initiative and leadership, including the ability to challenge decisions, influence stakeholders, and communicate effectively.
- Authorization to work in Canada from the anticipated start date and throughout employment.
- French and English bilingualism is required for candidates located in Quebec.
- Preferred experience includes AWS Glue, EMR, Step Functions, Athena, Spark, ETL and integration tools, enterprise schedulers, CDC or event-driven integration, Master Data Management, Databricks, Snowflake, and P&C insurance.
Benefits
- Flexible work arrangements and a hybrid work model.
- Possibility of purchasing up to five additional days off per year.
- Benefits supporting physical and mental wellbeing, including telemedicine and a wellness account.
- Share plan and other savings opportunities, including employer matching through the Employee Share Purchase Plan.
- Annual bonus target of 12% of base salary, subject to personal and company performance.
- Defined benefit pension plan with an opportunity for guaranteed lifetime income.
- The role is based in Canada and follows a hybrid work arrangement.
Categories
Data Engineering
About Intact FC
Intact Financial Corporation is a Toronto-based property and casualty insurer providing home, auto, commercial, and specialty coverage to individuals and businesses in Canada, the U.S., and the U.K. It sells through brokers and direct channels (including Intact Insurance and belairdirect) and via Intact Insurance Specialty Solutions for specialty risks. Founded in 1809, Intact is publicly traded on the Toronto Stock Exchange (IFC) and is Canada’s largest P&C insurer, bolstered by acquisitions such as RSA and OneBeacon.
