At a Glance
- Tasks: Transform raw data into reliable products and empower data-driven decisions.
- Company: Join Lidl's innovative Business Intelligence team in a collaborative environment.
- Benefits: Enjoy 35 days holiday, 10% discount, and a pension scheme.
- Other info: Diverse and inclusive workplace with excellent career growth opportunities.
- Why this job: Make a real impact with data while enjoying a hybrid work model.
- Qualifications: Expert SQL and Python skills, plus a proactive mindset.
The predicted salary is between 47250 - 57750 £ per year.
Summary
£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.
Our Head Office Controlling department is looking to recruit a developer to join their Business Intelligence (BI) team on a 23-month fixed term contract.
As a Business Intelligence (BI) Engineer at Lidl, you will be crucial to driving business impact through data integrity, robust architecture and actionable insight.
In this role you will partner with stakeholders across the business to architect and transform raw business data into scalable and reliable data products, which will power intuitive reporting solutions/visualisations.
Through the creation of a trusted semantic layer, you will empower both technical and non-technical colleagues in a fast paced environment to make data driven decisions.
Summary
£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.
Our Head Office Controlling department is looking to recruit a developer to join their Business Intelligence (BI) team on a 23-month fixed term contract.
As a Business Intelligence (BI) Engineer at Lidl, you will be crucial to driving business impact through data integrity, robust architecture and actionable insight.
In this role you will partner with stakeholders across the business to architect and transform raw business data into scalable and reliable data products, which will power intuitive reporting solutions/visualisations.
Through the creation of a trusted semantic layer, you will empower both technical and non-technical colleagues in a fast 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 do
- Partner 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 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 need
- Expert-level SQL: Deep understanding of complex queries, window functions, and query optimisation in cloud data warehouses (Snowflake, Big Query).
- Advanced Python: Proven ability to build data pipelines, 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 receive
- 35 days holiday (pro rata)
- 10% in-store discount
- Enhanced family leave
- Pension scheme
- Plus, more of the perks you deserve
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.
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
- #J-18808-Ljbffr
Business Intelligence Engineer employer: Lidl GB
Lidl is an exceptional employer, offering a competitive salary and a generous benefits package that includes 35 days of holiday and a hybrid working model. Our dynamic work culture fosters collaboration and inclusivity, providing ample opportunities for professional growth while ensuring a supportive environment where every team member can thrive. With on-site amenities like a gym and restaurant, as well as a commitment to diversity and employee well-being, Lidl is the perfect place for those seeking meaningful and rewarding employment in the retail sector.
StudySmarter Expert Advice🤫
We think this is how you could land Business Intelligence Engineer
✨Join Business Intelligence Meetups
We can’t stress enough how beneficial it is to attend local Business Intelligence meetups and events. These gatherings often bring together industry professionals and can lead to short-term, temporary roles—perfect if you’re looking to land something quickly. Plus, you’ll get to learn some insider tips and tricks from those already in the game!
✨Leverage Online Freelancing Platforms
Since you’re searching for a temporary gig, check out freelancing platforms like Upwork or Freelancer where businesses often post short-term BI projects. This can be a great way to build your portfolio and gain experience while also showcasing your skills to potential future employers.
✨Show Off Your BI Projects
Whether you’re working on a personal project or a past endeavour, put your work out there! Create a public portfolio that highlights your best Business Intelligence analyses or visualisations. It’ll give you a leg up when you’re approaching companies like Lidl GB, showing exactly what you can bring to the table.
✨Tap Into University or College Networks
If you're currently studying or recently graduated, make sure to use your university's career services. Many educational institutions have partnerships with companies looking for temporary talent in Business Intelligence, so keep an eye out for exclusive job postings or internship fairs that could lead to a quick placement.
We think you need these skills to ace Business Intelligence Engineer
Some tips for your application 🫡
Show Off Your Data Skills:In business intelligence, it's crucial to highlight your analytical skills and experience with data tools. Make sure your CV showcases any relevant software you’ve used, like SQL, Tableau, or Power BI. Add specific examples of how you've used data to drive insights or improvements in previous roles, even if they were in academic projects or internships.
Keep it Concise and Impactful:For a temporary role like this, hiring managers often have limited time to sift through applications. Get straight to the point in your CV and cover letter. Use bullet points for your achievements, showcasing the impact you've made, like percentage increases in efficiency or specific results from your analyses.
Flexibility is Key:Since this is a temporary position, make sure to emphasise your adaptability. Mention your quick learning abilities and experiences where you adapted to new tools or processes rapidly. This will show that you can jump in and start contributing effectively from day one at Lidl GB.
Craft a Tailored Motivation Statement:In your cover letter, focus on why you’re excited about this temporary role at Lidl GB. Talk about your interest in business intelligence and how this position aligns with your career goals. Remember, it’s not just about what you can offer, but why you’re passionate about becoming part of their team, even for a short time!
How to prepare for a job interview at Lidl GB
✨Brush Up on Your Data Skills
For a business intelligence role, you'll want to showcase your analytical skills and familiarity with data visualisation tools like Tableau or Power BI. Be ready to tackle technical questions or case studies demonstrating your ability to interpret data and make insightful recommendations.
✨Plan Your Portfolio of Projects
Since this is a temporary position, we should highlight any past projects you've worked on in business intelligence. Prepare a portfolio that includes a couple of key pieces where you've effectively utilised data to drive decisions—this will show that you're not just a quick fix but someone who can deliver immediate value.
✨Demonstrate Your Adaptability
Temporary roles often require us to hit the ground running, so be ready to discuss how you quickly adapt to new tools, teams, and environments. Share specific examples from previous experiences where you thrived under pressure or had to learn a new system or process in a short time frame.
✨Have Your Metrics Ready
In business intelligence, quantifying your impact is key. Come prepared to share metrics from your past work: think percentages, growth figures, or efficiency improvements. This will really help us paint a picture of how your contributions directly benefited those previous roles.
