Staff Data Engineer

Tech Aalto

New South Wales

On-site

AUD 120,000 - 180,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Tech Aalto in Australia seeks a data engineer to design and maintain dbt-based transformation pipelines across raw and governed datasets. You will implement Snowflake SQL transformations, and build robust Airflow DAGs on AWS ECS to support scalable data ingestion.

Required skills include strong SQL, dbt Core expertise, and AWS data services. You will contribute to data quality tests, documentation, and downstream data sharing initiatives, collaborating closely with product and analytics teams.

Qualifications

  • Proficiency with dbt Core is required.
  • Strong SQL and data modeling experience is essential.
  • Experience with AWS-based data pipelines is preferred.

Responsibilities

  • Build and maintain dbt transformation models across multiple pipeline layers—from raw ingestion to governed datasets.
  • Write Snowflake SQL for transformations including type casting and deduplication.
  • Develop and debug Apache Airflow DAGs on AWS ECS.
  • Contribute to AWS Lambda-based ingestion and S3 event handling.
  • Maintain source-to-target mappings and align models to data specs.
  • Support onboarding of downstream consumers via data sharing and event-driven notifications.
  • Participate in code reviews and write YAML-based data quality tests; own tickets from design through production.

Skills

Strong SQL

Tools

dbt Core
Snowflake
Apache Airflow
AWS S3
AWS Lambda
MWAA
ECS
Glue Catalogs
Lake Formation
SQS
EventBridge
GitHub Actions
Apache Iceberg

Job description

Responsibilities
  • Building and maintaining dbt transformation models across multiple pipeline layers — from raw ingestion through to governed, consumer-ready datasets
  • Writing Snowflake SQL for complex transformations: type casting, deduplication, incremental load logic, surrogate key generation
  • Developing and debugging Apache 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 documentation and aligning models to business requirements and data specs
  • Supporting onboarding of downstream consumers via data sharing mechanisms and event-driven notifications
  • Participating in code reviews, writing YAML-based data quality tests, and owning tickets from design through to production
Tech stack required
  • Strong SQL
  • Proficiency with dbt Core (Must have)
  • Apache Iceberg Table format (Nice to have)
  • Apache Airflow
  • AWS -Working Knowledge of S3, Lambda, MWAA, ECS, Glue Catalogs, Lake Formation, Lambda, SQS, EventBridge
  • Experience with fixed-format or structured financial data files
  • CICD with Github Actions.

Confidentialityisassured,andonlyshortlistedcandidateswillbenotifiedforinterviews

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr Data Engineer
Sr Data Engineer

Tech Aalto Pte Ltd • Sydney

On-site
AUD 140,000 - 190,000
Senior Data Engineer: dbt, Snowflake & Airflow Expert
Senior Data Engineer: dbt, Snowflake & Airflow Expert

Tech Aalto Pte Ltd • Sydney

On-site
AUD 140,000 - 190,000
Staff Data Engineer: dbt, Snowflake & AWS Data Pipelines
Staff Data Engineer: dbt, Snowflake & AWS Data Pipelines

Tech Aalto • New South Wales

On-site
AUD 120,000 - 180,000
Data Engineering (Snowflake, DBT, Airflow)
Data Engineering (Snowflake, DBT, Airflow)

CandidHR • Australia

Remote
AUD 150,000 - 190,000
Data Engineer
Data Engineer

Zone IT Solutions • Western Australia

On-site
AUD 120,000 - 160,000
Data Engineer (DBT + Snowflake)
Data Engineer (DBT + Snowflake)

Carecone Group • Sydney

On-site
AUD 150,000 - 195,000
Senior Data Engineer - Snowflake Migration & MLOps
Senior Data Engineer - Snowflake Migration & MLOps

4impact • Queensland

On-site
AUD 110,000 - 170,000
Senior Data Engineers (GCP, DBT, Vertex AI)
Senior Data Engineers (GCP, DBT, Vertex AI)

Simplyai • Sydney

On-site
AUD 130,000 - 180,000
Senior Snowflake Engineer - dbt, Airflow, AWS | Sydney
Senior Snowflake Engineer - dbt, Airflow, AWS | Sydney

Persistent Systems • Sydney

Hybrid
AUD 140,000 - 200,000
Competitive salary
Benefits package
Talent development
+2
Senior Data Engineer
Senior Data Engineer

DX1 • Melbourne

On-site
AUD 160,000 - 230,000
Top locations