Senior Data Engineer I

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. Discover how you can make a difference in the lives of individuals, families and communities around the world.

Job Description:

Come be part of an exciting and challenging opportunity by helping to accelerate the growth and application of data analytics capabilities at Sun Life Canada. As part of the Canada Finance Reporting Centre of Excellence, you will have the opportunity to be at the forefront of applying data and analytics to transform our financial reporting processes. You will be helping Sun Life use analytics to deliver on our purpose of helping our Clients achieve lifetime financial security and live healthier lives.

As a Data Engineer on the Canada Finance Reporting COE, your focus will be working with a team of financial professionals to build out a robust data environment to enable a suite of impactful business intelligence products and solutions to support financial operations within Canada. These products and services will allow Sun Life Canada’s Finance leaders to better analyze financial drivers and make data driven decisions.

Given the mandate of the role, the Data Engineer must be an experienced individual (1-3 years) who possesses a breadth of data management skills.

What will you do?

• Develop deep understanding of enterprise data, to enable end-to-end solutions

• Design and engineer data models with key financial business metrics (eg. Expenses, FTE, Sales)

• Maintain high level of data quality and integrity across data sources

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

• Collaborate with stakeholders and design data solutions for various use cases

• Standardize metadata into a common glossary with the necessary documentation

What do you need to succeed?

Code and tools

• 1-3 years hands-on experience working on AWS technologies for data processing and analytics

  • AWS Lambda, Glue, SQS, SNS, Cloudwatch

  • Python, Pyspark and SQL

• Experience in leveraging SQL and SQL-based programming to solve business problems

Data Modelling

• Experience with relational database systems, relational models, dimensional models etc.

• Sound understanding of data management principles (data warehousing, quality, master data management, etc.)

• Experience with engineering data products as input to various analytical models

• Ensure feedback loops between model deployment and its data – i.e. tune & tweak data products to achieve scale, optimization, etc.

Problem Solving

• Ability to translate complex business requirements into a set of data ingestion pseudocode

• Proven ability to leverage knowledge of data engineering to extract, conform and integrate a variety of operational data sources into production-grade data products

• Demonstrate blend of tenacity, creativity, and discipline required to develop ground breaking self-serve data models for consumption

Education and Qualifications:

• Undergraduate degree in Computer Science, Mathematics, Engineering, or equivalent

• Graduate degree in business or quantitative science strongly preferred

Unique Requirements

• As a condition of the role, the successful candidate must obtain a Government of Canada Reliability Status security clearance through Sun Life in advance of the start date.

What's in it for you?

• Time off giving you the flexibility to focus on the moments that matter including 20 vacation days per year

• Flexible Benefits from the day you join to meet the needs of you and your family

• Pension Plan participation starts immediately, and you are automatically enrolled. We help you save more with Sun Life automatic and matching contributions and by including both your salary and bonus when making

• contributions.

• The opportunity to move along a variety of career paths with amazing networking potential

• Flexible hybrid work model

• Work and professional development that is united by our Purpose: to help Clients and Employees achieve lifetime financial security and live healthier lives 

• A friendly, collaborative, and inclusive culture 

• We’re honoured to be recognized as a 2024 Best Workplace in Canada by Great Place to Work® Canada

• Sun Life ranked one of the 2024 Global 100 Most Sustainable Corporations in the World on the Corporate Knights’ 2024

The Base Pay range is for the primary location for which the job is posted.  It may vary depending on the work location of the successful candidate or other factors.  In addition to Base Pay, eligible Sun Life employees participate in various incentive plans, payment under which is discretionary and subject to individual and company performance.  Certain sales focused roles have sales incentive plans based on individual or group sales results. 

Diversity and inclusion have always been at the core of our values at Sun Life. A diverse workforce with wide perspectives and creative ideas benefits our clients, the communities where we operate and all of us as colleagues. We welcome applications from qualified individuals from all backgrounds.

Persons with disabilities who need accommodation in the application process or those needing job postings in an alternative format may e-mail a request to [email protected].

At Sun Life we strive to create a flexible work environment where our employees are empowered to do their best work. Several flexible work options are available and can be discussed throughout the selection process depending on the role requirements and individual needs.

We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.

Salary Range:

78,000/78 000 - 128,000/128 000

Job Category:

Advanced Analytics

Posting End Date:

31/01/2025