Full Stack Data Engineer

Manulife
Chicago, IL, United States
1 day ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
4 years minimum
Compensation
$86,100 - $136,100
Working hours
Regular working hours
Job source

Tech stack

Third Normal Form Application Programming Interfaces (APIs) Artificial Intelligence Data Analysis Audit Trail Big Data Cloud Database Continuous Integration Crystal Reports (Reporting Software) Data Cleansing Data Conversion Information Engineering
+46 more
Data Governance Extract Transform Load (ETL) Data Mapping Data Migration Data Profiling Data Structures Data Warehousing DevOps Dimensional Modeling File Transfer IBM Cognos Business Intelligence JSON Python (Programming Language) Operational Databases Power BI Standard Sql Reverse Engineering Software Engineering SQL Databases SQL Server Reporting Services Data Streaming Systems Integration Tableau (Software) Extensible Markup Language (XML) Enterprise Data Management File Transfer Protocol (FTP) Azure Data Factory Sql Optimization Apache Spark Generative AI Git Data Lakes Kubernetes Information Technology Data Lineage Deployment Automation Enterprise Integration Apache Kafka Data Management Api Gateway Restful APIs Azure Synapse Analytics Data Pipelines Legacy Systems Mulesoft Databricks

Job description

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.

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, 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.

Benefits & conditions

  • 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 the company

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 embraces the strength of cultures and individuals. We are committed to fair recruitment, retention, advancement and compensation, and we administer all of our practices and programs without discrimination on the basis of race, ancestry, place of origin, colour, ethnic origin, citizenship, religion or religious beliefs, creed, sex (including pregnancy and pregnancy-related conditions), sexual orientation, genetic characteristics, veteran status, gender identity, gender expression, age, marital status, family status, disability, or any other ground protected by applicable law.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Loading talks and stories from around this role…