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: • 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. 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 https://www.manulife.com/en/about/our-story.html . Manulife 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 embrac