AWS Data Engineer - SQL, ETL , PYTHON, Infrastructure Job at Atlantis IT group, Ontario, CA

  • Atlantis IT group
  • Ontario, CA

Job Description

Job Title: AWS Data Engineer - SQL, ETL , PYTHON, Infrastructure

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

Apache Airflow

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.

Job Tags

Contract work, 3 days per week

Similar Jobs

Always Best Care Senior Services - Greater West Houston and ...

Vietnamese-Speaking Caregiver - Day Shift - Dementia Care - Houston (77084) Job at Always Best Care Senior Services - Greater West Houston and ...

At Always Best Care, we provide compassionate, high-quality in-home care for seniors and individuals needing support with daily living...  ...in Houston, TX (77084). This position requires experience with dementia care and a reliable commitment to steady shifts.Location: Greater... 

Confidential

Senior Associate, Transfer Pricing Job at Confidential

 ...We are seeking a Senior Associate to join our Transfer Pricing team, offering the opportunity to influence client business decisions, engage directly with senior practitioners, and build deep commercial and economic expertise within a collaborative and flexible team culture... 

Internet Brands

Digital Marketing Specialist Job at Internet Brands

 ...client opportunities, potential risks, and other key issues.~Research, understand, and stay up-to-date on best practices for SEO and PPC methodologies.~Provide guidance in issues of a technical nature to clients in a non-technical field.~Adhere to clearly defined... 

Federal Express Corporation

Package Handler (Warehouse like) Job at Federal Express Corporation

 ...tuition and other approved education expenses after completing 90 continuous days of employment. The employee benefits offered by FedEx are governed by formal plan documents and, in the event of any conflict between this announcement and the applicable plan document,... 

Lincoln Electric

Aerospace Design & Applications Engineer Job at Lincoln Electric

 ...conceptual designs through the identified manufacturing processes of the related opportunity. Will require a strong understanding of aerospace manufacturing processes, cost drivers, and regulatory requirements and their associated environments. Responsible for complete...