EngineerJobs.io
← Back to all jobs

Job Description

Manulife/John Hancock is hiring a Full-Stack Data Engineer (Modernization & Migration) to move legacy licensing and compensation capabilities into a vendor platform and a Data Lake.

Responsibilities

  • Analyze data structures, relationships, transformations, and business rules across legacy systems plus upstream and downstream platforms.
  • Design and build ETL/ELT pipelines to enable data conversion, integration, and delivery.
  • Use Informatica, Azure Data Factory (ADF), SQL, or Databricks/ Azure Databricks to support migration workloads.
  • Support migration and conversion of data into the target compensation platform and the Data Lake.
  • Execute source-to-target mapping, data profiling, cleansing, transformation, validation, and reconciliation across the migration lifecycle.
  • Design and maintain 3NF, dimensional, and analytical data models for 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.
  • Create automated controls to validate record counts, financial totals, balances, results, and source-to-target completeness.
  • Collaborate with business analysts, engineers, architects, and Operations to translate legacy data structures and processing needs into future-state solutions.
  • Investigate complex data issues across source systems, transformation layers, the vendor target platform, and downstream consumers, supporting root-cause analysis and remediation.
  • Implement scheduling, monitoring, alerting, restart, and exception-handling capabilities for production data pipelines.
  • Maintain data lineage, mappings, transformation rules, technical specifications, and reconciliation evidence for auditability and production readiness.
  • Contribute to migration planning, test-data preparation, conversion rehearsals, parallel validation, cutover, and post-production stabilization.

Requirements

  • Bachelor’s degree in Computer Science, Software Engineering, Data Engineering, or related field, or equivalent professional experience.
  • 4+ years of experience in data engineering, ETL development, data migration, and cloud data engineering.
  • Advanced SQL experience analyzing and transforming large, complex datasets.
  • Strong hands-on experience with Informatica, Azure Data Factory (ADF), Databricks/ Azure Databricks, or comparable ETL/ELT platforms.
  • Strong knowledge of data warehousing including 3NF, Medallion Architecture, dimensional modeling, and enterprise data model design.
  • Experience with large-scale data migration or system conversion, including source-to-target mapping, profiling, transformation, validation, and reconciliation.
  • Experience building automated extracts and file-based integrations using formats such as CSV, TSV, XML, JSON, or similar.
  • Experience delivering data via SFTP, Managed File Transfer (MFT), APIs, or enterprise integration frameworks.
  • Strong experience with data-quality controls, financial reconciliation, exception handling, and data governance/auditability.
  • Practical reporting experience using Power BI, Tableau, SSRS, Crystal Reports, or similar technologies.
  • Experience with scheduling and orchestration tools such as ADF, CA WLA, or MuleSoft.
  • Strong analytical and troubleshooting skills, including ability to reverse-engineer legacy data structures and transformation logic.
  • Strong communication skills working across engineering, architecture, operations, and business teams.

Technologies

  • SQL
  • Informatica
  • Azure Data Factory (ADF)
  • Databricks, Azure Databricks
  • Power BI, Tableau, Cognos, SSRS, Crystal Reports
  • 3NF, Medallion Architecture
  • SFTP, Managed File Transfer (MFT)
  • APIs, REST APIs
  • MuleSoft, CA WLA
  • CSV, TSV, XML, JSON
  • Kafka, Azure Event Hubs
  • Spark, Python, Synapse
  • Git, CI/CD pipelines, CI/CD

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.
  • Experience with AI, Business Intelligence (BI), and/or Generative AI solutions.

Benefits

  • Health insurance
  • Dental insurance
  • Mental health benefits
  • Vision insurance
  • Short- and long-term disability
  • Life and AD&D insurance coverage
  • Adoption/surrogacy and wellness benefits
  • Employee/family assistance plans
  • Retirement savings plans including pension and a global share ownership plan with employer matching contributions
  • Financial education and counseling resources
  • Paid time off program in Canada (holidays, vacation, personal, and sick days)
  • Statutory leaves of absence

Working Arrangement

  • Hybrid

Location

  • Chicago, IL

Compensation

  • USD 86,100 - 136,100 per year
  • Base salary range expected to be between $86,100.00 CAD - $136,100.00 CAD

Similar Jobs