Sr. AWS Data Engineer, Infrastructure With Strong SQL

Client JD

Role: Sr. AWS Data Engineer, Infrastructure With Strong SQL

Location: Toronto

Client: Banking Labs/BMO

1yr contract

Hybrid

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