Full Stack Data Engineer

Manulife; Southwestern Ontario; Hybrid; CAD 86,000 - 136,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

Manulife is seeking a highly skilled Full-Stack Data Engineer for Modernization & Migration to join the Insurance Licensing & Compensation Engineering team. Focus on migrating legacy licensing and compensation capabilities to a vendor Platform & Data Lake, building scalable ETL/ELT pipelines and reports for downstream feeds.

The role requires strong SQL, Informatica/ADF/Databricks, data warehousing, modeling, and governance, with experience across licensing, compensation, and enterprise data

Qualifications

• Bachelor’s degree or equivalent professional experience.
• 4+ years of experience in data engineering, ETL development, data migration, cloud data engineering.
• Advanced SQL skills with large/complex datasets.
• Hands-on experience with ETL/ELT platforms (Informatica, ADF, Databricks).
• Experience with data warehousing, 3NF and dimensional modeling.
• Experience delivering data via SFTP, MFT, APIs or integration frameworks.
• Experience with data-quality controls, reconciliation, and governance.
• Experience with Power BI/Tableau/SSRS/Cognos/Crystal Reports for reporting.

Responsibilities

• Analyze data structures, relationships, transformations, and business rules across legacy systems and related platforms.
• Design and develop ETL/ELT pipelines using Informatica, ADF, SQL or Databricks for data conversion and downstream delivery.
• Support migration and conversion of data into target compensation platform and Data Lake.
• Perform source-to-target mapping, profiling, cleansing, transformation, validation, and reconciliation.
• Design and maintain 3NF, dimensional, and analytical data models for reporting and reconciliation.
• Build automated data extracts, interfaces, and feeds for Finance, Distribution, Operations, Treasury, and others.
• Develop reporting using Power BI, Tableau, Cognos, SSRS, or Crystal Reports.
• Implement data-quality controls, financial reconciliation, and auditability measures.
• Collaborate with analysts, engineers, architects, and Operations to translate legacy requirements.
• Investigate data issues and provide root-cause analysis and remediation.
• Build scheduling, monitoring, and exception-handling for production pipelines.
• Maintain data lineage, mappings, and technical specs for auditability.
• Support migration planning, test-data prep, cutover, and post-production stabilization.

Skills

Advanced SQL

Informatica

Azure Data Factory

Databricks

Power BI

Tableau

SSRS

Cognos

Education

Bachelor’s degree in CS/Software Eng/Data Eng or related field

Tools

Informatica

Azure Data Factory

Databricks

Job description

Manulife / John Hancock is seeking a highly skilled Full-Stack Data Engineer, Modernization & Migration to join our Insurance Licensing & Compensation Engineering team.

The successful candidate will play a key role in the migration of legacy licensing & compensation capabilities to vendor Platform & Data Lake.

This role will focus on analyzing and transforming complex legacy data, building scalable ETL/ELT pipelines, supporting data conversion and reconciliation, and developing the reports, extracts, and downstream feeds required to enable the future-state platform.

The ideal candidate combines strong SQL, Informatica/ADF/Data Bricks, data warehousing, data modeling, ETL, reporting, and data analysis skills with the ability to understand complex business rules and data relationships across legacy and modern platforms.

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

• Build automated data extracts, interfaces, and feeds for Finance, Distribution, Operations, Treasury, and other enterprise consumers.

• Develop operational, reconciliation, and analytical reporting using tools such as Power BI, Tableau, Cognos, SSRS, or Crystal Reports.

• Develop automated controls to validate record counts, financial totals, balances, results, and source-to-target completeness.

• Partner with business analysts, engineers, architects, and Operations to translate legacy data structures and processing requirements into future-state solutions.

• Investigate complex data issues across source systems, transformation layers, target vendor platform, and downstream consumers and support root-cause analysis and remediation.

• Build and maintain scheduling, monitoring, alerting, restart, and exception-handling capabilities for production data pipelines.

• Maintain clear data lineage, mappings, transformation rules, technical specifications, and reconciliation evidence to support auditability and production readiness.

• Contribute to migration planning, test-data preparation, conversion rehearsals, parallel validation, cutover, and post-production stabilization.

Required Qualifications:

• Bachelor’s degree in Computer Science, Software Engineering, Data Engineering, or a related field, or equivalent professional experience.

• 4+ years of experience in data engineering, ETL development, data migration, Cloud data engineering.

• Advanced SQL skills with experience analyzing and transforming large and complex datasets.

• Strong hands-on experience with Informatica, Azure Data Factory (ADF), Data Bricks or comparable ETL/ELT platforms.

• Strong working knowledge of data warehousing, 3NF, Medallion Architecture, dimensional modeling, and enterprise data-model design.

• Work experience with large-scale data migration or system-conversion initiatives, including source-to-target mapping, profiling, transformation, validation, and reconciliation.

• Experience building automated extracts and file-based integrations, including CSV, TSV, XML, JSON, or similar formats.

