CareerPlan

Full Stack Data Engineer

Toronto, Ontario, CAFull-timeCA$86k–CA$136k2026-11-13 → 2026-11-16
Hybrid

Core

Migrate legacy insurance licensing and compensation data to a modern vendor platform and Data Lake, building scalable ETL/ELT pipelines and ensuring data quality for downstream financial and operational consumers.

Role type

Senior Full-Stack Data Engineer (Modernization & Migration)

Builds

ETL/ELT pipelines, data models, automated extracts, and reconciliation reports for Finance, Distribution, and Operations.

Domain

Insurance / Financial Services / Data Engineering

Required skills

SQL, Informatica, Azure Data Factory (ADF), Databricks, Data Warehousing, Data Modeling, ETL/ELT, Data Migration, Data Reconciliation, Power BI, Tableau, SSRS, Scheduling/Orchestration

Preferred skills

Legacy system modernization, Azure Synapse/Spark/Python, Git/CI/CD, REST APIs/Kafka, Insurance domain knowledge, Generative AI

Technologies

Informatica, Azure Data Factory, Databricks, SQL, Power BI, Tableau, SSRS, Crystal Reports, MuleSoft, CA WLA

Responsibilities

Analyze legacy data structures and business rules; Design and develop ETL/ELT pipelines for data conversion; Perform source-to-target mapping, profiling, cleansing, and validation; Design and maintain dimensional data models; Build automated data extracts and interfaces; Develop operational and analytical reporting; Implement data-quality controls and financial reconciliation; Partner with business analysts and architects to translate requirements; Investigate complex data issues and support root-cause analysis; Maintain data lineage and technical specifications for auditability.

Seniority

Senior, hands-on IC