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