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

The Hotel at Avalon

On Call Banquet Server Job at The Hotel at Avalon

## On Call Banquet ServerApply: On-Site: Houston Grand Hotel - River Oaks - Houston, TX: On Call: Posted Yesterday: JR119466**About Us**For more than 40 years, our hotel has been a landmark in the Houston hospitality scene. Today, The Houston Grand River Oaks is entering... 

Mark Spain Real Estate - Corp

Transaction Coordinator Job at Mark Spain Real Estate - Corp

Charlotte, North Carolina, United StatesTransaction Coordinator Mark Spain Real Estate (MSRE) is a top rated residential real estate brokerage in the US, helping families buy and sell their homes. MSRE is the #1 real estate team in the industry for client satisfaction,... 

Core-Mark

Truck Driver Job at Core-Mark

 ...customers. In this Transportation & Logistics role, you will operate company trucks, complete pre- and post-trip inspections, load/unload freight, and follow assigned routes while meeting delivery schedules. Youll interact directly with store teams, providing customer-first... 

Guardian Bus Company

CDL School Bus Driver - Sign On Bonus ($2,500, $2,000) Job at Guardian Bus Company

 ...schedule important to you? Guardian Bus is currently hiring drivers with Class B and Class C NY State licenses. We offer FREE CDL training (for applicants with a Class B permit)! Generous Sign-On Bonus!! Ensure school students are transported to and from school... 

TM5 PROPERTIES, LP

Listing & Transaction Coordinator Job at TM5 PROPERTIES, LP

 ...estate business has two sides to it. On stage (sales) and behind the scenes (administration and operations). As a Listing & Transaction Coordinator for the Terrence Murphy Team, you own the administration & transaction side of the business. The ideal candidate will be...