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