Support Engineer, Data & Analytics Operations

Sun Life

Support Engineer in Data & Analytics Operations providing superior support for client data security and operations. Collaborating to maintain data warehouses and cloud environments while improving processes.

Posted 6/30/2026full-timeToronto • 🇨🇦 CanadaJuniorMid-Level💰 CA$65,000 - CA$105,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in SQL query writing, ETL process development, and business intelligence reporting, with a strong focus on data integrity and operational support in both on-premise and cloud environments. Proficient in technical documentation and communication to facilitate collaboration across project and operations teams.

Highest-signal resume keywords

SQL Query WritingETL Process DevelopmentBusiness Intelligence ReportingMainframe TechnologiesITIL Knowledge

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLETLData IntegrationData WarehousingCOBOLJCLInformaticaAWS GlueSAP ToolsMaster Data Management

Soft Skills

Analytical SkillsCommunication Skills

Tools & Technologies

Informatica CloudCrystal ReportsUniverse Design

Industry Keywords

Operational SupportData ConsumptionData DiscrepanciesIncident ManagementChange Management

Tech Stack

Tools & technologies

AWSCloudETLInformaticaSQL

About the role

Key responsibilities & impact

Provide superior operational support both on premise and in the Cloud
Safeguard our client’s data
Continuously monitor our environments to identify and implement operational improvement
Ability to understand the code logic to analyze and troubleshoot data consumption issues for Sun Life clients
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

Requirements

What you’ll need

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)
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
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 teams and vendors

Benefits

Comp & perks

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