Job Description
Senior Data Engineer (Snowflake, AWS) | 12-Month Day Rate Contract | Sydney About the Company n
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 n
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 n
n
Competitive day rate on a 12-month contract, with high chance of extension
n
Hybrid working
n
Hands-on work applying generative AI to real migration challenges at enterprise scale
n
Genuine input into architecture, migration strategy and wave prioritisation
n
A high-profile transformation program with solid visibility across the business
n
Duties / Key Responsibilities n
n
Design and build the AWS data engineering capability for the program, including landing zone, ingestion frameworks and migration tooling
n
Build scalable ELT/ETL pipelines into Snowflake covering bulk historical loads, CDC and incremental replication
n
Convert legacy warehouse logic (BTEQ, PL/SQL, T-SQL, stored procedures) into version-controlled pipeline code, using AI tooling to accelerate conversion and mapping
n
Lead data validation, reconciliation and cutover, proving parity before legacy decommissioning
n
Automate deployment through Terraform, CloudFormation and GitHub Actions, and mentor engineers across DevOps and DataOps practices
n
Skills and Experience n
n
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
n
Proven hands-on delivery of large-scale migrations from Teradata, Oracle and/or SQL Server into a cloud data platform
n
Deep experience with AWS data services including S3, Glue, Lambda, Step Functions, DMS, EMR, Kinesis/MSK, Athena, IAM, KMS and MWAA
n
AWS certification (Data Engineer Associate, Solutions Architect or DevOps Engineer)
n
Advanced SQL and Python, with orchestration and ELT tooling such as dbt, Airflow, Matillion, Fivetran or Qlik Replicate
n
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
n
Strong dimensional modelling knowledge, including data vault or medallion architectures and source-to-target mapping
n
Infrastructure-as-code, CI/CD and containerisation experience (Terraform, CloudFormation, GitHub, Jenkins, Docker)
n
Production support across batch and streaming workloads, with observability tooling (Splunk, DataDog, CloudWatch) and ITIL incident management
n
Excellent stakeholder engagement and communication skills, with a track record of mentoring engineers
n
n
Kaio is recruiting for this role on behalf of Allura Partners.
About Allura Partners n
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.
n
#J-*****-Ljbffr

📌 Senior Data Engineer (Snowflake, Aws) | 12-Month Day Rate Contract | Sydney (New South Wales)
🏢 Allura Partners
📍 New South Wales