Senior Data Engineer

Sun Life Assurance Company of Canada; Southwestern Ontario; Hybrid; CAD 85,000 - 128,000; Full time

Benefits offered by this job

Comprehensive benefits package

Flexible work arrangements

Professional growth and development

Job summary

Sun Life is seeking a Senior Data Engineer to design, build, and maintain data pipelines and infrastructure for data-driven decision-making. You will mentor a team of Data Engineers and collaborate with cross-functional partners to deliver scalable analytics solutions while ensuring data quality, security, and regulatory compliance.

The role emphasizes leading ETL development, governance, and leveraging AWS services to turn large, diverse data streams into actionable insights for Canadian

Qualifications

• Bachelor's degree in computer science, information technology, or related field.
• 5-10 years of experience in ETL design, modeling, and development.
• Strong proficiency in SQL and Python programming.
• Experience with AWS services, particularly Glue, Step Functions, and other data-related services.
• Expertise in data warehousing concepts and methodologies.
• Proficiency in ETL tools (e.g., Informatica, Talend, SSIS).
• Experience with various database systems and data formats.
• Familiarity with Kafka and stream processing concepts.
• Excellent problem-solving and analytical skills.
• Strong communication and leadership abilities.

Responsibilities

• Design, implement, and maintain scalable data pipelines and infrastructure to support data-driven decision-making.
• Mentor and guide Data Engineers on best practices for ETL development and data sourcing.
• Create and maintain data models to support BI and analytics initiatives.
• Collaborate with cross-functional teams to understand data requirements and deliver solutions.
• Ensure data quality, security, and compliance with industry standards and regulations.
• Troubleshoot data-related issues and implement robust solutions.
• Stay current with emerging technologies and best practices in data engineering.

Skills

SQL

Python

ETL design

Data warehousing

Leadership

Communication

Education

Bachelor's degree in Computer Science or related

Tools

AWS Glue

AWS Step Functions

SSIS

Informatica

Talend

Kafka

Tableau

Power BI

Hadoop

Spark

Hive

Job description

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

Senior Data Engineer We are currently looking for a Senior Data Engineer - with a passion for turning disparate streams of data into organized and actionable analytics services and insights. As a Data Engineer on the Data Engineering and Operations team, you will be joining a group of hardworking and savvy innovators who has made it their mission to find new ways to glean value out of rapidly increasing volumes of operational data in Canadian Operations.

Role Summary

Working within a diverse and motivated team of analytics professionals, the Senior Data Engineer will be instrumental in designing, implementing, and maintaining data pipelines and infrastructure to support our organization's data-driven decision-making processes, while also guiding and mentoring other Data Engineers.

Main Accountabilities

• Design, develop, and maintain scalable data pipelines using AWS Glue, Kafka, and Step Functions.
• Implement and optimize ETL processes using tools like SSIS, Informatica, or Talend.
• Guide and mentor Data Engineers on best practices for ETL development and data sourcing.
• Create and maintain data models to support business intelligence and analytics initiatives.
• Collaborate with cross-functional teams to understand data requirements and deliver solutions.
• Ensure data quality, security, and compliance with industry standards and regulations.
• Troubleshoot data-related issues and implement solutions.
• Stay current with emerging technologies and best practices in data engineering.

Competencies

• Bachelor’s degree in computer science, Information Technology, or related field.
• 5-10 years of experience in ETL design, modeling, and development.
• Strong proficiency in SQL and Python programming.
• Experience with AWS services, particularly Glue, Step Functions, and other data-related services.
• Expertise in data warehousing concepts and methodologies.
• Proficiency in ETL tools (e.g., Informatica, Talend, SSIS).
• Experience with various database systems and data formats.
• Familiarity with Kafka and stream processing concepts.
• Excellent problem-solving and analytical skills.
• Strong communication and leadership abilities.

Advantages

• Experience with big data technologies such as Hadoop, Spark, or Hive.
• Knowledge of data visualization tools (e.g., Tableau, Power BI).
• Familiarity with agile development methodologies.
• AWS certifications (e.g., AWS Certified Data Analytics - Specialty).

What We Offer

• Comprehensive benefits package and participation in various incentive plans.
• Opportunities for professional growth and development.
• Flexible work arrangements and work-life balance.
• Chance to work on impactful projects that drive business success.

We are proud to be recognized as:- 2022, 2023, and 2024 Best Workplaces in Canada by Great Place to Work® Canada.

Best Workplaces for Hybrid Work 2022.

Best Workplaces for Professional Development in Canada 2022.

"Best Places to Work" by Glassdoor, 2021 and 2023.

Unique Requirements

This role requires Reliability Status Clearance. In addition to a law enforcement inquiry and a credit check, as part of your application, the Government of Canada will ask if you lived or travelled outside of Canada for 6-consecutive months during the last 5 years, and you must account for all activities during this time. Important: Obtaining Reliability Status Clearance within a reasonable amount of time is a condition required to start employment for this role at Sun Life. Also, As this position is posted in several locations, we specify that bilingualism (French, English, both oral and written) is required for Quebec only for the frequent interactions with English and French-speaking colleagues or internal partners across Canada or worldwide.

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 [e-mail].

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. We may use artificial intelligence to support candidate sourcing, screening, interview scheduling.

We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted. Salary Range: 85,000/85 000 - 128,000/128 000 Job Category: Advanced Analytics Posting End Date: 13/11/2026

Shine together At Sun Life, you can be your most brilliant self. Our supportive, flexible, and inclusive work environment is one where you - and your career - can thrive. Whatever your aspirations, collaborative leaders and colleagues are ready to help you learn, grow, and succeed. Make life brighter We're a global company with a passion for people. Our purpose is to help Clients achieve lifetime financial security and live healthier lives. As a team of 30,000 across 26 countries, our impact is far-reaching, and locally relevant There's power in numbers. As part of Sun Life's growing team, you have an impact on people in your community and around the world. Shape the future With an optimistic eye on a brighter future, we drive to innovate. Be part of leading change, push boundaries and try new ways of working. Use data to drive bold actions. Be agile and pivot as we test and learn. At Sun Life, we're driving transformation, sustainability and innovation for our Clients, employees, partners, and communities. Join us. Together, we can make the future brighter. Join a top employer for a brighter future. Visit Sun Life Careers