Full Stack Data Engineer
Manulife John Hancock
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
Reference: WJ-5769_96969 · Posted 16 Nov 2026, 11:27 AM