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