Data Engineer

Lion; Sydney; On-site; AUD 120,000 - 180,000; Full time

Job summary

Lion’s Data Product / DevOps team is seeking a Data Engineer to shape pipelines and data models powering analytics, reporting and data products. You will collaborate with insights teams to translate business needs into reliable data solutions.

The role emphasizes building scalable data transformations, data marts and production-grade pipelines, with an eye on performance and cost efficiency. You’ll engage across stakeholders to ensure accurate metrics and robust data delivery.

Qualifications

• Strong SQL and dbt skills with testing and documentation.
• Hands-on AWS experience in data/analytics engineering.
• Experience building data marts using dimensional modelling for BI.
• Collaborative approach with ownership in development and prod support.

Responsibilities

• Build and improve SQL/dbt transformations and pipelines with tests and documentation.
• Develop reusable data models and data marts for BI reporting.
• Clarify calculation requirements with stakeholders and validate outputs.
• Monitor pipeline health and improve reliability, performance and cost efficiency.

Skills

SQL

dbt

AWS

Data modelling

Collaboration

Tools

Amazon Redshift

Amazon S3

AWS Glue

Terraform

Power BI

Job 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.