Business Intelligence Engineer

Reporting to the Manager, Business Intelligence, this position sits at the intersection of data engineering, analytics, and applied AI, building data infrastructure, intelligent workflows, and automated systems across OpenTable. The role collaborates cross-functionally with strategy, sales, and operations teams to identify operational friction points and deliver scalable solutions - ranging from analytics dashboards and ETL pipelines to production-ready AI tools, RAG pipelines, and automated action triggers.

The Business Intelligence Engineer is expected to deeply understand OpenTable’s systems and data architecture, combining strong business acumen with technical execution. This position requires an analytical mindset, proactive problem-solving, and the ability to articulate complex technical concepts to non-technical business partners while delivering results in ambiguous environments., * Business-First Problem Discovery: Partner with cross-functional stakeholders (sales, strategy, operations) to analyze workflows, identify recurring manual bottlenecks, and define requirements for data models, automated pipelines, and AI-driven solutions.

• Data & AI Infrastructure Development: Design, build, and maintain scalable ETL/ELT pipelines, data models, and custom automations using Python and SQL to extract, transform, and load data into Snowflake.
• AI & Workflow Automation: Build and integrate applied AI components - including LLM API integrations (OpenAI/Anthropic), retrieval-augmented generation (RAG) tools, vector databases, and agentic workflows - to automate business operations and accelerate decision-making.
• Dashboards & Intelligent Insights: Create and manage interactive dashboards and visualizations (Superset, Preset) integrated with automated alert triggers and intelligent insight generation for key business metrics.
• Testing, Quality Control & Security: Implement validation, evaluation, and monitoring frameworks to ensure the accuracy, reliability, security, and compliance of both traditional data pipelines and AI model outputs.
• Tool Evaluation & Modernization: Continually evaluate emerging data orchestration tools (e.g., Airflow), AI frameworks (LangChain, LlamaIndex), and modern data sources to enhance overall analytics team capabilities.
• Stakeholder Communication: Clearly articulate technical architecture, pipeline logic, and AI-driven outcomes to non-technical business partners and leadership.

• Education & Experience: Bachelor’s or Master’s degree in Computer Science, Statistics, Data Science, Information Systems, Economics, or a related quantitative field, with 2+ years of hands-on experience in data engineering, business intelligence, or applied analytics.
• Core Technical Stack: Advanced proficiency in SQL and Python for data processing, system integration, API development, and data modeling.
• Cloud & Data Architecture: Hands-on experience with cloud data warehouses (Snowflake) and data orchestration frameworks (e.g., Airflow or similar ETL tools).
• Applied AI & Automation Skills: Familiarity with modern AI APIs (OpenAI, Anthropic), vector databases, retrieval-augmented generation (RAG) architectures, and orchestration frameworks (LangChain, LlamaIndex).
• Data Visualization: Proven experience designing enterprise dashboards and reports using tools such as Superset, MicroStrategy, Tableau, or similar BI tools.
• Business Acumen & Soft Skills: Proactive, curious, and adaptable mindset with excellent written and verbal communication skills; comfortable taking ownership of projects end-to-end in high-ambiguity environments.

• 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.

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.