Senior Snowflake Engineer - dbt, Airflow, AWS | Sydney

Persistent Systems; Sydney; Hybrid; AUD 140,000 - 200,000; Full time

Benefits offered by this job

Competitive salary

Benefits package

Talent development

Flexible hours

Insurance coverage

Job summary

Persistent Systems in Sydney, Australia is seeking an experienced Senior Data Engineer to build and maintain dbt models, write Snowflake SQL, and develop Airflow DAGs on AWS. The role requires 12+ years of experience and leverages a modern data stack including Snowflake, dbt Core, and Apache Airflow.

You will work with AWS services and contribute to data ingestion, quality tests, and downstream data sharing, with a hybrid work arrangement and competitive salary.

Qualifications

• Strong SQL skills.
• Proficiency with dbt Core.
• Apache Iceberg table format is a plus.
• Experience with AWS services (S3, Lambda, MWAA, ECS, Glue Catalogs, Lake Formation, SQS, EventBridge).
• Experience with fixed-format or structured financial data files.
• CI/CD using GitHub Actions.

Responsibilities

• Building and maintaining dbt transformation models across multiple pipeline layers—from raw ingestion 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) including 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.

Skills

Snowflake

dbt Core

Apache Airflow

Tools

AWS

S3

Lambda

MWAA

ECS

Job description

Persistent Systems in Sydney, Australia is seeking an experienced Senior Data Engineer to build and maintain dbt models, write Snowflake SQL, and develop Airflow DAGs on AWS. The role requires 12+ years of experience and leverages a modern data stack including Snowflake, dbt Core, and Apache Airflow.

You will work with AWS services and contribute to data ingestion, quality tests, and downstream data sharing, with a hybrid work arrangement and competitive salary.