Opens LinkedIn
- Employment type
- Contract
- Experience level
- 4+ years
- Posting language
- English
- Office presence
- 2 days per week
- Application method
- Apply on LinkedIn (LinkedIn sign-in required)
Job summary
Monitor and support data ingestion, ETL, analytics, and production environments, investigating data discrepancies, failed jobs, and platform issues while maintaining operational documentation and process compliance. Coordinate platform and application upgrades through the SDLC, including planning, UAT, deployment preparation, release coordination, and production implementation.
Job details
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.
What you’ll do
Monitor and support data ingestion, ETL, analytics, and production environments, investigating data discrepancies, failed jobs, and platform issues while maintaining operational documentation and process compliance. Coordinate platform and application upgrades through the SDLC, including planning, UAT, deployment preparation, release coordination, and production implementation.
Requirements
Requires at least four years supporting enterprise data, analytics, or application environments, with strong SQL, hands-on ETL, relational database, data warehousing, and cloud troubleshooting experience. Candidates should have experience with Microsoft SQL Server and AWS services, and be able to coordinate upgrades and deployments across SDLC environments; Snowflake and Iceberg experience are preferred.
Listed skills
- SQL · Preferred
- Amazon Web Services · Preferred
- Root Cause Analysis · Preferred
- Python · Preferred
Other relevant skills
Identified from the job description. Confirm important requirements above.
- SQL
- ETL
- Informatica
- AWS
- Data Pipeline Troubleshooting
- Data Operations Support
- Data Warehousing
- Microsoft SQL Server
- Cloud Platforms
- SDLC Coordination
- Deployment Support
- Root Cause Analysis
- Snowflake
- Apache Iceberg
- Python
- Incident, Problem, And Change Management
Job areas
- Technology
- Data & Analytics
- Customer Service & Support
- Software
More jobs from Amyantek
Operations Supervisor
- On-site
- Toronto, ON
- Posted Nov 17, 2026
NEG00008SE - Senior Support Maintenance and Dev
- On-site
- SK
- Posted Nov 17, 2026
BA-1095 Business Analyst
- Remote
- Winnipeg, Manitoba, Canada
- Posted Nov 17, 2026
CIS-120 Clinical Informatics
- Remote
- Winnipeg, Manitoba, Canada
- Posted Nov 17, 2026
