Senior Data Engineer (Snowflake, dbt, SQL)
- Hiring from
- Australia
- Work type
- Hybrid
- Posted
623,481 remote jobs, straight from company career pages
100% free · New jobs every minute
Show job descriptionHide job description
- Build scalable on Snowflake, using dbt, AWS services such as Glue, Airflow and enable reporting/analytics, AI enablement across iconic retail brands
- Hybrid South Melbourne role with competitive rewards and profit share
- High-impact role supporting enterprise data modernisation
About the Role
Spotlight Retail Group is seeking a hands-on Senior Data Engineer to build scalable, business-ready solutions across our Enterprise Data Warehouse. Supporting Spotlight, Anaconda and Harris Scarfe, you will deliver robust ELT pipelines, dimensional models and semantic layers that enable trusted self-service analytics and operational decision-making.
This role suits an experienced engineer who combines strong Snowflake and dbt capability with practical data modelling, stakeholder engagement and a delivery-focused mindset.
What You'll Be Doing
Data Engineering & Transformation
- Snowflake: Design, build and optimise warehouse solutions, data models, queries and compute performance.
- dbt & ELT: Develop modular, tested pipelines across staging, intermediate and mart layers using dbt Core.
- Cloud Integration: Integrate Snowflake and dbt with AWS Glue, S3 and orchestration tools such as Airflow.
- Engineering Practice: Apply advanced SQL, Git source control and CI/CD practices to deliver reliable data products.
Data Modelling & Analytics Enablement
- Dimensional Modelling: Build EDW and Power BI models using Kimball and star schema principles.
- Multi-Brand Design: Define unified models across Spotlight, Anaconda and Harris Scarfe, with pragmatic brand-specific designs where required.
- Quality & Security: Implement testing, reconciliation, data-quality controls and row-level security.
- Documentation: Produce concise conceptual, logical and technical designs and address performance or usability issues.
Stakeholder Partnership
- Power BI: Develop and optimise semantic models, dashboards and reports using DAX and Power Query.
- Collaboration: Lead workshops, clarify requirements and translate complex engineering concepts into practical business outcomes.
What We're Looking For
- 4-5 years of hands-on Snowflake experience, including data modelling, warehouse design and performance tuning.
- 2-3 years using dbt, including dbt Core, to build and test modular transformation pipelines.
- 1-2 years delivering Power BI semantic models and reports, with strong DAX and Power Query capability.
- Advanced SQL and strong experience with EDW, Kimball dimensional modelling and star schemas.
- Practical experience with AWS Glue, S3, Airflow or similar, Git and CI/CD.
- Retail domain experience and delivery experience across data migration, EDW modernisation or large data platforms. Consulting experience and Snowflake or Power BI certification are desirable.
Why Join Spotlight Retail Group?
- Hybrid flexibility: Work from home and our South Melbourne office, with a minimum three days onsite.
- Competitive rewards: Attractive base salary, superannuation and profit-share eligibility.
- Benefits: Team discounts across Spotlight, Anaconda, Mountain Designs and Harris Scarfe, plus wellbeing support.
- Impact and growth: Contribute to a major Australian retail group and grow across a diverse brand portfolio.
How to Apply
Click Apply Now to submit your current resume and complete our brief online application.
Unrestricted Australian working rights are required. Only shortlisted candidates will be contacted. No recruitment agency enquiries please.