Senior Support Engineer, Data & Analytics Operations (Contract)
Location: Waterloo, ON or North York, ON (Hybrid, 2 days onsite per week)
Contract: December 28, 2026 to June 18, 2027, with possible extension
Hours: Monday to Friday, approx. 8:30 AM to 4:30 PM (some flexibility)
About the Role
Our client, a leading Canadian financial services organization, is looking for a Senior Support Engineer to join its Data & Analytics Operations team. You'll keep mission-critical data platforms running, troubleshoot ETL and data ingestion issues, and help deliver platform upgrades, including the move toward Snowflake and Apache Iceberg.
This is a hands-on support engineering role, not a traditional software development role. You'll use your development background to diagnose problems, find root causes, and keep the data ecosystem stable.
What You'll Do
Operational Support (about 70-80%)
- Monitor and support end-to-end data ingestion, ETL and analytics processes
- Investigate and resolve complex data discrepancies and production issues
- Analyze failed jobs, data quality problems and platform performance
- Troubleshoot SQL, ETL, database and cloud platform issues
- Support data warehouse and enterprise data lake environments
- Follow Incident, Problem and Change Management processes
- Create and maintain technical and operational documentation
Operational Projects & Upgrades (about 20-30%)
- Take part in application, database, cloud and platform upgrades
- Coordinate operational project work across the full SDLC
- Support planning, UAT, deployment prep, release coordination and production implementation
- Work with support engineers, project teams and technology partners on operational enhancements
- Support modernization work including Snowflake and Iceberg adoption
Must-Haves
- 4+ years supporting enterprise data, analytics or application environments
- Strong SQL development and query optimization skills
- Hands-on ETL experience (Informatica Cloud/IICS or PowerCenter preferred)
- Experience troubleshooting data pipelines, integrations and processing workflows
- Solid understanding of relational databases and data warehousing concepts
- Microsoft SQL Server experience
- Hands-on AWS experience with several of: Glue, Lambda, EMR, EC2, S3, Redshift, CloudWatch
- Experience supporting platform, application, database or cloud upgrades
- Strong understanding of the SDLC and coordinating work across dev, test, staging and production
- Experience planning and supporting deployments through to production
- Operational project coordination experience
Nice to Have
- Snowflake and/or Apache Iceberg
- AWS Bedrock, SageMaker, Amazon Q or Athena
- Enterprise data lake, distributed computing or large-scale data processing
- DevOps tools: Bitbucket, Jenkins, Ansible, CI/CD pipelines
- AI solutions or AI agent development
- Financial services or insurance industry experience
You'll Do Well Here If You
- Pick up new technologies and environments quickly
- Can clearly explain what you built, why you built it, and the business outcome
- Enjoy digging into root causes
- Own initiatives from planning through deployment
- Have supported data and analytics platforms, not only built new applications
- Thrive in a collaborative support engineering team
Requirements
• Must be able to obtain Reliability Clearance (Need to have been in Canada for the last 5 years)
- Tier 2 background check required (role involves privileged system access)
- Interview process: 1 round (onsite for Waterloo, virtual for North York)
Note: We use AI tools to obtain basic information, detect plagiarism, false employment history or references, categorize your skills, and do an initial match with job posting. Background checks will be conducted.