Support Engineer - Data & Analytics Operations
- Hiring from
- Canada
- Work type
- Hybrid
- Posted
624,640 remote jobs, straight from company career pages
100% free · New jobs every minute
Show job descriptionHide job description
Senior Support Engineer - Data & Analytics Operations
Client: SunLife
Duration: December 28, 2026 - June 18, 2027 (extension possible)
Location: Waterloo, ON or North York, ON
Work Arrangement: Hybrid (2 days onsite per week)
Hours: Monday-Friday, approximately 8:30 AM-4:30 PM (flexibility available)
Number of Positions: 1
Reason the Role Is Open: Increased Workload
Role Overview
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.
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
Critical Skills / Must-Haves:
Core Technical Requirements
- 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.
- AWS / Cloud Experience
Candidates should have hands-on experience with several of the following technologies:
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 Skills:
- Exposure to additional AWS services such as Bedrock, SageMaker, Amazon Q, and Athena is highly desirable.
Preferred Qualifications
- 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.
Top Performer Profile
- Learn new technologies and environments quickly
- Can clearly articulate what they built, why they built it, and the business outcome achieved
- Demonstrate strong analytical and troubleshooting capabilities
- Understand operational ownership and can take initiatives from planning through deployment
- Have experience supporting data and analytics platforms rather than solely developing new applications
- Show initiative, curiosity, and a willingness to dive into unfamiliar environments
- Perform well in collaborative support engineering teams focused on operational excellence
Interview Process
1 interview: Onsite if they are located in Waterloo. Virtual interview for North York Location
Program & Compliance Requirements
- Is Reliability Clearance Required? Yes
- Does the Role Require Privileged System Access via CyberArk? Yes
- If Yes: Tier 2 background check required before CyberArk access is granted.
Agency Screening Priorities
When sourcing candidates, prioritize individuals who have:
- SQL + ETL + Data Operations Support experience
- AWS experience (particularly Glue, Lambda, EMR, S3)
- Experience supporting upgrades and operational projects through SDLC
- Strong troubleshooting and root cause analysis skills
- Data warehousing or enterprise analytics platform experience
- Snowflake and Iceberg exposure (highly desirable)
Candidates to Avoid
- Pure software developers focused on building new applications
- Pure project managers without hands-on technical capability
- Senior Data Engineers seeking architect-level or highly specialized engineering work
- Candidates lacking operational support experience in data environments
This positioning should help agencies understand that the target profile is closer to a Senior Support Engineer / Data Operations Engineer / Application Support Engineer supporting analytics platforms, rather than a traditional developer or data engineer.