Full Stack Data Engineer

**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 themigration 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 professio