Data Engineer

LionJob; Sydney; Hybrid; AUD 120,000 - 160,000; Full time

Benefits offered by this job

Growth on tap

Culture you can feel

Flexibility - Hybrid working

Beer and events perks

Job summary

LION is hiring a Data Engineer to build and improve SQL/dbt transformations and pipelines, develop reusable data models and data marts, and collaborate with stakeholders to deliver reliable data solutions for analytics. The role focuses on monitoring performance, troubleshooting issues, and driving cost efficiency within a hybrid Sydney environment.

You’ll work with the Data Product / DevOps teams to turn business needs into scalable data solutions, with exposure to AWS services, Redshift, and

Qualifications

• Strong SQL and dbt skills with modular transformations and documentation.
• Hands-on AWS experience in data/analytics engineering.
• Experience building data marts with dimensional modelling for BI tools.
• Collaborative, proactive approach to troubleshooting and production support.

Responsibilities

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

Skills

Strong SQL

dbt

AWS experience

Data modelling

Tools

Amazon Redshift

AWS Glue

Terraform

S3

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.

ON OFFER:

• Growth on tap- Whether you're deepening your craft or exploring something new, Lion offers real opportunities, not just good intentions
• A culture you can feel - Open, inclusive and down-to-earth. We celebrate wins, learn fast, and look out for each other
• Flexibility – Hybrid working model so you can win in both your work and personal life, you don't have to choose
• Great perks (yes, including the beer) - A bar onsite at our office and access to events and experiences that make working in beer pretty special

We’re a certified B Corp, which means we care about people, planet and purpose—not just profit. We’re committed to diversity, equity and inclusion, and we celebrate the unique perspectives that help us grow and innovate. We intentionally embrace difference and cultivate belonging every day, whether through our investment in our Reconciliation journey through our Innovate RAP, our commitment to gender pay equity or providing progressive people policies.

If you need specific support or accessibility adjustments at any stage of the recruitment process, please let us know at ***************@lionco.com so we can make sure that your recruitment process is fair and we enable you to shine. This includes tailored support for First Nations people, individuals with disabilities, those who are neurodivergent, and people who identify as transgender or gender diverse as we understand the unique challenges and concerns you may face.