Apptoza Inc. logo
Apptoza Inc. Verified
Information Technology & Services, Software Development, Mobile Apps

Senior Data Engineer

Toronto, Ontario, CanadaHybridContractSeniorPosted 2 months ago

Is this role right for you?

Upload your resume and get a skill-by-skill breakdown — see exactly where you match, where you're close, and what to highlight. Not a mystery percentage.

Get a tailored resume highlighting what this role needs.

Role summary

Seeking a Senior Data Engineer with expert SQL and AWS data engineering skills for a 1-year contract in Toronto. The role involves designing, building, and optimizing scalable data pipelines and systems using AWS services like Glue, Lambda, S3, Athena, Redshift, Kafka, and Step Functions. Responsibilities include developing complex SQL queries, managing ETL/ELT processes, integrating data from various sources, and ensuring data accuracy and reliability. Familiarity with Python, PySpark, Airflow, and CI/CD is also required. This hybrid role emphasizes cloud infrastructure management, automation, DevOps, security, and monitoring.

Role: AWS Data Engineer with Strong SQL

Location: Toronto, On

Hybrid (3 days from Office)

Duration : 1yr contract - Extension

Job Summary:

Managing cloud infrastructure, Automation and DevOps, Security & Compliance, and Monitoring/Troubleshooting.

We are seeking a highly skilled Data Engineer with deep expertise in SQL (including stored procedures) and AWS-based data engineering solutions.

You will be responsible for designing, building, and optimizing scalable data pipelines and systems that enable analytics, reporting, and data-driven decision-making across the organization.

Key Responsibilities Develop and optimize complex
SQL queries
and stored procedures for high-performance data processing and transformation.

Build and maintain scalable
ETL/ELT pipelines
on
AWS using services such as Glue, Lambda, S3, Athena, Redshift, Kafka, Airflow, and Step Functions
.

Implement and maintain data integration solutions from various data sources into a centralized data lake or data warehouse.

Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and deliver reliable solutions.

Monitor and troubleshoot data pipelines to ensure data accuracy, timeliness, and reliability.

Apply data governance and security best practices in all development work.

Skills Required Expert-level proficiency in SQL, including performance tuning, writing complex joins, and stored procedures in databases.

Experience with AWS Data Engineering tools

AWS Glue

Amazon Redshift

AWS Lambda

Amazon S3

Athena

Kafka

Step Functions

Experience with data modeling, ETL orchestration, and data pipeline development in AWS.

Familiarity with version control systems (e.g., Git) and CI/CD for data workflows.

Airflow

Experience with Python and PySpark.

Ready to apply?
You'll be redirected to Apptoza Inc.'s application page.

Similar roles