
Senior Data Engineer
Role summary
Seeking a Senior Data Engineer with expert SQL and AWS data engineering skills for a 1-year contract in Toronto. The role involves designing, building, and optimizing scalable data pipelines and systems using AWS services like Glue, Lambda, S3, Athena, Redshift, Kafka, and Step Functions. Responsibilities include developing complex SQL queries, managing ETL/ELT processes, integrating data from various sources, and ensuring data accuracy and reliability. Familiarity with Python, PySpark, Airflow, and CI/CD is also required. This hybrid role emphasizes cloud infrastructure management, automation, DevOps, security, and monitoring.
Role: AWS Data Engineer with Strong SQL
Location: Toronto, On
Hybrid (3 days from Office)
Duration : 1yr contract - Extension
Job Summary:
Managing cloud infrastructure, Automation and DevOps, Security & Compliance, and Monitoring/Troubleshooting.
We are seeking a highly skilled Data Engineer with deep expertise in SQL (including stored procedures) and AWS-based data engineering solutions.
You will be responsible for designing, building, and optimizing scalable data pipelines and systems that enable analytics, reporting, and data-driven decision-making across the organization.
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 various data 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.
Skills Required Expert-level proficiency in SQL, including performance tuning, writing complex joins, and stored procedures in databases.
Experience with AWS Data Engineering tools
AWS Glue
Amazon Redshift
AWS Lambda
Amazon S3
Athena
Kafka
Step Functions
Experience with data modeling, ETL orchestration, and data pipeline development in AWS.
Familiarity with version control systems (e.g., Git) and CI/CD for data workflows.
Airflow
Experience with Python and PySpark.
Similar roles
- Senior Data EngineerExperion Technologies · Plano, Texas, United States · Hybrid
- Lead Data EngineerSmart IT Frame LLC · Los Angeles, California, United States · Hybrid
Principal Data EngineerRS21: A Data Science and Visualization Company · United States · Remote
Senior Data EngineerRaag Solutions · Bellevue, Washington, United States · Onsite- Lead Data EngineerRetail Insight Ltd · Illinois, United States · Hybrid