Hospitality, Software, Internet, E-commerce

Business Intelligence Engineer

LondonOnsiteFull TimePosted 1 month ago

Is this role right for you?

Upload your resume and get a skill-by-skill breakdown — see exactly where you match, where you're close, and what to highlight. Not a mystery percentage.

Get a tailored resume highlighting what this role needs.

Required skills

SQL
Python
Snowflake
ETL
ELT
OpenAI
Anthropic
RAG
Vector Databases
Agentic Workflows

Nice to have

Airflow
MicroStrategy
Tableau
applied analytics
system integration
data orchestration tools

Role summary

OpenTable is seeking a Business Intelligence Engineer to join their team in London. Reporting to the Manager, Business Intelligence, this hybrid role sits at the intersection of data engineering, analytics, and applied AI. You will build data infrastructure, intelligent workflows, and automated systems, collaborating with strategy, sales, and operations teams. Responsibilities include designing and building scalable ETL/ELT pipelines and data models using Python and SQL with Snowflake, integrating applied AI components like LLM APIs and RAG pipelines, and creating interactive dashboards with tools like Superset. The role requires advanced proficiency in SQL and Python, hands-on experience with cloud data warehouses, and familiarity with modern AI technologies. A Bachelor's or Master's degree and 2+ years of relevant experience are required.

Turn data into decisions. Build intelligent solutions. Make complexity disappear.

With millions of diners, 70,000+ restaurant partners and 25+ years of experience, OpenTable, part of Booking Holdings, Inc. (NASDAQ: BKNG), is an industry leader with a passion for helping restaurants thrive. Our world-class technology empowers restaurants to focus on what matters most – their team, their guests, and their bottom line – while enabling diners to discover and book the perfect restaurant for every occasion.

Every employee at OpenTable has a tangible impact on what we do and how we do it. You’ll also be part of a global team and its portfolio of metasearch brands. Hospitality is all about taking care of others, and it defines our culture.

A little about the role...

We're looking for a Business Intelligence Engineer who thrives at the intersection of data engineering, analytics and applied AI. Someone who can build robust data infrastructure, develop intelligent automations and turn complex business challenges into scalable, practical solutions. At OpenTable, data does more than tell us what happened. It helps us understand what comes next, uncover opportunities and build smarter ways of working.

This isn't a traditional BI role focused solely on reporting and dashboards. You'll have the opportunity to shape how we use data, AI and automation across the business, working closely with stakeholders to solve meaningful problems and deliver measurable impact.

What You'll Do...

Build scalable data infrastructure: Design, develop and maintain reliable data pipelines, ETL/ELT processes and data models that support analytics and business operations.

Develop AI-powered solutions: Apply modern AI technologies and APIs to build intelligent workflows, automate processes and solve real business challenges.

Turn data into actionable insights: Create analytical tools, reporting solutions and automated systems that improve decision-making, efficiency and business performance.

Partner with stakeholders: Collaborate with technical and non-technical teams to gather requirements, understand challenges and translate business needs into effective technical solutions.

Own solutions end to end: Lead projects from discovery and design through development, deployment and optimisation, ensuring solutions are scalable, reliable and maintainable.

Our Ideal Candidate...

Proven programming expertise: Hands-on experience with Python and SQL, including developing data pipelines, integrations and automated workflows.

Modern data engineering experience: Proficiency with Snowflake or similar cloud data warehouses, alongside data modelling, ETL/ELT processes and orchestration tools such as Apache Airflow.

Practical applied AI knowledge: Experience integrating modern AI APIs, large language models (LLMs) or AI-powered technologies into business applications and workflows.

Excellent stakeholder management: Proven ability to gather requirements, challenge assumptions and communicate complex technical concepts clearly to non-technical audiences.

A solutions-focused mindset: Strong analytical and problem-solving skills, with the ability to independently navigate ambiguity, prioritise effectively and deliver reliable, commercially valuable solutions.

