Senior Data Engineer

Sun Life; Southwestern Ontario; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading financial services company in Canada seeks an experienced Data Engineer to design and maintain complex data ecosystems that support digital campaigns and reporting. The ideal candidate will have 3-5 years of experience with AWS technologies, Python, and SQL, along with strong communication skills. This role offers competitive salary, flexible work options, and opportunities for career advancement.

Benefits

Flex hours and work from home options

Pension, stock and savings programs

Professional development opportunities

Friendly and inclusive culture

Competitive salary and bonus structure

Qualifications

• 3-5 years of hands-on experience working with AWS technologies for data processing and analytics.
• 3-5 years of experience with Git, Bitbucket, Jenkins, Terraform, S3, Lambda, Step Functions.
• 3-5 years of experience in Python, PySpark, and SQL.
• 5 years of experience with relational database systems.
• Sound understanding of data management principles.

Responsibilities

• Design and maintain a complex data repository for campaigns and reporting.
• Provide expert guidance on leveraging data for business insights.
• Manage business data requests aligned with priorities.
• Collaborate with an agile team to develop campaign solutions.
• Architect and maintain a sophisticated data ecosystem.

Skills

AWS technologies

Python

SQL

Data management principles

Communication skills

Education

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

Tools

Git

Jenkins

Terraform

S3

Lambda

Step Functions

Job description

Job Description

Reporting to the Manager of Data Engineering, the role requires an experienced data engineer with deep experience in data management and a solid understanding of the data needs of marketing, campaigns and business.

What will you do?

Design, develop, maintain and continuously improve a large and complex data repository that provides accurate and reliable data to support campaigns and reporting in support of digital channels.

Deepen the organizations understanding of client and member level data and provide expert guidance on how best to leverage data to provide actionable business insight.

Build data assets as required for best use of client data for automated digital marketing activity.

Manage and execute on business data requests ensuring requests are aligned to business priorities and the request fulfillment meets the business needs.

Collaborates in an agile team to understand business objectives and develop campaign solutions that deliver best in class, engaging and highly relevant experiences

Provide expert guidance on developing the structure and processes to build a Big Data repository (includes basic ETL type processes, QA etc.).

Become one of the organizations top data experts and CXO Analytics data steward ensuring data is appropriately interpreted and applied to business problems.

Develop a solid understanding the Sun Life Financial Canada’s business

Serve as a leading data expert and analytics steward, ensuring accurate data interpretation and application

Architect and maintain a sophisticated data ecosystem to support digital campaigns and reporting

What do you need to succeed?

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

3-5 years experience with Git, Bitbucket, Jenkins, Terraform, S3, Lambda, Step Functions

3-5 years experience in Python, PySpark and SQL

5 years hands-on experience with relational database systems, relational models, dimensional models etc.

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

Excellent communication skills (both written and oral), combined with strong interpersonal skills - have the ability to explain complexity of data to a business audience

Demonstrated experience in database querying and reporting and developing campaign lists for direct marketing campaigns

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

What's in it for you?

Flex hours and work from home options.

Pension, stock and savings programs to help build and enhance your future financial security

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

Be part of our continuous improvement journey in developing the next greatest digital enterprise experience.

Competitive salary and bonus structure influenced by market range data

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