Lead Data Engineer

We are a leading financial services provider committed to making decisions easier and lives better for our customers and colleagues around the world. From our environmental initiatives to our community investments, we lead with values throughout our business. To help us stand out, we help you step up, because when colleagues are healthy, respected and meaningfully challenged, we all thrive. Discover how you can grow your career, make impact and drive real change with our Winning Team today. 

Working Arrangement

Hybrid

Job Description

Senior data engineer will work as a technical leader of building out, from the foundation, the Insurance Affinity data mart, as part of a squad that builds Azure data pipelines. The role involves hands-on data engineering and the development of end-to-end data pipelines (processes supporting data ingestion, curation, visualization, and delivery using Microsoft Azure Data & Analytics PaaS Services). A vital skill to have will also be translation of business requirements to technical solutions, working with development teams, architects, and business analysts conformance to enterprise standards, architecture and technologies.

This job posting is for a remote position. We highly value candidates who are willing to attend quarterly planning sessions and team events at our KW or Toronto office.

Responsibilities 

• Lead the development of data integration solutions, including API integrations and data feeds.
• Use expertise in big data and cloud computing to ensure solutions are scalable, efficient, and effective.
• Design, develop, and implement data pipelines and ETL processes to extract, transform, and load data from various sources into Manulife’s data warehouse.
• Develop and maintain the company’s data architecture, including data models, schemas, and data dictionaries.
• Automate infrastructure provisioning and deployment using tools such as terraform
• Implement CI/CD pipelines that enables automated code deployment
• Mentor and coach data engineers on the team, providing technical guidance and leadership to build an impactful data engineering team.

How will you create impact? 

You will partner with business partners in understanding data and using the data to build data marts ensuring consistency to Manulife’s IT security and Risk guidelines.

What motivates you? 

• You obsess about customers, listen, engage and act for their benefit. 
• You think big, with curiosity to discover ways to use your agile approach and enable business outcomes. 
• You thrive in teams and enjoy getting things done together. 
• You take ownership and build solutions, focusing on what matters. 
• You do what is right, work with integrity and speak up. 
• You share your humanity, helping us build a diverse and inclusive work environment for everyone.

What we are looking for 

• 6 + years of previous data engineering experience, with 3+ years of experience building out table structures to host multiple different data entry points to serve multiple customer needs
• Strong knowledge of Azure Databricks, ADF, ADLS, Synapse etc.
• Hands-on experience on designing and developing scripts for ETL processes and automation in Azure data factory, Azure Databricks and PySpark using Python, Spark, and T-SQL
• Good understanding of data modeling and ability to apply different techniques within a cloud platform
• Knowledge of Azure networking – Subnets, private endpoints, firewalls etc.
• Knowledge of GIT/Jenkins – using pipelines for deployment
• Knowledge of implementing azure technologies and networking via terraform

What can we offer you? 

• A competitive salary and benefits packages. 
• A growth trajectory that extends upward and outward, encouraging you to follow your passions and learn new skills. 
• A focus on growing your career path with us. 
• Flexible work policies and strong work-life balance. 
• Professional development and leadership opportunities. 

Our commitment to you 

• Values-first culture 
  We lead with our Values every day and bring them to life together. 

• Boundless opportunity 
  We create opportunities to learn and grow at every stage of your career. 

• Continuous innovation 
  We invite you to help redefine the future of financial services. 

• Delivering the promise of Diversity, Equity and Inclusion 
  We foster an inclusive workplace where everyone thrives. 

• Championing Corporate Citizenship 
  We build a business that benefits all stakeholders and has a positive social and environmental impact. 

About Manulife and John Hancock

Manulife Financial Corporation is a leading international financial services group that helps people make their decisions easier and lives better. With our global headquarters in Toronto, Canada, we operate as Manulife across our offices in Asia, Canada, and Europe, and primarily as John Hancock in the United States. We provide financial advice, insurance, and wealth and asset management solutions for individuals, groups and institutions. At the end of 2022, we had more than 40,000 employees, over 116,000 agents, and thousands of distribution partners, serving over 34 million customers. At the end of 2022, we had $1.3 trillion (US$1.0 trillion) in assets under management and administration, including total invested assets of $0.4 trillion (US $0.3 trillion), and segregated funds net assets of $0.3 trillion (US$0.3 trillion). We trade as ‘MFC’ on the Toronto, New York, and the Philippine stock exchanges, and under ‘945’ in Hong Kong.

Manulife is an Equal Opportunity Employer

At Manulife/John Hancock, we embrace our diversity. We strive to attract, develop and retain a workforce that is as diverse as the customers we serve and to foster an inclusive work environment that embraces the strength of cultures and individuals. We are committed to fair recruitment, retention, advancement and compensation, and we administer all of our practices and programs without discrimination on the basis of race, ancestry, place of origin, colour, ethnic origin, citizenship, religion or religious beliefs, creed, sex (including pregnancy and pregnancy-related conditions), sexual orientation, genetic characteristics, veteran status, gender identity, gender expression, age, marital status, family status, disability, or any other ground protected by applicable law. 

It is our priority to remove barriers to provide equal access to employment. A Human Resources representative will work with applicants who request a reasonable accommodation during the application process. All information shared during the accommodation request process will be stored and used in a manner that is consistent with applicable laws and Manulife/John Hancock policies. To request a reasonable accommodation in the application process, contact [email protected].

Salary & Benefits

The annual base salary for this role is listed below.

Primary Location

CAN, Ontario, Toronto, 200 Bloor Street East

Salary range is expected to be between

$92,190.00 CAD – $171,210.00 CAD

If you are applying for this role outside of the primary location, please contact [email protected] for the salary range for your location. The actual salary will vary depending on local market conditions, geography and relevant job-related factors such as knowledge, skills, qualifications, experience, and education/training. Employees also have the opportunity to participate in incentive programs and earn incentive compensation tied to business and individual performance.

Manulife offers eligible employees a wide array of customizable benefits, including 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. We also offer eligible employees various retirement savings plans (including pension and a global share ownership plan with employer matching contributions) and financial education and counseling resources. Our generous paid time off program in Canada includes holidays, vacation, personal, and sick days, and we offer the full range of statutory leaves of absence. If you are applying for this role in the U.S., please contact [email protected] for more information about U.S.-specific paid time off provisions.