Data Engineer

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:

This is an opportunity to join a growing Operational Business Intelligence team; a group of exceedingly savvy and intellectually curious professionals who are transforming business intelligence at Sun Life Financial (SLF) Canada.  We are currently looking for a Data Engineer who has a passion for turning data into actionable insight to drive business decisions. This position works primarily with our Data and Analytics team to understand and analyze source systems and their associated data, develop data pipelines and manage the flow of data between systems.

What will you do?

As a data engineer,

• You will be involved in Design, development and implementation of highly scalable data capture and transformation processes.
• You will create effective ETLs/ELTs to move large volumes of data from various operational systems to dimensional data models for analytics consumption.
• You will be expected to ensure all automated processes preserve data integrity by managing the alignment of data availability and integration processes.
• You will be working with a team of talented data engineers and contribute to our data products.
• You will work in an agile environment and will actively participate in all the sprint related activities including the demo models.

What do you need to succeed?

• 1 to 3 years of building data pipelines using an ETL tool like SSIS.
• 1 to 3 years of Hands-on experience with Relational databases (SQL Server, PostgreSQL, etc.)  
• Proficient in SQL (Structured Query Language).
• Good understanding of Enterprise Scheduler (AutoSys, etc.).
• Knowledge of troubleshooting issues and optimize server performance.
• Knowledge of Agile, Design Thinking methodologies and techniques.
• Strong Communication Skills.
• Knowledge of Insurance or Financial Services industry.

Unique Requirements 

The candidate selected for this role is required to have special clearance from the Royal Canadian Mounted Police. To see if you are eligible for this clearance, please review the section 201 on the Federal Government site (http://iss-ssi.pwgsc-tpsgc.gc.ca/msi-ism/ch2-prt1-eng.html) ​ 

 Must be able to attain Canadian Reliability Security Clearance (administered by submitting fingerprints to the RCMP, who then conduct min. 5 year history checks) 

What’s in it for you?

• Flexible Benefits from the day you join to meet the needs of you and your family
• Pension, stock, and savings programs to help build and enhance your future financial security
• Being part of our analytics community, where we share best practices and broaden skill sets
• We’re proud to be a Best Workplace for Hybrid Work by Great Place to Work® Canada

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:

56,000/56 000 – 91,000/91 000

Job Category:

Advanced Analytics

Posting End Date:

21/04/2024