AWS Data Engineer

Job Title: AWS Data Engineer
Location: Toronto, ON (Hybrid)
Experience: 8–12 Years

Job Description
We are looking for an experienced AWS Data Engineer to design, build, and optimize scalable data pipelines and cloud-based data solutions. The ideal candidate will have strong expertise in SQL, AWS data services, Python, and PySpark. Previous BMO (Bank of Montreal) experience is highly preferred.
Key Responsibilities

• Design and develop scalable ETL/ELT pipelines on AWS.

• Build and optimize complex SQL queries and stored procedures.

• Develop data integration solutions using AWS data services.

• Create and maintain data lakes and data warehouse solutions.

• Monitor, troubleshoot, and optimize data pipelines.

• Collaborate with business, analytics, and engineering teams.

• Follow data governance, security, and CI/CD best practices.

Required Skills

• 8–12 years of Data Engineering experience.

• Strong SQL expertise (complex queries, performance tuning, stored procedures).

• Hands-on experience with:

• AWS Glue

• Amazon Redshift

• AWS Lambda

• Amazon S3

• Amazon Athena

• Kafka

• AWS Step Functions

• Apache Airflow

• Python and PySpark.

• Data modeling, ETL/ELT, and AWS-based data pipeline development.

• Git and CI/CD experience.

• Banking domain experience is preferred.

• BMO project experience is a strong advantage.