Senior Data Support Engineer – AWS, SQL & ETL
- Full-time, Temporary
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.