> Markdown version of [/jobs/ext/3082970-business-intelligence-bi-engineer](https://www.wearedevelopers.com/jobs/ext/3082970-business-intelligence-bi-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Business Intelligence (BI) Engineer - **Company:** Lidl - **Location:** Birmingham, UK - **Salary:** £52,800.0 - £70,400.0 - **Contract:** Temporary contract - **Skills:** BigQuery, Cloud Computing, Cloud Database, Data Governance, Extract Transform Load (ETL), Data Retrieval, Database Queries, Excel Macros, Python (Programming Language), Query Optimization, Reverse Engineering, SQL Databases, Working Model 2D, Cloud Platform System, Sql Optimization, Snowflake, Data Layers, Vba Programming Language, Software Version Control, Data Pipelines - **Published:** September 26, 2026 - **Apply:** https://bfrss.org.uk/profiles/companies/1298902//?show=2000242&showtype=VAC ## About the Role paced environment to make data driven decisions. This is a highly visible business intelligence function where stakeholder engagement, project ownership and the ability to converse both technically and non-technically are as important as your technical development skills. At Lidl, we offer a hybrid working model to give you the best of both worlds. Spend three days or more in our state-of-the-art office, where you can enjoy an on-site gym, restaurant, and more of the perks you deserve. And with up to two days at home, you'll find the work/life balance you need to thrive. To keep in line with company structure, this role will be called Consultant internally. What you'll doPartner with colleagues in Controlling to provide support for all national departments, by engineering trusted data layers which will power reporting and analysis across the business. Design and implement ETL/ELT pipelines to extract, clean and structure complex datasets into reliable products. Develop and optimise, automate processes, and manipulate data programmatically. Cloud Infrastructure: Experience working within cloud environments (GCP) is highly advantageous. Legacy Migration: Some experience of understanding and reverse-engineering legacy VBA/Excel macros to migrate them into modern tech stack is advantageous. Project Management: Proven experience owning data initiatives from requirement gathering through to deployment and monitoring. Communication & Stakeholder Management: Exceptional written and verbal skills, with experience in bridging the gap between business needs and technical execution. A curious, proactive mindset with a keen eye for detail, quality control, and scalable system design. Ability to work both independently on complex technical challenges and collaboratively within a cross-functional team. What you'll receive35 days holiday (pro rata) 10% in-store discount Enhanced family leave Pension scheme Plus, more of the perks you deserve We value diversity ## Description complex data transformations using advanced SQL (Snowflake and Big Query) and Python. Define and implement data governance best practices for new methods of data retrieval, ensuring data quality, version control and comprehensive technical documentation. Modernise legacy processes by identifying opportunities for process improvements through automation and migration to a modern tech stack. Ensure that our back-end data models are aligned and optimised for BI visualisations. Manage data projects end-to-end: defining requirements, designing the architecture, conducting UAT and driving implementation\adoption. Communicate effectively with non-technical colleagues across the business to ensure understanding and build trust in our data products and reporting solutions. What you'll needExpert-level SQL: Deep understanding of complex queries, window functions, and query optimisation in cloud data warehouses (Snowflake, BigQuery). Advanced Python: Proven ability to build data pipelines, equity, and inclusion, welcoming applicants from all backgrounds. Join us to celebrate individuality and grow in a fair, respectful, and inclusive environment. Disclaimer: due to the high volume of applications we receive, we reserve the right to close a vacancy earlier than the advertised date. This is to ensure our teams can manage application levels while maintaining a positive candidate experience. Once a vacancy has closed, we are unable to consider further applications, so please submit your application as soon as possible to avoid disappointment. *Includes a 10% non-contractual London weighting If you're ready to get stuck in, want to get more out of your career and make a real difference, find your place at Lidl and apply now. ## Related Videos - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) - [Why Your AI Agent Keeps Hallucinating Your Data: Building Deterministic Context Layers](https://www.wearedevelopers.com/videos/2055-why-your-ai-agent-keeps-hallucinating-your-data-building-deterministic-context-layers) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Data Governance in the Era of AI](https://www.wearedevelopers.com/videos/1622-data-governance-in-the-era-of-ai) ## Related Articles - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [The Biggest German Tech Companies](https://www.wearedevelopers.com/magazine/424-the-biggest-german-tech-companies) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [UK Business Culture and Etiquette](https://www.wearedevelopers.com/magazine/326-uk-business-culture-and-etiquette)