Data Engineer - AWS, dbt & Analytics Pipelines

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

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