Senior Support Engineer – Data & Analytics Operations to support mission-critical data platforms using SQL, ETL, and AWS - 1880

S I Systems

Toronto

Híbrido

CAD 110 000 - 140 000

Tempo integral

Há 3 dias
Torna-te num dos primeiros candidatos

Uma candidatura completa num minuto

Currículo e carta de apresentação personalizados, prontos a enviar.

Ultrapassa os filtros ATS

Resumo da oferta

Sun Life is seeking a Senior Support Engineer for Data & Analytics Operations. You will support mission-critical data platforms, optimize SQL queries, manage ETL pipelines, and coordinate upgrades across development, testing, staging, and production environments.

This role emphasizes hands-on troubleshooting, data analysis, and operational project management. The position requires hybrid work in Waterloo or Toronto, with eligibility for Reliability Clearance and a track record in cloud-based

Qualificações

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

Responsabilidades

  • Monitor end-to-end data ingestion, ETL, and analytics processes.
  • Investigate and resolve complex data discrepancies and production 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.
  • Participate in platform, application, database, or cloud upgrades.
  • Coordinate operational project activities through the full SDLC lifecycle.

Conhecimentos

SQL development
ETL experience
AWS skills
SDLC & project
Data warehousing
Microsoft SQL Server
Cloud-based environments
Data analysis

Ferramentas

Informatica Cloud
Informatica On-Prem

Descrição da oferta de emprego

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 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
  • 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.
Obtém a tua avaliação gratuita e confidencial do currículo.

ou arrasta e larga o ficheiro aqui.

Similar jobs

Ofertas semelhantes que vale a pena comparar

Senior Support Engineer - Data & Analytics Operations
Senior Support Engineer - Data & Analytics Operations

Bevertec • Toronto

Híbrido
CAD 90 000 - 120 000
Senior Software Engineer, Operations
Senior Software Engineer, Operations

Sunlife • Southwestern Ontario

Híbrido
CAD 100 000 - 143 000
Senior Data Engineer
Senior Data Engineer

Sun Life • Toronto

Híbrido
CAD 85 000 - 128 000
Hybrid work model
Wellness programs
Career progression opportunities
Senior Software Engineer, Operations
Senior Software Engineer, Operations

Sunlife • Toronto

Híbrido
CAD 100 000 - 143 000
Hybrid work model
Wellness programs
Career growth opportunities
+1
Senior Full Stack Developer with Java/JavaScript/TypeScript and Reusable UI Component Development - 0185
Senior Full Stack Developer with Java/JavaScript/TypeScript and Reusable UI Component Development - 0185

S I Systems • Winnipeg

Híbrido
CAD 110 000 - 150 000
Senior Data Engineer
Senior Data Engineer

Sunlife • Toronto

Híbrido
CAD 100 000 - 143 000
Best Workplace award (Canada)
Mental health certification (Canada)
Wellness programs
+2
Senior Data Engineer
Senior Data Engineer

Sunlife • Southwestern Ontario

Híbrido
CAD 100 000 - 143 000
Hybrid work model
Wellness programs
Career progression opportunities
Support Engineer, Cloud
Support Engineer, Cloud

Sun Life • Waterloo

Híbrido
CAD 70 000 - 105 000
Hybrid work model
Wellness programs
Career growth opportunities
+1
Software Dev, Data - Remote
Software Dev, Data - Remote

Randstad Canada • Toronto

Teletrabalho
CAD 120 000 - 170 000
Senior Data Scientist
Senior Data Scientist

Sun Life (Experienced) • Toronto

Híbrido
CAD 100 000 - 143 000
Hybrid work model
Wellness programs
Career path opportunities
+1