Full Stack Data Engineer migrating legacy insurance licensing and compensation systems. Building ETL pipelines, data models, reconciliations, reporting, and downstream feeds for Manulife.
Responsibilities
Analyze data structures, relationships, transformations, and business rules across legacy systems and upstream/downstream platforms
Design and develop ETL/ELT pipelines using Informatica, Azure Data Factory, SQL, or Databricks
Support data migration and conversion into the target compensation platform and Data Lake
Perform source-to-target mapping, data profiling, cleansing, transformation, validation, and reconciliation
Design and maintain 3NF, dimensional, and analytical data models
Build automated data extracts, interfaces, and feeds for Finance, Distribution, Operations, Treasury, and other enterprise consumers
Develop operational, reconciliation, and analytical reporting using Power BI, Tableau, Cognos, SSRS, or Crystal Reports
Develop automated controls validating record counts, financial totals, balances, results, and source-to-target completeness
Partner with business analysts, engineers, architects, and Operations to translate legacy requirements into future-state solutions
Investigate complex data issues and support root-cause analysis and remediation
Build and maintain scheduling, monitoring, alerting, restart, and exception-handling capabilities for production pipelines
Maintain data lineage, mappings, transformation rules, technical specifications, and reconciliation evidence
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, or 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), Databricks, or comparable ETL/ELT platforms
Strong 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
Experience with source-to-target mapping, profiling, transformation, validation, and reconciliation
Experience building automated extracts and file-based integrations using CSV, TSV, XML, JSON, or similar formats
Experience delivering data through SFTP, Managed File Transfer (MFT), APIs, or enterprise integration frameworks
Experience implementing data-quality controls, financial reconciliation, exception handling, data governance, and auditability
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
Ability to reverse-engineer complex legacy data structures and transformation logic
Strong communication skills and ability to work across engineering, architecture, operations, and business teams
Preferred: experience with legacy-system modernization and complex data-conversion programs
Preferred: exposure to Azure Databricks, Synapse, Spark, Python, or other modern cloud/data platforms
Preferred: experience with Git, CI/CD pipelines, automated deployment, and DevOps practices
Preferred: familiarity with REST APIs, API gateways, Kafka, Azure Event Hubs, or event-driven integration patterns
Preferred: background in insurance, financial services, producer compensation, or distribution technology
Preferred: experience with AI, Business Intelligence (BI), and/or Generative AI solutions
Benefits
Flexible environment supporting learning, growth, well-being, and inclusion
Health insurance
Dental insurance
Mental health benefits
Vision insurance
Short- and long-term disability insurance
Life and AD&D insurance coverage
Adoption/surrogacy benefits
Wellness benefits
Employee/family assistance plans
Retirement savings plans
Pension
Global share ownership plan with employer matching contributions
Financial education and counseling resources
Paid holidays, vacation, personal, and sick days in Canada
Statutory leaves of absence
Reasonable accommodation during the application process
Senior Data Engineer building and migrating enterprise data platforms on Google Cloud. Designing BigQuery pipelines and architectures for consulting clients through production hand - off.
Senior Data Engineer building Azure Synapse big data pipelines for Quantiphi, an AI - first digital engineering company. Supporting healthcare cloud migrations, large - scale processing, and data platforms.
Senior Data Engineer building Azure, Databricks, and Snowflake pipelines for 73 Strings’ private - capital data platform. Owning ingestion, transformation, quality, CI/CD, and production delivery.
Senior Developer building C#, SQL, and cloud tooling to migrate legal, billing, and trust - accounting data. Supporting complex client migrations for a technology company serving financial services firms.
Data Migration Lead moving legal, billing, and trust accounting data into a legal technology platform. Leading analysts, conversion tooling, customer migrations, and compliance controls.
Senior Software Engineer building scalable AWS microservices and APIs for Morningstar's global investment data platform. Modernizing distributed systems and enabling reliable financial data delivery.
Data infrastructure engineer building searchable robotics datasets and quality pipelines at Mecka AI. Managing distributed robot fleet infrastructure, deployments, monitoring, governance, and cloud costs.
Senior Data Migration Engineer leading PACS, RIS, VNA, and cloud migrations for INFINITT’s healthcare IT business. Ensuring secure data integrity across clinical imaging environments.
Data Engineering Advisor building Azure data pipelines and analytics solutions for Desjardins. Designing ingestion, transformation, and data management systems for business needs.
Staff Software Engineer building Instacart’s advertising data platform for grocery delivery and household goods. Designing compliant, scalable systems for advertisers, data scientists, and sales teams.