Business Intelligence VBA Developer

at  Lidl

Summary
£49,500* up to £66,000 per annum* | 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 proactive, reliable and ready to take on any challenge.
Just like you
The process will include a VBA test, video interview and face-to-face Interview at our Head Office in Surbiton, Surrey. We look forward to receiving your application.
Our Head Office Controlling Department is looking to recruit a VBA specialist as a Business Analyst into their Business Intelligence team. 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.
As a Business Intelligence Analyst at Lidl your input will be crucial in driving business impact through data and insight. The Business Intelligence function is tasked to support the whole business; therefore, you’ll be expected to work on diverse projects, which will impact decision making across the entire business.
In return, we’ll give you a competitive salary based on equal opportunity and pay structures, as well as a generous benefits package designed to support your well-being and life outside of Lidl.
We’re proud to be a diverse, secure and fast-growing business, so we’ll make sure you have access to the right training and real opportunities to build your career as well.
‘To keep in line with company structure this role will be called Controlling Consultant internally’

What you’ll do

• Work with our Controlling colleagues to provide support for all national departments by generating targeted reporting and analysis.
• Developing, testing, and implementing solutions such as reporting or tooling, to provide the business with the ability to gain insight from data.
• Gather, transform, and analyse data from various sources, both internal and external to create new insight.
• Utilise statistical methods to create predictive models as well as identify patterns and trends in data.
• Preparing and delivering solutions to effectively communicate trends and develop forecasts to the business.
• 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 VBA essential
• Knowledge of Python and/or SQL desirable
• Curious, self-motivated, and proactive individual with a can-do attitude
• The ability to work on projects and solve problems independently
• Experience of project and stakeholder management
• The 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
• Sabbatical
• Enhanced family leave
• Pension scheme

Plus, more of the perks you deserve
You’re Lidl like us. 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.

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.

• Includes 10% non-contractual London Weighting

Please note your employment is conditional upon the Company’s receipt of satisfactory references and if requested by the Company, a satisfactory Disclosure and Barring Service check.
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 disappointmen

• Work with our Controlling colleagues to provide support for all national departments by generating targeted reporting and analysis.
• Developing, testing, and implementing solutions such as reporting or tooling, to provide the business with the ability to gain insight from data.
• Gather, transform, and analyse data from various sources, both internal and external to create new insight.
• Utilise statistical methods to create predictive models as well as identify patterns and trends in data.
• Preparing and delivering solutions to effectively communicate trends and develop forecasts to the business.
• 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