About this role
About the role We are partnering with a major Australian multi-site retail and franchise network as they build their data and AI capabilities from the ground up. This is a hands-on Data Engineer role within a newly formed Data & Insights team, responsible for building and maintaining the pipelines, models, and reporting foundations that power commercial decision-making across a massive national footprint. You'll work directly within the central Digital, Data, and Technology team, helping bring data from multi-site point-of-sale systems, ecommerce, and marketing platforms into a governed Snowflake environment, turning raw information into trusted, analytics-ready datasets for the wider business. What you'll be doing Build and maintain ELT pipelines bringing data from source systems (including legacy ERPs/iSeries, enterprise ecommerce, and marketing platforms) into Snowflake. Develop and maintain dbt models following a medallion architecture and strict modelling conventions. Design and build dimensional models (e.g., customer, product, location, and inventory dimensions, plus related fact tables) to support reliable reporting and future AI use-cases. Work with Azure Data Factory and ADLS for ingestion pipelines and support the evaluation and implementation of iPaaS tooling. Contribute to AI initiatives across the business, including the integration of LLM solutions (Claude, ChatGPT, Gemini) and support the design of agentic AI workflows that extend platform capabilities. Troubleshoot data quality issues at the source (nulls, inconsistent keys, duplicates) and build robust validation and cleansing logic. Support Power BI reporting by ensuring datasets are well-modelled, highly performant, and documented. Configure iPaaS integrations to connect operational syst...