Spotlight Ltd

Senior Data Engineer (Snowflake, dbt, SQL)

Spotlight Ltd  •  Commonwealth of Australia (Onsite)  •  2 hours ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

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.

Spotlight Ltd

About Spotlight Ltd

Spotlight is a proudly Australian family-owned and operated business with stores throughout Australia, New Zealand and Asia. We employ more than 6,700 team members who are dedicated to providing the best quality, service, price and expertise in fabrics, craft and homewares to our millions of customers every day.

Spotlight’s founders gained their passion for retail by working at their family stall at Melbourne's Queen Victoria Market in the early 1970's. Their strong drive and business acumen led them to opening their first Spotlight store in Malvern in September 1973 and the brand has grown from strength to strength ever since.

Spotlight has over 130 stores across Australia, New Zealand, Malaysia and Singapore, with hundreds of brands and thousands of products to choose from across departments including dress fabrics, haberdashery, manchester, home décor, party, art and craft and furnishings covering all aspects of DIY, made to measure and readymade options for your hobbies and home.

When you head into a Spotlight store you can find almost everything you need to kit out your home. From kitchen and dining spaces, lounge and bedrooms, bathrooms and laundries, they are all covered by the range we stock. Our ranges of fabrics, haberdashery and craft gives you the option of updating your wardrobe quickly, or updating your home’s curtains and blinds easily as well! Our party section can provide you with all of the baking, decorating and dress up products you need to ensure your next celebration is a success!

At Spotlight, we truly believe “it’s what you make it!” whether that is your home, your latest hobby, your outfit or even your party!

Spotlight is one of the brands within the Spotlight Retail Group, alongside other retailers Anaconda, Mountain Designs and Harris Scarfe. With over 8,500 team, the group spans four countries and over 4.2 million square feet of retail space.

Want to join the family? Head to our careers site or follow us here on LinkedIn.

Industry
Retail & Ecommerce
Company Size
201-500 employees
Headquarters
South Melbourne, AU
Year Founded
Unknown
Social Media