City : Kitchener

Category : Full-time

Industry : Finance

Employer : Sun Life Financial

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:

Role Summary

Leveraging DE principles and values, the Finance Accelerator’s purpose is to modernize Finance through process redesign and automation, establishing best practices, developing common tool platforms on an enterprise scale, and applying data and analytics to inform, influence and tackle business problems.

As a Senior Data Engineer, you will be responsible to assemble various streams of data and turning it into organized data products that fuel into analytical tools. Working with a diverse team of product owners, delivery teams and business partners professionals, the Senior Data Engineer will lead the entire lifecycle of data – from ETL to mining insights from the data, to making data accessible to build analytics services and self-service solutions to our stakeholders

Given this mandate, this role requires an experienced data engineer (5+ years) with deep experience in building data ETL process, governing data products, and a solid understanding of data needs of data analysts. The candidate must have experience in:

Data Management – Design, development, integration

Data Discovery – scoping new data sources, understanding and leveraging data sources

Data Governance – Manage data catalogue, interpret metadata

Communication and liaison between business, data analysts and IT

This role will report to the Director, Data Analytics & Insights

What will you do?

• Design, development and implementation of end-to-end complex ETL solutions from data modelling phase to automated workflows system using Informatica Powercenter

• Convert complex business and technical rules into logic for data flows that are implemented in ETL processes

• Ensure automated processes and internal data repository preserves data integrity and high data quality by managing alignment of source data platform.

• Implement and maintain clear data governance, data structures, naming conventions and other guiding principles to increase consistency in data across Business Groups

• Work with team members to create useful reports and dashboards that provide insight, improve/automate processes, or otherwise add value to the team.

• Implement technical solutions that are scalable, aligned with the enterprise architecture and can adapt to changes in business

• Develop and manage effective working relationships with other departments, groups or personnel with whom work must be coordinated.

What do you need to succeed?

• 5+  Years of hands-on experience in ETL using tools such as Informatica PowerCenter, and Power Designer for Data modelling

• Minimum of 1 year of experience with Data visualization tool, developing and designing dashboards, preferably Tableau

• 4+ years experience or deep knowledge of SQL Server that includes a thorough understanding of SQL internals, system tables, stored procedures, functions, triggers, and SQL tuning

• BSc/M.S. in a statistical, mathematical, or technical field (ie Engineering, computer science) or equivalent experience

• Proven ability to lead and drive projects and assignments to completion

• Experience embedding continuous improvement processes within the team to augment the speed and quality of analysis delivery

• Ability to work in a global multi-site environment and working in a matrix environment, onshore/offshore IT mode

• Strong communication skills and attention to detail and accuracy

Unique Requirements

• The candidate selected for this role is required to attain Canadian Reliability Security Clearance (administered by submitting fingerprints to the RCMP, who then conduct min. 5 year history checks)

• To see if you are eligible for this clearance, please review the section 201 on the Federal Government site (https://www.tpsgc-pwgsc.gc.ca/esc-src/personnel/pdcf-rsrp-eng.html)

What will be nice to have?

• Experience with production implementation change management processes

• Experience with project management and software development life cycle/SDLC; Agile and Lean  

• Excellent documentation skills including technical writing, Visio, PowerPoint, flowcharting

• Experience/Knowledge in Service Request tool such JIRA & Service Now

What's In It For You?

• Competitive salary and bonus structure influenced by market range data

• 20 days vacation per year and an innovative sabbatical program

• Great Place to Work® Certified in Canada and the US - 2022

• Great Place to Work® award for Best Workplaces for #HybridWork - 2022

• Flex hours and Flexible hybrid work model including in-country work-from-home if you prefer.  #LI-Hybrid   #LI-Remote

• A friendly, collaborative and inclusive culture

• 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

• Fitness and wellness programs that help you balance work and life and enjoy a healthier lifestyle

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.

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:

Job Category:

Posting End Date: