Data Engineer

Manulife • Waterloo, ON

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

About The Position

Looking for a data engineer to join the Canadian data office here at Manulife. The data engineer will enable the building, maintenance, enhancements, and support of new and existing Azure data pipelines for various analytical use cases inclusive of AI/ML/BI/GEN AI and reporting. Collaborate with team members to understand data, supporting our businesses while aligning with IT security.

Requirements

• 5+ years of previous data engineering experience, with 3+ years of experience working in enabling azure related data technologies.
• Solid understanding of Azure infrastructure; subscriptions, resource groups, resources, access control with RBAC (role-based access control), integrations with Azure AD and Azure security principles (user group, service principal, managed identity), network concepts (VNet, Subnet, NSG rules, private endpoints), password\credential\key management and data protection.
• Bachelor’s in computer/IT or data related fields required.

Nice To Haves

• Excellent knowledge of Data visualization: PowerBI
• Strong hands on knowledge of Azure Databricks (Unity Catalog), ADF, ADLS, Synapse Serverless/dedicated/spark pools, Python, PySpark, and T-SQL along with experience designing and developing scripts for ETL processes and automation in Azure data factory and Azure databricks.
• High proficiency in GIT/Jenkins/dev ops processes to maintain and resolve issues with data pipelines in prod.
• Knowledge of implementing azure technologies and networking via terraform along with ability to fix issues with Azure infra in prod.
• Good understanding of data modeling/data marts/Lake house architecture, SCD , data mesh and delta lake overall.
• Solid understanding of data privacy and compliance regulations and standard methodologies for preserving customer data.
• Knowledge of insurance and financial products is a plus.
• Master’s degree is a plus.

Responsibilities

• Gain deep understanding of data by collaborating with business and advanced analytics partners; demonstrate the understanding to design, curate and publish connected data sets that enables users to self-serve.
• Propose technology improvements or come up with innovative solutions to solve business problems.
• Collaborate with Architecture, security and risk teams and implement latest guidelines and Azure standard methodologies.
• Automate infrastructure provisioning and deployment using tools such as terraform.
• Implement CI/CD pipelines that enables automated code deployment
• Participate in Agile sprints and ceremonies; supports rapid iteration and development.
• Cultivate and maintain strong relationships and fosters collaboration with various teams and partners within the organization.

Benefits

• health, dental, mental health, vision, short- and long-term disability, life and AD&D insurance coverage, adoption/surrogacy and wellness benefits, and employee/family assistance plans.
• various retirement savings plans (including pension and a global share ownership plan with employer matching contributions) and financial education and counseling resources.
• holidays, vacation, personal, and sick days
• full range of statutory leaves of absence.

What This Job Offers

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