AWS Data Engineer

Role - AWS Data Engineer With Strong SQL

Location - Toronto, ON

Job summary - 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