Sun Life

Senior Data Engineer

Waterloo, Ontario Full time

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:

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.

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 (e.g., 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.
  • Contribute to the design and automation of scalable cloud infrastructure using AWS-native tools and modern DevOps practices.
  • Work in Agile squads alongside data scientists, analysts, and finance professionals to deliver iterative improvements to data products.

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 groundbreaking 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.

What's in it for you?

  • Sun Life supports continuous learning through certifications, mentorship, and access to enterprise-wide data initiatives.
  • This role offers a hybrid work environment with flexibility to collaborate both remotely and in-office.

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 thebrightside@sunlife.com.

We are proud to be a hybrid organization that offers our employees the choice and flexibility to work from both the office and virtually based on the needs of the business, our Clients and you! Several 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:

80,000/80 000 - 128,000/128 000

Job Category:

Advanced Analytics

Posting End Date:

04/12/2025