Senior AWS Data Engineer - SQL, OLAP, OLTP, ETL , PYTHON

Apptoza Inc.; Toronto; On-site; CAD 120,000 - 160,000; Full time

Job summary

Apptoza Inc. in Toronto seeks a Senior AWS Data Engineer with 12+ years of hands-on experience designing, building, and supporting enterprise-scale data platforms on AWS.

The role requires delivering scalable data pipelines and production-grade cloud solutions in a fast-paced environment. You will design and maintain data pipelines, build ETL/ELT workflows with Glue, develop serverless processing with Lambda, and manage data lakes on S3 and Redshift.

Qualifications

• 12+ years of data engineering experience.
• Strong hands-on AWS data engineering expertise.
• Experience with ETL/ELT development and real-time streaming.
• Proficient in SQL and Python.
• Experience with OLTP/OLAP databases.
• IaC experience with AWS CDK or Terraform.
• Banking or financial services domain experience preferred.
• Excellent communication and collaboration skills.

Responsibilities

• Design, develop, and maintain scalable data pipelines on AWS.
• Build and optimize ETL/ELT workflows using AWS Glue.
• Develop serverless data processing with AWS Lambda.
• Design and manage data lakes with S3.
• Develop and optimize data warehouses with Redshift.
• Work with DynamoDB and other AWS data services.
• Build real-time streaming solutions with Kinesis and Kafka.
• Develop, schedule, and monitor workflows with Airflow.
• Write complex SQL queries and optimize performance.
• Implement IaC using AWS CDK or Terraform.
• Collaborate with cross-functional teams and participate in Agile sprints.

Skills

Data engineering

Cloud data platforms

ETL/ELT development

SQL

Python

Real-time streaming

Agile development

Production-grade systems

Troubleshooting

Communication

Tools

AWS Glue

Amazon S3

AWS Lambda

Amazon Redshift

Amazon DynamoDB

Amazon Kinesis

Apache Kafka

Apache Airflow

AWS CDK

Terraform

PySpark

Job description

Duration: 12-Month Contract (Extension Possible)

Job Summary

AWS, SQL, OLAP, OLTP, ETL , PYTHON

We are seeking a Senior AWS Data Engineer with 12+ 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.