• Experience delivering data through SFTP, Managed File Transfer (MFT), APIs, or enterprise integration frameworks.

• Strong experience implementing data-quality controls, financial reconciliation, exception handling, data governance and auditability.

• Practical experience developing operational or analytical reporting using Power BI, Tableau, SSRS, Crystal Reports, or similar technologies.

• Experience with scheduling and orchestration technologies such as ADF, CA WLA or MuleSoft.

• Strong analytical and troubleshooting skills with the ability to reverse-engineer complex legacy data structures and transformation logic.

• Strong communication skills with the ability to work across engineering, architecture, operations, and business teams.

Preferred Qualifications:

• Experience with legacy-system modernization and complex data-conversion programs.

• Exposure to Azure Databricks, Synapse, Spark, Python or other modern cloud/data platforms.

• Experience with Git, CI/CD pipelines, automated deployment, and DevOps practices for data engineering workloads.

• Familiarity with REST APIs, API gateways, Kafka, Azure Event Hubs, or event-driven integration patterns.

• Background in insurance, financial services, producer compensation, or distribution technology would be a strong asset.

• Strong communication, analytical, problem-solving skills.

• Experience with AI, Business Intelligence (BI), and/or Generative AI solutions.

When you join our team:

• We’ll empower you to learn and grow the career you want.

• We’ll recognize and support you in a flexible environment where well-being and inclusion are more than just words.

• As part of our global team, we’ll support you in shaping the future you want to see.

#LI-Hybrid

The role being advertised is an existing vacancy.

Acerca de Manulife y John Hancock

Manulife Financial Corporation es un importante proveedor internacional de servicios financieros que ayuda a las personas a tomar decisiones de una manera más fácil y a vivir mejor. Para obtener más información acerca de nosotros, visite http://www.manulife.com .

Manulife es un empleador que ofrece igualdad de oportunidades

En Manulife/John Hancock, valoramos nuestra diversidad. Nos esforzamos por atraer, formar y retener una fuerza laboral tan diversa como los clientes a los que prestamos servicios, y para fomentar un entorno laboral inclusivo en el que se aprovechen las fortalezas de las culturas y las personas. Estamos comprometidos con la equidad en las contrataciones, la retención de talento, el ascenso y la remuneración, y administramos todas nuestras prácticas y programas sin discriminación por motivos de raza, ascendencia, lugar de origen, color, origen étnico, ciudadanía, religión o creencias religiosas, credo, sexo (incluyendo el embarazo y las afecciones relacionadas con este), orientación sexual, características genéticas, condición de veterano, identidad de género, expresión de género, edad, estado civil, estatus familiar, discapacidad, o cualquier otro aspecto protegido por la ley vigente.

Nuestra prioridad es eliminar las barreras para garantizar la igualdad de acceso al empleo. Un representante de Recursos Humanos trabajará con los solicitantes que requieran una adaptación razonable durante el proceso de solicitud. Toda la información que se haya compartido durante el proceso de solicitud de adaptación se almacenará y utilizará de manera congruente con las leyes y las políticas de Manulife/John Hancock correspondientes. Para solicitar una adaptación razonable en el proceso de solicitud, envíenos un mensaje a [e-mail] .

Referenced Salary Location

Toronto, Ontario

Modalidades de Trabajo

Híbrido

Base salary range is expected to be between

$86,100.00 CAD - $136,100.00 CAD

Los empleados también tienen la oportunidad de participar en programas de incentivos y recibir una compensación vinculada al rendimiento empresarial e individual. El salario real variará según las condiciones del mercado local, la geografía y factores relacionados con el puesto como conocimientos, habilidades, requerimientos, experiencia y educación/formación. Si solicitas este puesto fuera de tu ubicación principal, por favor escríbenos a [e-mail] para conocer el rango salarial correspondiente a tu ubicación.

Manulife ofrece a los empleados aptos una amplia variedad de beneficios personalizables, entre ellos, beneficios de salud, odontológicos, de salud mental, oftalmológicos, por discapacidad a corto y a largo plazo, cobertura de seguro de vida y por muerte accidental y desmembramiento, adopción/subrogación y bienestar, y planes de asistencia al empleado/familiar. También ofrecemos a los empleados admisibles varios planes de ahorro para la jubilación (incluidos planes de pensiones y un plan mundial de propiedad de acciones con contribuciones equivalentes del empleador) y recursos de asesoramiento y educación financiera. Nuestro generoso programa de tiempo libre remunerado en Canadá incluye feriados, vacaciones, días personales y días por enfermedad, y ofrecemos la gama completa de ausencia laboral reglamentaria. Si se está postulando para este puesto en los EE. UU., póngase en contacto con [e-mail] para obtener más información sobre las disposiciones relativas al tiempo libre remunerado específicas de EE. UU.

We use data and analytics technologies, such as artificial intelligence (AI), and automated processing tools, to analyze and process the information you provide to us or third parties in the application process. For more information, please refer to our personal information collection statement (https://careers.manulife.com/global/en/talentacquisitionprivacystatement) .