dbt Data Engineer | Snowflake Pipelines, Airflow & AWS

Tech Aalto Pte Ltd; Sydney; On-site; AUD 90,000 - 130,000; Full time

Job summary

Tech Aalto Pte Ltd in Sydney, Australia seeks a data engineer to build and maintain dbt transformation models across end-to-end data pipelines. You will write Snowflake SQL for complex transformations and develop Airflow DAGs on AWS ECS.

The role involves Python-based ingestion tasks, Lambda functions, and data quality tests. You will maintain lineage docs, support data sharing to downstream consumers, and own tickets from design to production.

Qualifications

• Experience with data transformation and data warehousing.
• Strong knowledge of dbt Core and Snowflake SQL.
• Experience developing DAGs with Apache Airflow.
• Proficiency in Python for data ingestion and validation.
• Hands-on AWS services (S3, Lambda, MWAA, ECS, Glue Catalogs, Lake Formation).
• Exposure to event-driven data sharing and SQS/EventBridge.
• Experience in CI/CD using GitHub Actions.
• Familiarity with structured financial or fixed-format data files is a plus.

Responsibilities

• Build and maintain dbt transformation models across multiple pipeline layers from raw ingestion to governed datasets.
• Write Snowflake SQL for complex transformations with type casting, deduplication, incremental load logic, surrogate keys.
• Develop and debug Apache Airflow DAGs on AWS ECS.
• Contribute to AWS Lambda-based ingestion (Python) including file validation, control file generation, and S3 event handling.
• Maintain source-to-target mapping documentation and align models to business requirements and data specs.
• Support onboarding of downstream consumers via data sharing mechanisms and event-driven notifications.
• Participate in code reviews, write YAML-based data quality tests, and own tickets from design through production.

Tools

Snowflake SQL

Python

Apache Airflow

AWS

dbt Core

S3

MWAA

ECS

Glue Catalogs

Lake Formation

Lambda

SQS

EventBridge

GitHub Actions

Iceberg

Job description

Tech Aalto Pte Ltd in Sydney, Australia seeks a data engineer to build and maintain dbt transformation models across end-to-end data pipelines. You will write Snowflake SQL for complex transformations and develop Airflow DAGs on AWS ECS.

The role involves Python-based ingestion tasks, Lambda functions, and data quality tests. You will maintain lineage docs, support data sharing to downstream consumers, and own tickets from design to production.