Data Engineer

Lumea; Sydney; On-site; AUD 140,000 - 190,000; Full time

Job summary

Snowy Hydro in Sydney is seeking a hands-on Data Engineer to join the Platform Engineering and Data Ops team on a 12-month fixed-term contract. You will design, build and test core data pipelines across the Enterprise Data Platform using Snowflake, Python and SQL.

The role focuses on implementing Medallion architecture (Bronze, Silver, Gold) and building native integrations with SAP and ServiceNow, while embedding data quality, CI/CD and AI-assisted coding practices.

Qualifications

• Hands-on Snowflake data engineering experience.
• Proven ability to design Medallion architecture (Bronze, Silver, Gold).
• Experience with SAP and ServiceNow data connectors.
• CI/CD for data models using Git and automation.
• AI-assisted coding and governance guardrails.

Responsibilities

• Build end-to-end Medallion data pipelines (Bronze-Silver-Gold).
• Design and deploy Snowflake-native data models using Python/SQL.
• Implement data quality, masking, and observability with automated tests.
• Develop AI-assisted coding practices and documentation.
• Collaborate with Data Governance and Analytics teams.

Skills

Snowflake pipelines

Python

SQL

CI/CD pipelines

Data modeling

Data governance

AI-assisted coding

APIs and data integration

Tools

Snowflake

Matillion

SAP

ServiceNow

Git

Copilot

Cursor

Job description

Snowy Hydro is a dynamic, integrated energy business that has been providing on-demand, reliable energy to Australia for generations. Snowy Hydro owns and operates a powerful combination of generation assets, including the mighty Snowy Mountains Scheme, gas and diesel plants, and contracted wind and solar energy.

We also provide electricity and gas to over 1.5 million retail customers through our retail brands Red Energy and Lumo Energy. Snowy 2.0 is Australia's largest committed renewable energy project. This nation-building project will provide on-demand energy and large-scale storage for many generations to come.

About the position:

We are seeking a hands-on Data Engineer to join our Platform Engineering and Data Ops team in our Enterprise Data function on a 12-month fixed-term contract. This technical role is responsible for designing, building, and testing core data pipelines across our Enterprise Data Platform.

In this role, you will focus on implementing Medallion architecture using Snowflake. You will build native integrations for core enterprise systems like SAP and ServiceNow, embed modern data quality, testing, and CI/CD deployment practices, while leveraging AI-assisted coding agents (e.g., Copilot, Snowflake native AI capabilities, Cursor) to accelerate development, data modeling, and documentation

Key Responsibilities:

Medallion Architecture & Data Ingestion: Build end-to-end Medallion pipeline architecture (Bronze, Silver, Gold), utilising open data formats such as Iceberg. Design and implement resilient native pipelines to connect into core enterprise systems, including SAP and ServiceNow. Collaborate closely with Data Governance, Data Architecture, and Reporting & Analytics teams to translate business intent into reusable data assets.

Data Modeling & CI/CD Production: Design, build, and test enterprise-grade data models using Snowflake-native capabilities, Python and SQL. Manage the end-to-end lifecycle of moving data models from development through testing into production using automated CI/CD pipelines.

Data Governance, Privacy & Pipeline Standards: Implement data quality validations, dynamic security controls, masking, and pipeline observability with automated alerting for failure detection. Develop automated unit, integration , and regression tests for data pipelines.

AI-Assisted Engineering & Innovation: Using AI coding agents (e.g. GitHub Colpilot, Cursor, Snowflake native AI features) with appropriate guardrails, prompt context, and rules to accelerate code wiring, data modelling, unit testing, and documentation generation.

About the location:

This role is based in Sydney.

About you:

Snowflake & Core Engineering Expertise: Deep hands-on experience in Snowflake environments (virtual warehouse optimisation, performance tuning) with expert level proficiency in Python and SQL for data transformation and modelling. Knowledge of Matillion is beneficial but not mandatory.

Enterprise Source Integration & Architecture: Proven track record of constructing Medallion architecture layers (Bronze, Silver, Gold) and setting up native connectors to ingest raw data from core enterprise systems such as SAP and ServiceNow.

CI/CD, Governance & Observability: Hands-on experience deploying data models through staging and production using Git and automated CI/CD pipelines, whilst embedding data quality validations, pipeline observability, and automated alerting.

AI Guardrails & Tooling: Practical experience using AI coding assistants to build, test and document data models, along with the ability to define prompt context, rules, and governance guardrails.

Business Acumen & Industry Experience: Strong business acumen to understand domain context, translate business goals into relevant and compliant data models, and ensure end-to-end utility. Background in a fast-paced or regulated industry (such as Financial Services, Energy, or Utilities) is highly regarded.

About our workforce:

Snowy Hydro has a culture of decency and inclusion, with a commitment to the health and wellbeing of our people and a supportive environment to ensure that everyone - regardless of background - feels included and can succeed. At Snowy Hydro, we recognise that we are made stronger by the unique capabilities and qualities that each individual brings, and we believe in providing an environment that allows that uniqueness to thrive.

Snowy Hydro is proud to be an Equal Opportunity employer. We are committed to the values of Equal Employment Opportunity and provide accessibility accommodations to applicants with physical and/or mental disabilities. If you are interested in applying for a role with Snowy Hydro and are in need of accommodation or special assistance to navigate our website or to complete your application, please send an email with your request to the Snowy Hydro recruitment team at [e-mail]