Full Stack Data Engineer

Posted 2 days ago

Apply Now

Resume Score

Check how well your resume matches this job before you apply.

Sign in to check score

About the role

  • 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

Job title

Job type

Full Time

Experience level

Mid levelSenior

Salary

CA$86,100 - CA$136,100 per year

Degree requirement

Bachelor's Degree

Tech skills

AzureCloudCognosETLInformaticaKafkaPythonSparkSQLTableau

Location requirements

HybridTorontoCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.