Data Engineer

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.