City : Toronto

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:

Reporting to the Director, Data Engineering and Operations, Data Operations Manager is accountable for the managing modern data engineering and database operations practices to develop, deploy, and maintain a broad range of timely and reliable data services for a growing number of analytics consumers within Canadian Operations.

What will you do?

Operations

• Day-to-day management and operations of ETL processes and other scheduled data services

• Governance & Administration of users group for analytics consumers in Canadian Operations

• Support design and development of logical and physical data models for analytics applications

• Provides guidance to team members who build end-to-end data processes. This can include: locating source data, creating database schema/tables and files for storing data

• Coordinates production deployment tasks including code promotion and documentation across the data engineering team and other teams

• Oversees and coordinate trouble shooting production processes when errors or failures occur

• Oversees development, documentation, and maintenance of best practices for data operations within Business Analytics

• Develops and maintains roadmap for continuous improvement of data engineering within Canadian Operations.

Leadership

• Mentors team on best practices related to operational support, continuous improvement, and testing

• Provides guidance and development of subject matter expertise in the design, delivery, and maintenance of complex data services for analytics.

• Serves as subject matter expert in meetings with senior management, supporting questions on data engineering for analytics

• Establishes and maintains strong relationships with project leaders and members of technical competency centres in Enterprise Services. Actively participates in internal collaboration groups and industry forums for data analytics

What do you need to succeed?

Education and Qualifications

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

• Graduate degree in business or quantitative science strongly preferred.

• 3-5 years hands-on experience with relational database platforms (i.e. SQL Server, Oracle)

• 3-5 years experience with ETL and/or BI tools (i.e. SSIS, Informatica, Tableau, PowerBI)

• 2-3 years experience with dimensional data modeling (Star Schema, Snowflake Schema)

• 1-2 years managing database servers and governance practice

Competencies

• Solid familiarity with advanced scheduling tools required to automate data processes and program complex data routines.

• Ability to navigate in a complex matrix organization.

• Strong relationship management skills and ability to foster relationships.

• Excellent communication, change management and presentation skills.

• Strong facilitation, negotiation, and issue resolution skills

• Understanding of operational management practices and objectives including accountabilities approaches to problem solving, and best practice.

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 (https://www.tpsgc-pwgsc.gc.ca/esc-src/personnel/pdcf-rsrp-eng.html)

What will be nice to have?

• Insurance and/or financial services experience

• Prior experience in formal IT environment and / or with ITIL service management

• Prior experience in Big Data technologies such as AWS

• Prior experience with Tableau or other BI tools and technologies

What’s in it for you?

• Competitive salary influenced by market range data

• 20 days vacation per year

• Remote work/ Hybrid Work environment

• A friendly, collaborative and inclusive culture

• Flexible Benefits from the day you join to meet the needs of you and your family

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

• Being part of our Analytics community, where we share best practices and broaden skill-sets

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.

Sun Life is committed to the health and safety of all those in our workplaces and our communities.  In accordance with Sun Life’s Vaccination Policy (Canada):

• Employees permitted to work remotely are required to be fully vaccinated against COVID-19 in order to attend a Sun Life office, Financial Centre or offsite location where activity related to Sun Life business occurs.

• Employees whose job duties require them to attend a Sun Life office, Financial Centre or offsite location for Sun Life business must be fully vaccinated against COVID-19 effective May 1st. Employees in these roles may participate in Sun Life’s Rapid Screening Program as an alternative until April 30th.

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: