Support Engineer, Data & Analytics Operations

Sun Life Financial, Inc.

$65K — $105K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 5-7 years of experience in Mainframe development (TSO, ZEKE, JCL, COBOL) required.
  • Proficient in ETL tools such as Informatica and AWS Glue for data integration.
  • Strong SQL skills for writing complex queries, joins, and stored procedures.
  • Solid experience in Business Intelligence applications and report formatting, particularly with SAP tools.
  • Knowledge of ITIL for incident, problem, and change management processes.
  • Ability to troubleshoot and enhance code logic on a daily basis.
  • Possess an educational background in Computer Science, Data Science, Engineering, or related fields.

Responsibilities

  • Safeguard client data by providing robust operational support on-premises and in the cloud.
  • Design, build, and maintain centralized repositories for analytical data.
  • Write and execute complex SQL queries to analyze and manipulate data.
  • Create and maintain technical documentation to assist the team.
  • Continuously monitor environments to suggest and implement operational improvements.
  • Troubleshoot data consumption issues and resolve discrepancies or job failures.
  • Support project and operational teams through effective communication.

Benefits

  • Pension, stock, and savings programs for future financial security.
  • Opportunities for continuous learning and professional improvement.
  • Flexible hybrid work environment.
  • Participate in a competitive bonus structure based on performance.
Full Job Description

Job Description:

Sr Support Engineer, Data& Analytics Operations (Cloud/Data Warehouse)

Welcome to the Application Operation Services (AOS) at Sun Life, where our focus is to provide a positive digital user experience that is seamless, available, and valuable for our Canadian and global business partners and clients.

The Data &Analytics team provides support for:

  • On Premise applications, to maintain and support processes in multiple Data Warehouses, Business Intelligence, Data Integration applications
  • In the Cloud technologies, utilizing AWS for Enterprise Data Lake (EDL)
  • We are looking for a candidate that is deeply curious and possesses the keenness to learn, develop and execute with excellence

The Support Engineer on the Data & Analytics Operations team, is responsible for safeguarding our client’s data, by providing superior operational support both on premise and in the Cloud.

Essential skills

  • Mainframe development experience is required to support the transition from project implementation to operational support
  • Knowledge and experience with the tools to support several Data Warehouses (DW), from data ingestion to data consumption
  • Technical and analytical abilities required to design, build, and maintain centralized repositories for historical and analytical data
  • Ability to understand the code logic to analyze and troubleshoot data consumption issues for Sun Life clients as well as be able to fix or enhance code on a daily basis
  • Be able to write complex SQL queries, joins, and stored procedures to manipulate and analyze data.
  • Experience building and supporting ETL processes, data integration and pipelines
  • Good business intelligence application experience to design, analyze, and format reports for clients
  • Experience with Batch Operations including schedulers, failures and recovery
  • Excellent analytical skills to dive into the processes we support to resolve complex data discrepancies or job failures
  • ITIL knowledge for incident, problem and change management policies and processes
  • Create and maintain superb technical documentation that will help support our poly-skilled team
  • Excellent communication skills to support Project Teams, Operation teamsand vendors
  • Continuously monitor our environments to identify and implement operational improvement
  • Posses an owners mindset which is critical to the success of the team

Education

If you have a background or education in Computer or Data Science, Engineering, Software Development or IT Application/Technical support, this role may be for you.

Technical Experience required to succeed in this role:

2+ years experience developing in:

  • Mainframe: TSO, ZEKE, JCL, COBOL
  • ETL: Informatica, IDMC (Informatica Cloud), Master Data Management (MDM), AWS Glue
  • Business Intelligence (BI): SAP Tools (Crystal, Universe Design)
  • AI: GitHub Copilot

Additional Assets

  • AWS experience or certifications
  • DevOps tools

What is more exciting is that the candidate will get their hands on new Cloud technologies as we build a resilient support framework within our team.

This is what you could be getting hands on learning in the first year!

  • Amazon Web Services (AWS)
  • AWS Glue, Lambda, Redshift, and Python/R
  • DevOps: BitBucket, CICD Pipeline, Ansible, Jenkins
  • Generative AI
  • Agentic AI

Unique Requirements:

  • As a condition of the role, the successful candidate must obtain a Government of Canada Reliability Status security clearance through Sun Life.
  • This role requires 24x7 support on a rotational basis and is subject to Over Time.

Whats in it for you?

  • Competitive salary and bonus structure influenced by market range data
  • Pension, stock, and savings programs to help build and enhance your future financial security
  • An environment of continuous learning and improvement
  • Hybrid work.

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.

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! Several work options are available and can be discussed throughout the selection process depending on the role requirements and individual needs.

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:

65,000/65 000 - 105,000/105 000

Job Category:

IT - Technology Services

Posting End Date:

09/07/2026

Similar Jobs

More Jobs at Sun Life Financial, Inc.

More Information Technology Jobs

Find similar Support Engineer, Data & Analytics Operations jobs: