At a Glance
- Tasks: Bridge data engineering and analytics to build scalable data infrastructure and automated workflows.
- Company: Join a global hospitality platform making a meaningful impact.
- Benefits: Enjoy 5 weeks paid vacation, private health insurance, and company-paid therapy sessions.
- Other info: Hybrid role based in London with excellent career growth opportunities.
- Why this job: Shape how data empowers restaurants and diners while working with cutting-edge AI technologies.
- Qualifications: Bachelor's or Master's in a quantitative field with 2+ years in data engineering or analytics.
The predicted salary is between 63000 - 77000 £ per year.
Overview
In this role you will bridge data engineering, analytics, and applied AI to build scalable data infrastructure and automated workflows.
You will work closely with strategy, sales, and operations to reduce friction and deliver AI-powered insights and pipelines.
You’ll develop ETL/ELT processes, AI components, and dashboards that drive faster, data-driven decisions.
This is a hybrid position based in London, offering meaningful impact across a global hospitality platform.
You will shape how Open Table leverages data to empower restaurants and diners at scale.
- Pay / Benefits
- 5 weeks paid vacation
- Private health & dental insurance
- Hybrid work from London with occasional in-office
- Company-paid therapy sessions (Spring Health)
- Headspace subscription
- Annual company-wide week off
Responsibilities
- Partner with cross-functional stakeholders to analyze workflows, identify bottlenecks, and define data model and pipeline requirements
- Design, build, and maintain scalable ETL/ELT pipelines, data models, and automations using Python and SQL to load data into Snowflake
- Develop and integrate AI components (LLM APIs, RAG tools, vector databases) to automate business operations and accelerate decision-making
- Create and manage interactive dashboards and alerts (Superset, Preset) with intelligent insights for KPIs
- Implement validation, monitoring, and security controls for data pipelines and AI outputs
- Evaluate new data orchestration tools (Airflow) and AI frameworks (Lang Chain, Llama Index) to modernize capabilities
- Communicate technical architecture and AI outcomes to non-technical stakeholders and leadership
- Key requirements
- Bachelor’s or Master’s degree in a quantitative field with 2+ years of experience in data engineering, BI, or applied analytics
- Advanced proficiency in SQL and Python
- Hands-on experience with Snowflake and orchestration tools (Airflow)
- Experience with AI APIs (Open AI, Anthropic), vector databases, and RAG architectures
- Proven dashboards and reporting experience (Superset, Micro Strategy, Tableau)
- Strong communication and ability to own projects end-to-end in ambiguous environments
- Proactive
- Curious
- Adaptable
- SQL
- Python
- Snowflake
Business Intelligence Engineer in London employer: OpenTable
OpenTable is an exceptional employer that prioritises employee well-being and professional growth, offering a hybrid work model that balances in-office collaboration with flexibility. With generous benefits such as company-paid therapy sessions, extensive vacation time, and a focus on mental health, employees are empowered to thrive both personally and professionally. The inclusive culture fosters a sense of belonging, making it an ideal place for those looking to make a meaningful impact in the hospitality industry.
StudySmarter Expert Advice🤫
We think this is how you could land Business Intelligence Engineer in London
✨Get to Grips with Data Visualisation Tools
If you're aiming for a full-time role in business intelligence, brush up on your skills with popular data visualisation tools like Tableau or Power BI. Showcasing projects where you've transformed raw data into clear visual insights can give you a real edge.
✨Join Local Business Intelligence Meetups
Look for local business intelligence meetups or analytics conferences in your area. These events are not just great for learning but also for networking with industry professionals who could lead you to opportunities at companies like OpenTable!
✨Engage with Online BI Communities
Join online forums or communities focused on business intelligence—think LinkedIn groups, Reddit threads, or even dedicated Slack channels. Engage actively by sharing your insights and asking questions; this can help you build visibility and connect with potential employers.
✨Leverage Your University’s Career Support
If you're a recent graduate, definitely tap into your university's career services. Many have connections with companies in need of full-time BI specialists, and they can guide you on how to pitch yourself effectively—don't miss out on that!
We think you need these skills to ace Business Intelligence Engineer in London
Some tips for your application 🫡
Highlight Your Analytical Skills:In the business intelligence field, showcasing your analytical skills is a must. Make sure your CV includes relevant experience with data analysis tools, programming languages like SQL or Python, and any projects where you've interpreted complex data sets to drive business decisions.
Showcase Your Business Acumen:Don't just focus on data; show us how you can apply your insights to real-world business problems. Highlight projects where you made a tangible impact on company performance, and be prepared to explain your thought process in your cover letter.
Tailor Your Documents for Us:When applying for a full-time role at OpenTable, tailor your CV and cover letter to reflect our organisational goals and strategies. Mention specific tools and methodologies that align with what we do—this shows you’ve done your homework and are genuinely interested in our mission!
Include Relevant Certifications:Certifications like Google Data Analytics or similar qualifications can really make you stand out in business intelligence. Include these in your application, as they demonstrate your commitment to the field and your willingness to stay current with industry standards.
How to prepare for a job interview at OpenTable
✨Show off your analytical skills
In a business intelligence role, you're going to need to demonstrate your analytical prowess. Be prepared to discuss specific tools you've used, like SQL, Tableau, or Power BI. Have real-world examples ready where you’ve turned data into actionable insights – this is what makes us shine in interviews!
✨Practice your technical know-how
Expect some technical questions during the interview that dive deep into your understanding of data modelling and analytics frameworks. Brush up on your knowledge of data warehousing concepts and be ready to tackle any real case scenarios they might present. They’ll want to see how you approach problems using your BI toolkit.
✨Portfolio of Projects
Since it's a full-time role, having a strong portfolio is key! Compile case studies demonstrating your previous projects, preferably showing how your insights led to business improvements. This can help us display how you think through complex datasets and your problem-solving process, which is what employers are keen on seeing.
✨Know their business model
Get familiar with OpenTable’s business model and recent data-driven decisions. Be prepared to discuss how your skills can specifically support their objectives or challenges. Understanding their landscape shows that you’re not just a data buff, but you’re also genuinely interested in how BI can impact their bottom line.