AWS Data Engineer - SQL, ETL , PYTHON, Infrastructure

Apptoza Inc.; Toronto; Hybrid; CAD 120,000 - 180,000; Part time

Job summary

Apptoza Inc. in Toronto is seeking a Senior AWS Data Engineer to design, develop, and support enterprise-scale data platforms on AWS. You will lead scalable data pipelines and real-time streaming solutions in a banking environment.

This role requires 12+ years in data engineering, hands-on AWS data services, ETL/ELT development, and strong analytical and communication skills. The position offers a hybrid work model with 3 days onsite weekly.

Qualifications

• 12+ years of Data Engineering experience.
• Hands-on with AWS data services and ETL/ELT development.
• Ability to design scalable, enterprise-grade data platforms on AWS.

Responsibilities

• Design, develop, and maintain scalable data pipelines using AWS services.
• Build and optimize ETL/ELT workflows with AWS Glue (PySpark/Python).
• Develop serverless data processing with AWS Lambda.
• Design and manage data lakes using Amazon S3.
• Develop data warehouses with Amazon Redshift.
• Work with DynamoDB and other AWS data services for high-performance apps.
• Build and support real-time streaming with Kinesis and/or Kafka.
• Develop, schedule, and monitor workflows with Apache Airflow.
• Write advanced SQL queries and optimize performance for OLTP/OLAP.
• Implement IaC using AWS CDK or Terraform.
• Monitor, troubleshoot, and support production data pipelines.
• Collaborate with cross-functional teams and follow Agile practices.

Skills

AWS Glue

Amazon S3

AWS Lambda

Amazon Redshift

Amazon DynamoDB

Kinesis/Kafka

SQL

Python

ETL/ELT

OLTP/OLAP

Infrastructure as Code

Apache Airflow

Tools

AWS CDK

Terraform

Job description

Location: Toronto, ON

Work Model: Hybrid – 3 Days/Week Onsite

Duration: 12-Month Contract (Extension Possible)

Job Summary

AWS, SQL, OLAP, OLTP, ETL , PYTHON, Infrastructure

We are seeking a Senior AWS Data Engineer with 10+ years of hands-on experience designing, developing, and supporting enterprise-scale data platforms on AWS. The ideal candidate will be a strong individual contributor with deep expertise in AWS data engineering, ETL development, and real-time data streaming technologies.

This role requires someone who can quickly understand business requirements, build scalable data pipelines, optimize data processing, and support production-grade cloud data solutions in a fast-paced banking environment.

Key Responsibilities

• Design, develop, and maintain scalable data pipelines using AWS services.
• Build and optimize ETL/ELT workflows using AWS Glue (PySpark/Python).
• Develop serverless data processing solutions using AWS Lambda.
• Design and manage data lakes using Amazon S3.
• Develop and optimize data warehouse solutions using Amazon Redshift.
• Work with Amazon DynamoDB and other AWS data services for high-performance applications.
• Build and support real-time data streaming solutions using Amazon Kinesis and/or Apache Kafka.
• Develop, schedule, and monitor workflows using Apache Airflow.
• Write complex SQL queries and optimize database performance across OLTP and OLAP systems.
• Implement Infrastructure as Code (IaC) using AWS CDK or Terraform.
• Monitor, troubleshoot, and support production data pipelines.
• Collaborate with cross-functional teams to deliver reliable and scalable data solutions.
• Follow Agile development practices and participate in sprint planning, code reviews, and technical discussions.

Required Skills

12+ years of experience in Data Engineering.

Strong hands-on experience with:

• AWS Glue (PySpark/Python)
• Amazon S3
• AWS Lambda
• Amazon Redshift
• Amazon DynamoDB
• Amazon Kinesis and/or Apache Kafka
• SQL
• Python
• Strong understanding of ETL/ELT development.
• Experience working with OLTP and OLAP databases.
• Hands-on experience with Infrastructure as Code (AWS CDK or Terraform).
• Experience building and supporting production-grade AWS data platforms.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication and collaboration skills.

Preferred Qualifications

• Experience in the Banking or Financial Services domain.
• Experience with real-time event-driven data architectures.
• Familiarity with CI/CD pipelines and DevOps practices.
• Knowledge of data governance, security, and AWS best practices.
• AWS Certifications are an asset.

Ideal Candidate

• Strong hands-on AWS Data Engineer with proven technical expertise.
• Individual contributor capable of designing and developing scalable cloud data solutions.
• Experience delivering enterprise-grade AWS data platforms in production environments.
• Able to work independently while collaborating effectively with cross-functional teams.