DeveloperJobs.io
← Back to all jobs

Job Description

Manulife is seeking a Full-Stack Data Engineer (Modernization & Migration) to support the migration of legacy licensing and compensation capabilities into a vendor platform and a data lake. This role centers on analyzing and transforming legacy data, building ETL/ELT pipelines, and enabling reconciliation, reporting, and downstream data delivery across enterprise teams.

What you’ll do

  • Analyze data structures, relationships, transformations, and business rules across multiple legacy systems and connected upstream and downstream platforms.
  • Design and build ETL/ELT pipelines using tools such as Informatica, Azure Data Factory (ADF), SQL, or Databricks to support data conversion, integration, and downstream delivery.
  • Support migration and conversion of data into the target compensation platform and the data lake.
  • Own source-to-target mapping and perform data profiling, cleansing, transformation, validation, and reconciliation throughout the migration lifecycle.
  • Design and maintain 3NF, dimensional, and analytical data models that support 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 including Power BI, Tableau, Cognos, SSRS, or Crystal Reports.
  • Create 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 to support root-cause analysis and remediation.
  • Build and maintain scheduling, monitoring, alerting, restart, and exception-handling capabilities for production data pipelines.
  • Maintain 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.

Requirements

  • 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 analyzing and transforming large and complex datasets.
  • Hands-on experience with Informatica, Azure Data Factory (ADF), Databricks (or Azure Databricks) or comparable ETL/ELT platforms.
  • Working knowledge of data warehousing, 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 (CSV, TSV, XML, JSON, or similar formats).
  • Experience delivering data via SFTP, Managed File Transfer (MFT), APIs, or enterprise integration frameworks.
  • Experience implementing data-quality controls, financial reconciliation, exception handling, and data governance/auditability.
  • Practical experience developing operational or analytical reporting with Power BI, Tableau, SSRS, Crystal Reports, or similar tools.
  • Experience with scheduling and orchestration technologies such as ADF, CA WLA, or MuleSoft.
  • Strong analytical and troubleshooting skills, including reverse-engineering complex legacy data structures and transformation logic.
  • Strong communication skills 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, MuleSoft, CA WLA
  • CSV, TSV, XML, JSON, REST APIs
  • Kafka, Azure Event Hubs, Spark, Python, Synapse
  • Git, CI/CD pipelines

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

Compensation and location

  • Location: Chicago, IL (hybrid)
  • Salary: USD 86,100 - 136,100 per year
  • Base salary range is expected to be between: $86,100.00 CAD - $136,100.00 CAD
  • Referenced salary location: Toronto, Ontario

Benefits

  • Health insurance, dental insurance, vision insurance
  • Mental health benefits
  • 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