Lion

Data Engineer

Lion Sydney, New South Wales, Australia

Food and Beverage Services · 1,001-5,000 employees

Yesterday
data-engineer Mid (2-5 yrs) Full-time Australia
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

You will build and maintain SQL/dbt data pipelines and develop reusable data models to support BI reporting. Additionally, you will collaborate with stakeholders to validate data outputs and ensure the reliability and performance of data infrastructure.

What they look for

SQL Dbt AWS Data Engineering Dimensional Modelling Data Marts BI Reporting Pipeline Development Data Transformation Troubleshooting Production Support Terraform Amazon Redshift Amazon S3 AWS Glue Git

Requirements

The role requires strong SQL and dbt skills along with hands-on experience in AWS data engineering. Candidates should also possess experience in dimensional modelling and a collaborative approach to troubleshooting and production support.

Full description

Our Digital and Technology team are on a journey of transformation at LION. We’re bringing teams together, strengthening our foundations and turning technology, data and AI into commercial impact.

Join LION’s Data Product / DevOps team as a Data Engineer and help shape the pipelines and data models behind our analytics, reporting and data products. You’ll work with the wider team, and insights teams to turn business needs into reliable, reusable data solutions.

WHAT YOU’LL DO

  • Build and improve SQL/dbt transformations and pipelines, with automated tests and clear documentation.
  • Develop reusable data models and data marts that apply business rules and calculate metrics and measures for BI reporting.
  • Work with stakeholders to clarify calculation requirements and validate outputs.
  • Monitor pipeline health, troubleshoot issues and improve reliability, performance and cost efficiency. Fix issues within the data engineering layer and collaborate with other teams on upstream problems.

ESSENTIAL SKILLS

  • Strong SQL and dbt skills, including modular transformations, testing and documentation.
  • Hands-on AWS experience in data or analytics engineering; experience across all AWS services is not required.
  • Experience building data marts using dimensional modelling, including business logic and metric and measure calculations for BI tools.
  • A collaborative, curious approach to troubleshooting and ownership, with an interest in both development and production support.

HIGHLY REGARDED

  • Experience with Amazon Redshift, Amazon S3 and/or AWS Glue. Experience in all three is not required.
  • Terraform experience for infrastructure as code.

NICE TO HAVE

  • Git/GitHub experience for version control and code reviews.
  • Experience collaborating with Power BI reporting teams to agree calculation definitions, validate results and coordinate changes.

WHY LION

Your work will help create data capabilities that teams can trust and use. You’ll take on meaningful engineering challenges, learn through practical delivery and contribute alongside a collaborative data team. If you’re ready to build data foundations with real business impact, we’d love to hear from you.

Similar roles