Business intelligence (bi) analyst

Business Intelligence Analyst - Head Office

Location: London

Salary: £52,800

• up to £70,400 per annum | 23-month Fixed Term Contract | 35 days' holiday (pro rata) | 10% in-store discount | Pension scheme

Everyone who works at Lidl brings something unique to the table - but we also have a whole lot in common. We’re curious, collaborative, and ready to make a tangible impact on where we work. As a Business Intelligence (BI) Analyst at Lidl your input will be crucial in driving business impact through data and insight. Our Head Office Controlling Department is looking to recruit an analyst to join their Business Intelligence team on a 23-month fixed term contract. In this role you will support internal stakeholders and senior management by delivering outstanding insight to generate business value that exceeds stakeholder expectations. If you are excited to help build something new, with the support of the world’s fourth‑largest retailer, we’d love to hear from you. The Business Intelligence function is tasked to support the whole business; therefore, you should expect to work on diverse projects, which will impact decision making across the entire business. In this role, you will also be working closely with our Data Science and Management Accounting teams who are co‑located in our office in south‑west London. 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. Please be aware, should this temporary assignment have the potential to go permanent, the colleague on the temporary assignment will have first‑refusal of the role (provided measures have been met).

What you’ll do

• Work with our colleagues in Controlling to provide support for all national departments, generating trusted data views to support reporting and analysis.
• Develop, test and implement solutions that provide the business with the ability to gain insight from the data.
• Gather, manipulate and analyse data from various sources, both internal and external, to create new insights.
• Define and support governance for new methods of data retrieval through documentation and training of processes.
• Provide innovative reporting solutions including process improvements and automation.
• Manage your own projects end‑to‑end: defining requirements, conducting test cases, demonstrating value, and supporting implementation/adoption.
• Communicate effectively with non‑technical colleagues across the business to ensure understanding and trust in our solutions and insights.
• Take responsibility for achieving high technical standards so that your solutions are appropriate, comprehensible, well‑structured, and reproducible.

What you’ll need

• Advanced knowledge of SQL is essential
• Knowledge of Python and/or VBA desirable
• Curious, self‑motivated, and proactive individual with a can‑do attitude
• Ability to work on projects and solve problems independently
• Experience of project and stakeholder management
• Ability to liaise and communicate at both a technical and non‑technical level
• Keen eye for detail and good quality control
• Ability to work to tight deadlines and to deliver accurate results
• Excellent presentation and communication (written and verbal) skills
• Ability to work well in a team

What you’ll receive

• 35 days holiday (pro rata)
• 10% in‑store discount
• Enhanced family leave
• Pension scheme
• Plus, more of the perks you deserve
• Includes a 10% non‑contractual London weighting

We value diversity, 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. Once a vacancy has closed, we are unable to consider further applications, so please submit your application as soon as possible to avoid disappointment.