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.