Senior Data Engineer (Snowflake, AWS) | 12-Month Day Rate Contract | Sydney

Allura Partners; Sydney; Hybrid; AUD 221,000 - 314,000; Full time

Benefits offered by this job

Hybrid working

High-visibility program

Job summary

Allura Partners is recruiting for a Senior Data Engineer (Snowflake, AWS) on a 12-month day rate contract based in Sydney. You will design the AWS data engineering capability for a major migration program, build scalable ELT/ETL pipelines into Snowflake, and convert legacy logic to modern pipeline code using AI tooling.

You will lead data validation, reconciliation and cutover, while mentoring engineers and driving DevOps/DataOps practices across the team.

Qualifications

• 7+ years in data/cloud engineering.
• 5+ years delivering data platforms and warehouses in a Cloud/DevOps environment.
• 3+ years on AWS.

Responsibilities

• Design and build the AWS data engineering capability for the program.
• Build scalable ELT/ETL pipelines into Snowflake.
• Convert legacy warehouse logic into version-controlled pipeline code using AI tooling.
• Lead data validation, reconciliation and cutover.
• Automate deployment through IaC and CI/CD, mentoring engineers.

Skills

AWS

Snowflake

SQL

Python

Data migration

ETL/ELT

DevOps

CI/CD

Tools

dbt

Airflow

Matillion

Fivetran

Qlik Replicate

Terraform

CloudFormation

GitHub Actions

Docker

Splunk

DataDog

CloudWatch

Job description

Senior Data Engineer (Snowflake, AWS) | 12-Month Day Rate Contract | Sydney

About the Company

Our client is an Australian enterprise, with a large national footprint and a Sydney based head office. The business is investing heavily in its data future, modernising its legacy data estate onto AWS and Snowflake to reduce cost and risk.

About the Role

This 12-month day rate contract sits within the Data and Analytics function, supporting a major data modernisation program migrating Teradata, Oracle and SQL Server onto AWS and Snowflake. As a senior hands‑on engineer, you’ll build repeatable, AI‑accelerated migration patterns, lead reconciliation and cutover, and mentor engineers across the program.

Benefits

• Competitive day rate on a 12-month contract, with high chance of extension


• Hybrid working


• Hands‑on work applying generative AI to real migration challenges at enterprise scale


• Genuine input into architecture, migration strategy and wave prioritisation


• A high‑profile transformation program with strong visibility across the business

Duties / Key Responsibilities

• Design and build the AWS data engineering capability for the program, including landing zone, ingestion frameworks and migration tooling


• Build scalable ELT/ETL pipelines into Snowflake covering bulk historical loads, CDC and incremental replication


• Convert legacy warehouse logic (BTEQ, PL/SQL, T-SQL, stored procedures) into version‑controlled pipeline code, using AI tooling to accelerate conversion and mapping


• Lead data validation, reconciliation and cutover, proving parity before legacy decommissioning


• Automate deployment through Terraform, CloudFormation and GitHub Actions, and mentor engineers across DevOps and DataOps practices

Skills and Experience

• 7+ years in data and/or cloud engineering, including 5+ years delivering data platforms and warehouses in a Cloud/DevOps environment, with 3+ years on AWS


• Proven hands‑on delivery of large‑scale migrations from Teradata, Oracle and/or SQL Server into a cloud data platform


• Deep experience with AWS data services including S3, Glue, Lambda, Step Functions, DMS, EMR, Kinesis/MSK, Athena, IAM, KMS and MWAA


• AWS certification (Data Engineer Associate, Solutions Architect or DevOps Engineer)


• Advanced SQL and Python, with orchestration and ELT tooling such as dbt, Airflow, Matillion, Fivetran or Qlik Replicate


• Demonstrated use of AI or generative‑AI services (e.g. Bedrock, Amazon Q Developer, Snowflake Cortex, GitHub Copilot) to accelerate data engineering, with a sound understanding of data privacy and human‑in‑the‑loop review


• Strong dimensional modelling knowledge, including data vault or medallion architectures and source‑to‑target mapping


• Infrastructure‑as‑code, CI/CD and containerisation experience (Terraform, CloudFormation, GitHub, Jenkins, Docker)


• Production support across batch and streaming workloads, with observability tooling (Splunk, DataDog, CloudWatch) and ITIL incident management


• Excellent stakeholder engagement and communication skills, with a track record of mentoring engineers

Kaio is recruiting for this role on behalf of Allura Partners.

About Allura Partners

Allura Partners was founded to support private equity firms by placing C-Suites to lead, transform, and scale portfolio companies. Today, in addition to our proven private equity specialisation, we’ve become a trusted partner for major ASX-listed and private enterprises in Australia, offering executive search, recruitment, and business transformation. Known for integrity, reliability, and results, our expertise spans Executive Search, Accounting & Finance, Transformation & Change, and Technology & Digital. We connect businesses and top‑tier talent, exceeding expectations and driving lasting impact.