ETL Solutions Designer / Architect (data engineer)

Sun Life; Southwestern Ontario; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A financial services company in Southwestern Ontario is seeking a Senior Data Engineer to design and maintain scalable data pipelines and mentor the team. Applicants should have a Bachelor's degree, strong SQL and Python skills, and experience with AWS services. This company is recognized for its positive workplace culture and offers a hybrid work model.

Benefits

Wellness programs

Career development opportunities

Recognition for workplace culture

Qualifications

• 5-10 years of experience in ETL design, modeling, and development.
• Strong proficiency in SQL and Python programming.
• Experience with AWS services, particularly Glue and other data-related services.

Responsibilities

• Design, develop, and maintain scalable data pipelines using AWS Glue and Kafka.
• Implement and optimize ETL processes using tools like SSIS and Informatica.
• Guide and mentor Data Engineers on best practices for ETL development.

Skills

SQL

Python

ETL design

AWS Glue

Kafka

Data warehousing

Hadoop

Tableau

Education

Bachelor’s degree in computer science or related field

Tools

AWS services

SSIS

Informatica

Talend

Job description

Job Description

We are currently looking for a Senior Data Engineer - Solutions Designer / Modeler 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.

What will you do

• 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

What you need to succeed

• 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
• 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)

Preferred skills

• Strong oral and written communication skills with experience in relating complex concepts to non-technical users, including presentation and storytelling with data
• Visual design expertise with a solid understanding of the best practices around dashboard and visual perception.

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
• Must be able to satisfactorily complete applicable background checks prior to the start date and during employment, in accordance with Sun Life’s policies and practices.

What’s in it for you

• We’re honoured to be recognized as a 2024 Best Workplaces in Ontario by Great Place to Work® Canada.
• We’re proud to be recognized as a company with a 2023 Most Trusted Executive team by Great Place to Work® Canada.
• Wellness programs that support the three pillars of your health – mental, physical, and financial
• The opportunity to move along a variety of career paths with amazing networking potential.
• As a hybrid organization, you and your leader use business and Client needs to choose where you work, at home or in the office