Data Engineer
Hands-on Data Engineer on a 12-month fixed-term contract with Snowy Hydro's Platform Engineering and Data Ops team in Sydney, designing, building and testing Medallion (Bronze/Silver/Gold) data pipelines on the Enterprise Data Platform using Snowflake, Python, SQL and Iceberg, integrating SAP/ServiceNow sources with CI/CD, governance and AI-assisted engineering.
- Compensation
- Not disclosed
- Location
- Australia
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Contract
- Experience
- Not specified
- Category
- Data engineering
- Posted
Skills
Must have
- Deep hands-on experience in Snowflake environments (virtual warehouse optimisation, performance tuning)
- Expert-level proficiency in Python and SQL for data transformation and modelling
- Proven track record constructing Medallion architecture layers (Bronze, Silver, Gold)
- Setting up native connectors to ingest raw data from core enterprise systems such as SAP and ServiceNow
- Experience deploying data models through staging and production using Git and automated CI/CD pipelines
- Embedding data quality validations, pipeline observability, and automated alerting
- Practical experience using AI coding assistants with prompt context, rules, and governance guardrails
- Strong business acumen to translate business goals into relevant and compliant data models
Nice to have
- Knowledge of Matillion (beneficial but not mandatory)
- Background in a fast-paced or regulated industry such as Financial Services, Energy, or Utilities
Full 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.
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.