Data Platform Engineer: Snowflake, AI Pipelines & BI

Sirius.; Sydney; On-site; AUD 130,000 - 180,000; Full time

Job summary

Sirius. in Sydney leads a major Australian retail network's data initiative, building data & AI capabilities from the ground up. This hands-on Data Engineer role sits in a new Data & Insights team, delivering ELT pipelines, models, and analytic foundations for commercial decisions across the national footprint.

You will work with multi-site POS data, ecommerce, and marketing data, bringing them into a governed Snowflake environment and enabling analytics-ready datasets for business decisions.

Qualifications

• 5–8 years of data engineering experience with pipeline delivery and data quality focus.
• Strong SQL and Python; production-grade coding and Snowpark is a plus.
• Snowflake and dbt experience with testing and documentation.
• Master data management or customer data matching experience.
• Experience with Azure Data Factory and ADLS for ingestion/ orchestration.
• Hands-on iPaaS experience and integrations delivery.
• Data quality profiling, validation rules, and DQ monitoring experience.
• Dimensional modeling knowledge (star schemas, Kimball).
• BI data structuring for Power BI; familiar with legacy sources.

Responsibilities

• Build and maintain ELT pipelines from source systems into Snowflake.
• Develop dbt models and adhere to medallion architecture.
• Design dimensional models to support reporting and AI use-cases.
• Support ingestion via Azure Data Factory and ADLS; evaluate iPaaS tools.
• Contribute to AI initiatives and agentic AI workflows.
• Troubleshoot data quality issues and implement validation logic.
• Ensure well-modelled, high-performance datasets for Power BI.
• Configure iPaaS integrations to automate data movement.
• Apply CI/CD, version control, and testing on the data platform.
• Collaborate with data leadership and stakeholders to translate requirements into data products.

Skills

SQL

Python

Snowflake

dbt

Master data management

Azure Data Factory

ADLS

iPaaS

Data quality

Dimensional modelling

Power BI

Git

CI/CD

Agile

Tools

Snowflake

dbt

Azure Data Factory

Power BI

Git

Job description

Sirius. in Sydney leads a major Australian retail network's data initiative, building data & AI capabilities from the ground up. This hands-on Data Engineer role sits in a new Data & Insights team, delivering ELT pipelines, models, and analytic foundations for commercial decisions across the national footprint.

You will work with multi-site POS data, ecommerce, and marketing data, bringing them into a governed Snowflake environment and enabling analytics-ready datasets for business decisions.