Full Stack Data Engineer

Manulife John Hancock

Toronto

On-site

CAD 110,000 - 150,000

Full time

4 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Manulife / John Hancock is seeking a highly skilled Full-Stack Data Engineer, Modernization & Migration to join our Insurance Licensing & Compensation Engineering team. You will drive migration of legacy licensing data to the vendor Platform & Data Lake, build scalable ETL/ELT pipelines, and support data conversion and reconciliation.

You will design 3NF and dimensional models, deliver automated data extracts and feeds for Finance and Operations, and develop reporting using Power BI/Tableau.

Qualifications

  • Bachelor's degree or equivalent experience in CS/SE/Data Eng.
  • 4+ years of data engineering, ETL development, and data migration.
  • Advanced SQL skills for large-scale data.
  • Hands-on with Informatica, ADF, Data Bricks.
  • Strong data warehousing, 3NF, and dimensional modeling expertise.
  • Experience with data migration projects and source-to-target mapping.
  • Experience delivering data via CSV/JSON/XML and via MFT/APIs.
  • Experience with Power BI/Tableau/SSRS/Crystal Reports for reporting.
  • Experience with scheduling/orchestration tools like ADF, CA WLA, MuleSoft.
  • Strong communication across teams.

Responsibilities

  • Analyze legacy data structures and business rules across multiple systems.
  • Design and develop ETL/ELT pipelines using Informatica, ADF, SQL, or Databricks.
  • Support migration and conversion of data into target platform and Data Lake.
  • Perform source-to-target mapping, profiling, cleansing, transformation, validation, and reconciliation.
  • Design and maintain 3NF, dimensional and analytical data models.
  • Build automated data extracts and feeds for Finance, Distribution, Operations, and other consumers.
  • Develop operational/analytical reporting using Power BI, Tableau, SSRS, or Crystal Reports.
  • Create automated controls for validation of counts and totals.
  • Collaborate with analysts, engineers, architects, and ops to translate requirements.
  • Build scheduling, monitoring, and alerting for production pipelines.
  • Maintain data lineage, mappings, and reconciliation evidence.

Skills

Advanced SQL
Informatica
Azure Data Factory
Databricks
Data modeling
ETL development
Data migration
Business reporting
Analytical skills

Education

Bachelor's degree in Computer Science, Software Engineering, Data Engineering, or related field

Tools

Power BI
Tableau
SSRS
Crystal Reports
Git
CI/CD
MuleSoft

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 wit
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer
Senior Data Engineer

Bank of America Corporation • New Brunswick

On-site
CAD 90,000 - 130,000
OPEN: Data Migration Lead – Enterprise Transformation
OPEN: Data Migration Lead – Enterprise Transformation

Cpus Engineering Staffing Solutions Inc. • Toronto

Hybrid
CAD 120,000 - 150,000
Data Platform Developer
Data Platform Developer

Computationaldesign • Quebec

On-site
CAD 110,000 - 170,000
Senior Data Modeler
Senior Data Modeler

Compunnel Inc. • Mississauga

On-site
CAD 120,000 - 150,000
Senior Data Modeler/Analyst
Senior Data Modeler/Analyst

EPAM Systems • Canada

Hybrid
CAD 90,000 - 130,000
Senior Business System Analyst
Senior Business System Analyst

Confidential • Toronto

On-site
CAD 90,000 - 120,000
Data Migration/ Modernization Lead
Data Migration/ Modernization Lead

Accenture PLC • Toronto

Hybrid
CAD 109,000 - 220,000
Senior Data Modeler: Insurance & Azure Analytics
Senior Data Modeler: Insurance & Azure Analytics

Compunnel Inc. • Mississauga

On-site
CAD 120,000 - 150,000
Full Stack Data Engineer
Full Stack Data Engineer

Company 1 - The Manufacturers Life Insurance Company • Toronto

Hybrid
CAD 86,000 - 136,000
Health & dental
Pension plan
Hybrid work environment
Senior Data Engineer
Senior Data Engineer

Cpus Engineering Staffing Solutions Inc. • Pickering

Hybrid
CAD 90,000 - 120,000