Senior Support Engineer – Data & Analytics Operations to support mission-critical data platforms usi (Ontario)

Senior Support Engineer – Data & Analytics Operations to support mission-critical data platforms usi (Ontario)

21 Nov
|
S.I. Systems
|
Ontario

21 Nov

S.I. Systems

Ontario

Senior Support Engineer – Data & Analytics Operations to support mission-critical data platforms using SQL, ETL, and AWS - 1880
Location: Waterloo or Toronto - Hybrid (2 days onsite per week)

*Candidate must be eligible for Reliability Clearance (Must have lived in Canada for 5 consecutive years)

Our Data & Analytics Operations team is seeking a Senior Support Engineer to support mission-critical data platforms, operational processes, and application upgrades within Sun Life's analytics environment. This role combines hands‑on technical support, troubleshooting, data analysis, and operational project coordination.

This is not a traditional software development role. The successful candidate will leverage their development background to diagnose and resolve issues, support ETL and data ingestion processes, participate in platform upgrades, and help ensure operational stability across our data ecosystem.

The ideal candidate can quickly learn current environments, understand complex data flows, identify root causes of data discrepancies, and effectively coordinate operational initiatives through the full software development lifecycle.

Must Haves

4+ years of experience supporting enterprise data, analytics, or application environments

Strong SQL development and query optimization skills

Hands‑on ETL experience (Informatica Cloud or Informatica On‑Prem preferred)

Experience troubleshooting data pipelines, integrations, and data processing workflows

Strong understanding of relational databases and data warehousing concepts

Experience with Microsoft SQL Server

Experience working within cloud‑based environments.

Priority AWS Skills

AWS Glue

AWS Lambda

EMR

EC2

S3

Redshift

CloudWatch

SDLC & Project Experience

Experience participating in platform, application, database, or cloud upgrades

Strong understanding of Software Development Lifecycle (SDLC)

Ability to coordinate activities across development, testing, staging, and production environments

Experience planning and supporting deployments through production implementation

Demonstrated project coordination or operational project management experience

Nice to Have

Exposure to additional AWS services such as Bedrock, SageMaker, Amazon Q, and Athena is highly desirable.

Snowflake experience

Enterprise Data Lake environments

Distributed computing and large‑scale data processing

Amazon Q

DevOps tools including BitBucket, Jenkins, Ansible, and CI/CD pipelines

Experience with AI solutions or AI agent development

Financial services or insurance industry experience.

Responsibilities

Operational Support (Approximately 70-80%)





Monitor and support end‑to‑end data ingestion, ETL, and analytics processes

Investigate and resolve complex data discrepancies and production support issues

Analyze failed jobs, data quality issues, and platform performance concerns

Troubleshoot SQL, ETL, database, and cloud platform issues

Monitor production environments and implement operational improvements

Support data warehousing and enterprise data lake environments

Ensure compliance with Incident, Problem, and Change Management processes

Create and maintain technical and operational documentation

Operational Projects & Upgrades (Approximately 20-30%)

Participate in application, database, cloud, and platform upgrades

Coordinate operational project activities through the full SDLC lifecycle

Assist with planning, UAT, deployment preparation, release coordination, and production implementation

Work closely with support engineers, project teams, and technology partners to deliver operational enhancements

Support ongoing modernization initiatives including Snowflake and Iceberg adoption efforts

Duration: December 28, 2026 - June 18, 2027 (extension possible)

Location: Waterloo or Toronto - Hybrid (2 days onsite per week)

*Candidate must be eligible for Reliability Clearance (Must have lived in Canada for 5 consecutive years)

Our Data & Analytics Operations team is seeking a Senior Support Engineer to support mission‑critical data platforms, operational processes, and application upgrades within Sun Life's analytics environment. This role combines hands‑on technical support, troubleshooting, data analysis, and operational project coordination.

This is not a traditional software development role. The successful candidate will leverage their development background to diagnose and resolve issues, support ETL and data ingestion processes, participate in platform upgrades, and help ensure operational stability across our data ecosystem.

The ideal candidate can quickly learn new environments, understand complex data flows, identify root causes of data discrepancies, and effectively coordinate operational initiatives through the full software development lifecycle.

Must Haves

4+ years of experience supporting enterprise data, analytics, or application environments

Strong SQL development and query optimization skills





Hands‑on ETL experience (Informatica Cloud or Informatica On‑Prem preferred)

Experience troubleshooting data pipelines, integrations, and data processing workflows

Strong understanding of relational databases and data warehousing concepts

Experience with Microsoft SQL Server

Experience working within cloud‑based environments.

Priority AWS Skills

AWS Glue

AWS Lambda

EMR

EC2

S3

Redshift

CloudWatch

SDLC & Project Experience

Experience participating in platform, application, database, or cloud upgrades

Strong understanding of Software Development Lifecycle (SDLC)

Ability to coordinate activities across development, testing, staging, and production environments

Experience planning and supporting deployments through production implementation

Demonstrated project coordination or operational project management experience

Nice to Have

Exposure to additional AWS services such as Bedrock, SageMaker, Amazon Q, and Athena is highly desirable.

Snowflake experience

Apache Iceberg experience

Enterprise Data Lake environments

Distributed computing and large‑scale data processing

Python development

GitHub Copilot

Amazon Q

DevOps tools including BitBucket, Jenkins, Ansible, and CI/CD pipelines

Experience with AI solutions or AI agent development

Financial services or insurance industry experience.

Responsibilities

Operational Support (Approximately 70-80%)

Monitor and support end‑to‑end data ingestion, ETL, and analytics processes

Investigate and resolve complex data discrepancies and production support issues

Analyze failed jobs, data quality issues, and platform performance concerns

Troubleshoot SQL, ETL, database, and cloud platform issues

Monitor production environments and implement operational improvements

Support data warehousing and enterprise data lake environments

Ensure compliance with Incident, Problem, and Change Management processes

Create and maintain technical and operational documentation

Operational Projects & Upgrades (Approximately 20-30%)

Participate in application, database, cloud, and platform upgrades

Coordinate operational project activities through the full SDLC lifecycle

Assist with planning, UAT, deployment preparation, release coordination, and production implementation

Work closely with support engineers, project teams, and technology partners to deliver operational enhancements

Support ongoing modernization initiatives including Snowflake and Iceberg adoption efforts

Disclaimer:

AI may be used in evaluating candidates.

This posting is for an existing vacancy.
#J-18808-Ljbffr

📌 Senior Support Engineer – Data & Analytics Operations to support mission-critical data platforms usi (Ontario)
🏢 S.I. Systems
📍 Ontario

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: senior support engineer – data & analytics operations to support mission-critical data platforms usi (ontario) / ontario

Subscribe to this job alert:

Get the latest job offers by email for: senior support engineer – data & analytics operations to support mission-critical data platforms usi (ontario) / ontario