Full Stack Data Engineer

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:

• Bachelors 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:

• Well empower you to learn and grow the career you want.
• Well recognize and support you in a flexible environment where well-being and inclusion are more than just words.
• As part of our global team well support you in shaping the future you want to see.

#LI-Hybrid

The role being advertised is an existing vacancy.

About Manulife and John Hancock

Manulife Financial Corporation is a leading international financial services provider helping people make their decisions easier and lives better. To learn more about us visit is an Equal Opportunity Employer

At Manulife/John Hancock we embrace our diversity. We strive to attract develop and retain a workforce that is as diverse as the customers we serve and to foster an inclusive work environment that embraces the strength of cultures and individuals. We are committed to fair recruitment retention advancement and compensation and we administer all of our practices and programs without discrimination on the basis of race ancestry place of origin colour ethnic origin citizenship religion or religious beliefs creed sex (including pregnancy and pregnancy-related conditions) sexual orientation genetic characteristics veteran status gender identity gender expression age marital status family status disability or any other ground protected by applicable law.

It is our priority to remove barriers to provide equal access to employment. A Human Resources representative will work with applicants who request a reasonable accommodation during the application process. All information shared during the accommodation request process will be stored and used in a manner that is consistent with applicable laws and Manulife/John Hancock policies. To request a reasonable accommodation in the application process contact .

Referenced Salary Location

Base salary range is expected to be between

Employees also have the opportunity to participate in incentive programs and earn incentive compensation tied to business and individual performance. The actual base salary will vary depending on local market conditions geography and relevant job-related factors such as knowledge skills qualifications experience and education/training. If you are applying for this role outside of the primary location please contact for the salary range for your location.

Manulife offers eligible employees a wide array of customizable benefits including health dental mental health vision short- and long-term disability life and AD&D insurance coverage adoption/surrogacy and wellness benefits and employee/family assistance plans. We also offer eligible employees various retirement savings plans (including pension and a global share ownership plan with employer matching contributions) and financial education and counseling resources. Our generous paid time off program in Canada includes holidays vacation personal and sick days and we offer the full range of statutory leaves of absence. If you are applying for this role in the U.S. please contact for more information about U.S.-specific paid time off provisions.

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.