Full Stack Data Engineer (Analytics + ETL + Reporting)

Manulife • Waterloo, ON

3d • CA$86,100 - CA$136,100 • Hybrid

About The Position

Manulife / John Hancock is seeking a highly skilled Full‑Stack Data Engineer (Analytics + ETL + Reporting) with expertise in turning curated data into actionable insights, automated feeds, and enterprise‑grade reports with hands-on experience on Informatica/ADF, data warehousing and data model design to join our Insurance Licensing & Compensation engineering team. The successful candidate will design, develop, enhance, and turning curated data into actionable insights, automated feeds, and enterprise‑grade reports. As a Full‑Stack Data Engineer – Reporting, Extracts & Feeds, you will work downstream of our established Gold Layer, transforming business‑ready data into reports, extracts, and secure feeds consumed across Finance, Distribution, Operations, and other enterprise functions.

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).
• Strong communication skills and ability to work cross‑functionally with business teams.

Nice To Haves

• Exposure to cloud platforms (Azure preferred).
• Experience with Git, CI/CD pipelines, and DevOps practices.
• Familiarity with API gateways, REST APIs, and event‑driven patterns (Kafka/Event Hub).
• Understanding of metadata management and data governance frameworks.
• Background in insurance, or financial systems would be an asset.

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.

Benefits

• health, dental, mental health, vision, short- and long-term disability, life and AD&D insurance coverage
• adoption/surrogacy and wellness benefits
• employee/family assistance plans
• various retirement savings plans (including pension and a global share ownership plan with employer matching contributions)
• financial education and counseling resources
• generous paid time off program in Canada includes holidays, vacation, personal, and sick days
• full range of statutory leaves of absence
• opportunity to participate in incentive programs and earn incentive compensation tied to business and individual performance

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level