Sr. AWS Data Engineer

TEEMA; Toronto; On-site; CAD 100,000 - 140,000; Full time

Job summary

A leading company is seeking a Senior AWS Data Engineer to design and maintain ETL/ELT processes. The role requires strong expertise in PySpark, SQL, and AWS services, collaborating with teams to deliver scalable data solutions. This is a unique opportunity for engineers looking to leverage their cloud skills in an evolving environment.

Qualifications

• Experience in creating and managing ETL/ELT pipelines.
• Hands-on expertise in AWS services including Glue and Airflow.
• Strong SQL skills for optimizing data models.

Responsibilities

• Design, build, and maintain robust ETL/ELT pipelines using AWS Glue and Apache Airflow.
• Develop SQL scripts and optimize data models in Amazon Redshift.
• Implement data quality checks and monitoring for data pipelines.

Skills

Pyspark

Python

SQL

AWS Glue

Apache Airflow

Tools

Amazon Redshift

AWS S3

Lambda

Step Functions

Athena

CloudWatch

Job description

Job Title:Sr. AWS Data Engineer
Job ID:80673
Location: Toronto, Ontario

What you will be doing:

• Pyspark, Python, SQL coding is important.

• Design, build, and maintain robust ETL/ELT pipelines using AWS Glue and Apache Airflow.

• Expertise in Apache Airflow DAG creation, scheduling, dependency management, and error handling.

• Strong hands-on experience with AWS Glue both Glue Jobs (PySpark) and Glue Catalog.

• Develop SQL scripts and optimize data models in Amazon Redshift.

• Orchestrate data workflows and job dependencies using Airflow DAGs.

• Collaborate with data engineers, analysts, and stakeholders to understand data requirements and deliver scalable solutions.

• Implement and enforce data quality checks, schema validation, and monitoring for all data pipelines.

• Integrate various AWS services including S3, Lambda, Step Functions, Athena, and CloudWatch.

For more information about TEEMA and to consider other career opportunities, please visit our website atwww.teemagroup.com