Full Stack Data Engineer
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