Data Engineer

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

Job summary

Snowy Hydro seeks a hands-on Data Engineer to join the Platform Engineering and Data Ops team in Enterprise Data. You will design, build, and test core data pipelines across Bronze-Silver-Gold medallion architecture using Snowflake, with native connectors to SAP and ServiceNow.

In this senior role, you will implement data quality, CI/CD pipelines, and AI-assisted tooling to accelerate development, data modelling, and documentation while ensuring governance and security controls across enterprise

Qualifications

• Deep experience with Snowflake environments and data transformation.
• In-depth knowledge of Medallion architecture (Bronze-Silver-Gold).
• Proven ability to connect and ingest data from SAP and ServiceNow.
• Experience with CI/CD pipelines and data quality tooling.
• Familiarity with AI-assisted coding tools and governance.

Responsibilities

• Design end-to-end Medallion data pipelines (Bronze/Silver/Gold).
• Build and test enterprise data models using Snowflake, Python and SQL.
• Implement data quality, masking, and observability in pipelines.
• Champion CI/CD and automated testing for data products.

Skills

Snowflake

Python

SQL

Data Modeling

CI/CD

Tools

SAP

ServiceNow

Matillion

Git

Copilot

Cursor

Job description

About Snowy:

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. This technical role is responsible for designing, building, and testing core data pipelines across our Enterprise Data Platform.

This is a senior role and will see you 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.

• Senior Experience: As a senior member of the data team, you will mentor and share your knowledge and significant experience with more junior colleagues.

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 your website or to complete your application, please send an email with your request to the Snowy Hydro recruitment team at [e-mail]