Nice to Have...

Experience with advanced AI techniques such as retrieval-augmented generation (RAG), embeddings, vector databases or AI agent workflows.

Familiarity with cloud platforms such as AWS, GCP or Azure.

Experience with analytics engineering tools such as dbt, alongside Git, CI/CD or modern software development practices.

Previous experience in a technology-led marketplace, SaaS, hospitality, travel or e-commerce environment.

A track record of delivering AI, data or automation initiatives that have resulted in measurable operational improvements.

What We Can Offer...

5 weeks paid vacation

Private health & dental insurance

Work from (almost) anywhere for up to 20 days per year

Focus on mental health and well-being:

Company-paid therapy sessions through SpringHealth

Company-paid subscription to Headspace

Annual company-wide week off a year - the whole team fully recharges (and returns without a pile-up of work!)

Paid parental leave

Time off for your birthday

Paid volunteer time

Focus on your career growth:

Development Dollars

Leadership development

Access to thousands of on-demand e-learnings

Travel Discounts

Employee Resource Groups

Income protection and life assurance

Employee Assistance Program - including 24/7 GP & free legal advice

Pension plan contributions

Discounted gym membership

Bike2Work

Season ticket loan

Social events & Thursday happy hours

Free lunch 2 days per week

The best connections happen face-to-face, whether you’re sitting down to dinner or having coffee with a coworker. That’s why OpenTable has adopted a hybrid workplace model. This role aligns with that approach, with an expectation of coming into the office two days a week - giving employees the best of both worlds: in-person collaboration and flexibility.

Work Environment & Flexibility

At OpenTable, we pride ourselves on fostering a global and dynamic work environment. As a team member with us, you will benefit from a schedule tailored to accommodate a global workforce operating across multiple time zones. While the majority of your responsibilities may align with conventional business hours, there will be instances where you are expected to manage communications - via calls, Slack messages, or emails - outside of regular working hours to effectively collaborate with international colleagues, respond to restaurant partners, and/or address urgent matters. OpenTable will always abide by and consider local laws and regulations.

Inclusion

We’re committed to creating a workplace where everyone feels they belong and can thrive. We know the best ideas come when we bring different voices to the table, so we're building a team as dynamic as the diners and restaurants we serve - and fostering a culture where everyone feels welcome to be themselves.

If you need any reasonable adjustments during the application/interview process, or on the job, we’re here to support you. Please reach out to your recruiter to request any accommodations.

Sample OpenTable interview questions

1
What strategies would you employ to handle seasonal variations and new types of fraud in your detection system?
system designmedium
2
Decode Ways Determine the number of valid ways to decode a string of digits. Input: s = "10" Output: 1 Explanation: The string can only be decoded one single way, as the sequence '10' maps exclusively to the letter 'J'.
codingmedium
3
Add Two Numbers Represented as Strings Add two non-negative integers represented as strings. Input: num1 = "456", num2 = "77" Output: "533" Explanation: Performs character-by-character addition from right to left, carrying the 1 from 6+7=13 to the next decimal place.
codingmedium
4
Pacific and Atlantic Water Flow Calculate water flow from a matrix to the Pacific and Atlantic oceans. Input: heights = [[2,1],[1,2]] Output: [[0,0],[0,1],[1,0],[1,1]] Explanation: All cells can flow to both oceans because water can move to adjacent cells of equal or lower height or directly off the edges.
codingmedium
5
Merge a New Interval Merge a new interval into a list of non-overlapping intervals. Input: intervals = [[1,2],[3,5],[6,7],[8,10],[12,16]], newInterval = [4,8] Output: [[1,2],[3,10],[12,16]] Explanation: The new interval overlaps with [3,5], [6,7], and [8,10], merging them all into the unified block [3,10].
codingmedium

Get started to unlock a personalized interview prep pack for this role.

Ready to apply?

You'll be redirected to OpenTable's application page.