Full Stack Data Engineer, Analytics, ETL, Reporting

Posted 2 months 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 responsible for transforming data into actionable insights and structured reports. Join Manulife’s team to enhance analytics and reporting with hybrid work arrangement.

Responsibilities

  • Build automated data extracts and feeds from curated Gold Layer models
  • Develop formatted operational and regulatory reports (Power BI, Tableau, SAC, SSRS, Crystal Reports)
  • Design and maintain ETL/ELT pipelines using ADF, Informatica or similar tools
  • Create reliable outbound data delivery via SFTP, APIs, or managed file transfer platforms
  • Implement data validation, reconciliation checks, and robust quality controls
  • Maintain clear lineage from Gold Layer to downstream outputs with audit readiness
  • Optimize extraction logic for performance and scalability
  • Build and manage scheduling, monitoring, and alerting for production pipelines
  • Work closely with Finance, Actuarial, Operations, and business partners to gather and translate reporting needs
  • Document feeds, mappings, data definitions, and technical specifications

Requirements

  • Bachelor’s degree in computer science, Software Engineering, or a related field (or equivalent experience)
  • 4+ years’ experience in data engineering, BI engineering, or analytics engineering
  • Advanced SQL skills and strong understanding of 3NF and analytic modeling
  • Hands‑on experience with ETL/ELT platforms (Informatica, ADF or similar)
  • Practical experience building formatted reports (Power BI/Tableau/SAC/SSRS/Crystal Reports)
  • Ability to generate and automate file‑based outputs (CSV, TSV, XML, JSON etc.)
  • Experience delivering feeds via SFTP, MFT, or API frameworks
  • Strong data quality, validation, and reconciliation skills
  • Good understanding of data warehousing and data model design
  • Familiarity with scheduling/orchestration tools (ADF, Airflow, Control‑M, Autosys)

Benefits

  • Health insurance
  • Dental benefits
  • Vision benefits
  • Short- and long-term disability insurance
  • Life and AD&D insurance coverage
  • Adoption/surrogacy and wellness benefits
  • Employee/family assistance plans
  • Retirement savings plans
  • Generous paid time off program including holidays, vacation, personal, and sick days

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

AirflowETLInformaticaSQLTableau

Location requirements

HybridTorontoCanada

Report this job

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