DataJobs.io
← Back to all jobs

Job Description

Manulife/John Hancock is seeking a Full-Stack Data Engineer (Modernization & Migration) to help migrate legacy licensing and compensation capabilities into a vendor platform and a centralized data lake. The role combines data analysis, ETL/ELT development, migration validation, and operational reporting to support finance, distribution, and other enterprise consumers.

Key Responsibilities

  • Analyze data structures, relationships, transformations, and business rules across multiple legacy systems, including upstream and downstream platforms.
  • Design and develop ETL/ELT pipelines using Informatica, Azure Data Factory (ADF), SQL, or Databricks to enable data conversion, integration, and downstream delivery.
  • Support 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 for business processing, reporting, reconciliation, and downstream consumption.
  • Build automated data extracts, interfaces, and feeds for Finance, Distribution, Operations, Treasury, and other enterprise stakeholders.
  • 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 needs into future-state solutions.
  • Investigate complex data issues across source systems, transformation layers, the target vendor platform, and downstream consumers, supporting 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, and cloud data engineering.
  • Advanced SQL skills, including experience analyzing and transforming large and complex datasets.
  • Strong hands-on experience with Informatica, Azure Data Factory (ADF), Databricks, or comparable ETL/ELT platforms.
  • Strong knowledge of data warehousing concepts including 3NF, Medallion Architecture, dimensional modeling, and enterprise data-model design.
  • 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 using formats such as CSV, TSV, XML, JSON, or similar.
  • 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, including the ability to reverse-engineer complex legacy data structures and transformation logic.
  • Strong communication skills and experience collaborating 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 and 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.
  • Strong communication, analytical, and problem-solving skills.
  • Experience with AI, Business Intelligence (BI), and/or Generative AI solutions.

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, MuleSoft, CA WLA, CSV, TSV, XML, JSON, REST APIs, Kafka, Azure Event Hubs, Spark, Python, Synapse, Git, CI/CD pipelines.

Location and Working Arrangement

  • Location: Chicago, IL (hybrid)
  • Working arrangement: Hybrid
  • Referenced salary location: Toronto, Ontario

Compensation

  • Salary range: USD 86,100 - 136,100 per year
  • Base salary range (expected, referenced): $86,100.00 CAD - $136,100.00 CAD

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

Similar Jobs