Senior Data Engineer

You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self.

You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do.

At Sun Life, we're driven by our

Purpose:

helping our Clients achieve lifetime financial security and live healthier lives. Our values shape how we work: caring, authentic, bold, inspiring, and impactful.

When you join Sun Life, you'll work with passionate colleagues and empowering leaders who support your growth and celebrate your contributions, so you can make a meaningful difference in our Clients' lives.

Discover how you can make a difference in the lives of individuals, families and communities around the world.

Job Description:

The Client Experience Office (CXO) is an important pillar of Sun Life Canada’s Data and Analytics growth and corporate strategy and as such, is seeking experienced data engineering individual with a proven track record working with data consumers to extract meaningful insights from enterprise data. This Senior Business data engineer will play an indispensable role in assembling the necessary data products that fuel myriads of analytical models used by our various business units across Canada.

Reporting to the Manager of Data Engineering, the Senior Business Data Engineer will be a key member of Data Enablement Team responsible for building enriched data products that provide deep insights about our Client, Advisor, Product, Transactions along with their intricate relationships. The Senior Business Data Engineer will work with data analysts and data scientists to help answer complex business enquires such as identifying new business opportunities, understanding our client behavior and optimizing areas of our sales cycles.

What will you do:

Design and engineer data models that represent our key business entities such as our Advisor, Client & Product Ensure high level of data quality and data integrity are maintained across data sources for business data assets

Convert complex business and technical rules into logic for data flows and data pipelines

Obsessed with understanding our enterprise data and interpreting it in the best way possible to derive business value

Work with our Data Science teams to implement data products for various use cases

Collaborate with stakeholders and incorporate into solution design for various use case requirements

Standardize metadata into a common glossary along with the necessary documentation for data consumers

This is a senior individual contributor role bridging the requirements of Business consumers and data engineering practitioners to support the overall Business Data Strategy.

This role will be partnering closely with CXO business stakeholders, enterprise governance and risk partners, and CXO data practitioners

What do you need to succeed?3-5 years hands-on experience working on major Cloud technologies and programming languages for data processing and analytics 3+ years experience with AWS and Snowflake platforms for building robust ETL pipelines, Catalog management, Data Quality and Governance implementation to keep data compliant and reliable.
3+ years experience and proficiency in Python, Pyspark and SQL Demonstrated Experience in cost and performance optimization of Spark and SQL jobs5 years hands-on experience with relational database systems, relational models, dimensional models, and analytical models3-5 years experience with engineering data products as…