Data Engineer: Pipelines & Data Modeling (AWS)

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

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.