Senior Data Engineer (Snowflake, AWS, dbt)

About the role

A Senior Data Engineer position based in Sydney, working onsite on a contract basis. The role centres on building and maintaining data pipelines using Snowflake, AWS and dbt.

Key responsibilities

• Build and maintain dbt transformation models across multiple pipeline layers, from raw ingestion to governed, consumer-ready datasets.
• Write Snowflake SQL for complex transformations such as type casting, deduplication, incremental load logic and surrogate key generation.
• 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 through data sharing and event-driven notifications.
• Take part in code reviews, write YAML-based data quality tests and own tickets from design through to production.

Required profile

• Snowflake, AWS and dbt are mandatory skills.
• Experience with fixed-format or structured financial data files.

Required skills

• Strong SQL and proficiency with dbt Core.
• Apache Airflow and AWS (working knowledge of S3, Lambda, MWAA, ECS, Glue Catalogs, Lake Formation, SQS, EventBridge).
• CICD with GitHub Actions; Apache Iceberg table format is a nice-to-have.