BI Engineer: Data Pipelines & Visualisations

Lidl GB; Greater London; Hybrid; GBP 53,000 - 70,000; Full time

Benefits offered by this job

35 days holiday

10% in-store discount

Enhanced family leave

Pension scheme

London weighting

Job summary

Lidl GB is recruiting a Business Intelligence (BI) Engineer on a 23-month fixed-term contract to join the Head Office Controlling BI team. You will build robust data products, architect data pipelines, and enable trusted reporting across the business with a semantic layer for both technical and non-technical colleagues.

The role offers a hybrid working pattern with a London weighting and benefits including 35 days holiday and a pension scheme.

Qualifications

• Expert-level SQL with advanced queries and optimisation in cloud data warehouses.
• Strong Python skills to build data pipelines and automate processes.
• Experience with cloud environments (GCP) is advantageous.
• Experience reverse-engineering legacy VBA/Excel to modern tech stacks is advantageous.
• Proven track record owning data initiatives from requirements through deployment.

Responsibilities

• Partner with Controlling to engineer trusted data layers for reporting across the business.
• Design and implement ETL/ELT pipelines for complex datasets.
• Develop and optimise data transformations using SQL and Python.
• Define data governance and maintain documentation and version control.

Skills

Advanced SQL

Python

GCP

Legacy Migration

Project Management

Stakeholder Management

Communication

Detail-oriented

Tools

Snowflake

BigQuery

Job description

Lidl GB is recruiting a Business Intelligence (BI) Engineer on a 23-month fixed-term contract to join the Head Office Controlling BI team. You will build robust data products, architect data pipelines, and enable trusted reporting across the business with a semantic layer for both technical and non-technical colleagues.

The role offers a hybrid working pattern with a London weighting and benefits including 35 days holiday and a pension scheme.