- Toronto, Ontario, Canada
- Hybrid
- Full-time · Senior
- CA$86K–CA$136K per year
- 4+ years
Highly skilled Full-Stack Data Engineer, Modernization & Migration to join our Insurance Licensing & Compensation Engineering team, focusing on migrating legacy licensing & compensation capabilities to vendor Platform & Data Lake.
Compensation
Base salary range is expected to be between $86,100.00 CAD - $136,100.00 CAD
Responsibilities
- Analyze data structures, relationships, transformations, and business rules across multiple legacy systems, and related upstream and downstream platforms.
- Design and develop ETL/ELT pipelines using Informatica, Azure Data Factory (ADF), SQL, or Databricks to support data conversion, integration, and downstream delivery.
- Support the migration and conversion of data into the target compensation platform and the Data Lake.
- Perform source-to-target mapping, data profiling, cleansing, transformation, validation, and reconciliation throughout the migration lifecycle.
- Design and maintain 3NF, dimensional, and analytical data models supporting business processing, reporting, reconciliation, and downstream consumption.
Requirements
- Bachelor’s degree in Computer Science, Software Engineering, Data Engineering, or a related field
- Nice to have: legacy-system modernization
- Nice to have: Azure Databricks
- Nice to have: Synapse
- Nice to have: Spark