Job descriptionSr AWS Data Engineer – Strong SQL, AWS Infrastructure Location:
Toronto, ON
Work Mode:
Hybrid – 3 days from office
Duration:
1 year contract – extension possible
Overview We are seeking a highly skilled Data Engineer with deep expertise in SQL (including stored procedures) and AWS-based data engineering solutions. The role focuses on managing cloud infrastructure, automation, DevOps, security & compliance, and monitoring/troubleshooting.
Key Responsibilities
Develop and optimize complex SQL queries and stored procedures for high‑performance data processing and transformation.
Build and maintain scalable ETL/ELT pipelines on AWS using services such as Glue, Lambda, S3, Athena, Redshift, Kafka, Airflow, and Step Functions.
Implement and maintain data integration solutions from diverse sources into a centralized data lake or data warehouse.
Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and deliver reliable solutions.
Monitor and troubleshoot data pipelines to ensure data accuracy, timeliness, and reliability.
Apply data governance and security best practices in all development work.
Qualifications
Expert‑level proficiency in SQL, including performance tuning, complex joins, and stored procedures.
Experience with AWS Data Engineering tools: AWS Glue, Amazon Redshift, AWS Lambda, Amazon S3, Kafka, Step Functions.
Experience with data modeling, ETL orchestration, and data pipeline development in AWS.
Familiarity with version control systems (Git) and CI/CD for data workflows.
Experience with Python and PySpark for ETL processes.
Experience 10+ years in data engineering roles.
#J-18808-Ljbffr