Senior Data Engineer: dbt, Snowflake & Airflow Expert

Tech Aalto Pte ltd; Sydney; On-site; AUD 140,000 - 190,000; Full time

Job summary

Tech Aalto Pte ltd seeks a Senior Data Engineer to build and maintain dbt transformations across multiple pipeline layers, from raw ingestion to governed datasets. You will write Snowflake SQL, develop Airflow DAGs on AWS ECS, and contribute to Lambda-based ingestion in Python.

You will maintain documentation, onboard downstream consumers, and participate in code reviews with YAML-based data quality tests. This role emphasizes collaboration and data governance across financial data formats.

Qualifications

• Experience building dbt transformation models across pipelines (raw ingestion to governed datasets).
• Proficient in Snowflake SQL with complex transformations, deduplication, and surrogate key generation.
• Developing and debugging Airflow DAGs on AWS ECS.
• Contributing to AWS Lambda-based ingestion (Python): file validation, control file generation, S3 event handling.
• Maintaining source-to-target mapping docs and aligning models to business dataspecs.

Responsibilities

• Build and maintain dbt transformations across pipeline layers.
• Write Snowflake SQL for transformations and modeling.
• Develop Airflow DAGs on AWS ECS and support ingestion pipelines.

Skills

SQL

dbt Core

Airflow

AWS

Python

ECS

Iceberg

GitHub Actions

Tools

dbt Core

GitHub Actions

Apache Airflow

AWS (S3/Lambda/MWAA/ECS)

Job description

Tech Aalto Pte ltd seeks a Senior Data Engineer to build and maintain dbt transformations across multiple pipeline layers, from raw ingestion to governed datasets. You will write Snowflake SQL, develop Airflow DAGs on AWS ECS, and contribute to Lambda-based ingestion in Python.

You will maintain documentation, onboard downstream consumers, and participate in code reviews with YAML-based data quality tests. This role emphasizes collaboration and data governance across financial data formats.