Before Borders

Senior Data Support Engineer – AWS, SQL & ETL

recruteaction•North York, Waterloo, ON•Posted Nov 22, 2026
SeniorFull Time

About this role

Senior Data Support Engineer – AWS, SQL & ETL

Be part of an exciting opportunity in the insurance sector for our client, where you will support essential data and analytics operations in a complex enterprise environment. Contribute to troubleshooting, operational improvements, platform upgrades, and modernization initiatives while collaborating with technology teams.

What is in it for you

  • Salaried: $65-70 per hour.
  • Incorporated Business Rate: $75-80 per hour.
  • 6-month contract, with the potential for extension.
  • Full-time position: 37.5 hours per week.
  • Monday to Friday schedule, from 8:30 am to 4:30 pm, with flexibility available.
  • Hybrid work arrangement with 2 days on-site per week.
  • Location in Waterloo, Ontario, or North York, Ontario.
  • Reliability Clearance is required.

Responsibilities

  • Monitor and support end-to-end data ingestion, ETL, and analytics processes.
  • Investigate and resolve data discrepancies, failed jobs, data quality issues, production incidents, and platform performance concerns.
  • Troubleshoot SQL, ETL, database, cloud platform, data pipeline, and integration issues.
  • Monitor production environments and implement operational improvements.
  • Support data warehousing and enterprise data lake environments.
  • Follow Incident, Problem, and Change Management processes.
  • Create and maintain technical and operational documentation.
  • Participate in application, database, cloud, and platform upgrades.
  • Coordinate operational projects throughout the SDLC, including planning, UAT, deployment preparation, release coordination, and production implementation.
  • Collaborate with support engineers, project teams, and technology partners to deliver operational enhancements.
  • Support modernization initiatives, including Snowflake and Iceberg adoption.

What you will need to succeed

Required qualifications

  • 4+ years of experience supporting enterprise data, analytics, or application environments.
  • Strong SQL development and query optimization skills.
  • Hands-on ETL experience.
  • Strong understanding of relational databases and data warehousing concepts.
  • Experience with Microsoft SQL Server.
  • Experience troubleshooting data pipelines, integrations, and data processing workflows.
  • Experience working in cloud-based environments, with hands-on experience in several of the following AWS technologies: Glue, Lambda, EMR, EC2, S3, Redshift, and CloudWatch.
  • Experience participating in platform, application, database, or cloud upgrades.
  • Strong understanding of the Software Development Lifecycle.
  • 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.

Preferred qualifications

  • Informatica Cloud or Informatica On-Prem experience.
  • Snowflake experience.
  • Apache Iceberg experience.
  • Enterprise Data Lake environment experience.
  • Distributed computing and large-scale data processing experience.
  • Python development experience.
  • Experience with AWS Bedrock, SageMaker, Amazon Q, or Athena.
  • GitHub Copilot experience.
  • Experience with DevOps tools, including BitBucket, Jenkins, Ansible, and CI/CD pipelines.
  • Experience with AI solutions or AI agent development.
  • Financial services or insurance industry experience.

Soft skills

  • Ability to learn new technologies and environments quickly.
  • Strong analytical, troubleshooting, and root cause analysis capabilities.
  • Ability to clearly articulate technical work, its purpose, and the resulting business outcome.
  • Ability to take ownership of operational initiatives from planning through deployment.
  • Initiative, curiosity, and willingness to work in unfamiliar environments.
  • Ability to work effectively in collaborative support engineering teams focused on operational excellence.

Why Recruit Action?

Recruit Action (agency permit: AP-2504511) provides recruitment services through quality support and a personalized approach. As part of the screening process, some applications may be reviewed using artificial intelligence tools. Only candidates who meet the hiring criteria will be contacted.

Immigration pathway

ON • Express • onsite • TEER 1