Senior Data Engineer: AI-Driven Snowflake on AWS Migrations

Allura Partners; Sydney; Hybrid; AUD 148,000 - 221,000; Part time

Benefits offered by this job

Hybrid working

Competitive day rate

Hands-on AI tooling for migration

Job summary

Allura Partners is seeking a Senior Data Engineer to lead migration and ELT/ETL development on a Snowflake/AWS data platform in Sydney. This 12-month day-rate contract focuses on migrating Teradata, Oracle and SQL Server to cloud, building scalable pipelines and AI-accelerated tooling.

You will mentor engineers, design landing zones, implement CI/CD with Terraform and GitHub Actions, and collaborate with stakeholders to ensure data parity before cutover.

Qualifications

• 7+ years in data and/or cloud engineering with cloud migration experience.

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 into version-controlled pipeline code, using AI tooling to accelerate conversion and mapping.
• Lead data validation, reconciliation and cutover, proving parity before legacy decommissioning.

Skills

Advanced SQL

Python

Data modeling

Stakeholder engagement

Mentoring

Education

AWS Data Engineer Certification

Tools

Snowflake

AWS

dbt

Airflow

Matillion

Fivetran

Qlik Replicate

Terraform

CloudFormation

GitHub Actions

Jenkins

Docker

Job description

Allura Partners is seeking a Senior Data Engineer to lead migration and ELT/ETL development on a Snowflake/AWS data platform in Sydney. This 12-month day-rate contract focuses on migrating Teradata, Oracle and SQL Server to cloud, building scalable pipelines and AI-accelerated tooling.

You will mentor engineers, design landing zones, implement CI/CD with Terraform and GitHub Actions, and collaborate with stakeholders to ensure data parity before cutover.