With millions of diners, tens of thousands of restaurants, and 23+ years of experience, OpenTable, part of Booking Holdings, Inc. (NASDAQ: BKNG), is an industry leader with a unique insight into the world of hospitality. We champion restaurants, bars, wineries, and other venues around the world, helping them attract guests, manage capacity, improve operations and maximize revenue.

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 network that includes OpenTable and KAYAK's portfolio of travel brands including Swoodoo, checkfelix, momondo, Cheapflights, Mundi and HotelsCombined.

Hospitality is all about taking care of others, and it defines our culture. You’ll work in a welcoming and inclusive environment, and get the benefits, flexibility, and support you need to succeed.

The Role:

We are looking for a Business Intelligence (BI) Engineer that will play a crucial role in developing, maintaining, and optimizing our data infrastructure to support business decisions on the data analytics team as well as across OpenTable. This individual will collaborate with cross-functional teams to identify business problems and develop solutions through data analysis in the face of ambiguity.

This role will also:

• Capture and analyze business requirements to design data models and build data pipelines for data extraction, transformation, and loading (ETL)
• Collaborate with business partners and technical teams to ensure data accuracy, integrity, consistency, and security
• Build and manage data dashboards, reports, and visualizations that provide insight into key business metrics
• Identify opportunities to streamline data workflows through automation
• Evaluate new data sources and tools to improve the effectiveness and efficiency of the team
• Stay up-to-date with industry trends and best practices in data processes and methodologies

Please apply if you have:

• 2+ years of work in data analytics or a related field
• Strong analytical and problem-solving skills, with the ability to translate complex data into useful insights for technical and non-technical partners
• Proficient in SQL and one or more programming languages such as Python or R
• Experience with Snowflake or any other relational database
• Experience with the design and development of ETL processes
• Experience with data visualization tools such as Superset or MicroStrategy
• Excellent communication and interpersonal skills

Benefits:

• Paid Time Off - 20 days a year
• Birthday/celebration PTO - 1 day
• Annual company weeks off
• Flexible sick time off
• Paid volunteer time
• Parental Leave Benefits
• Dental & Vision Insurance
• Life & Disability Insurance
• Group RRSP and DPSP
• Major Medical Insurance (dependent care options)

Diversity, Equity, and Inclusion

OpenTable aspires to be a workplace that reflects the diverse communities we serve and a culture that is inclusive and welcoming. Hiring people with different backgrounds, experiences, perspectives, and ideas is critical to innovation and to how we deliver great experiences for our users and our partners. Representation matters.

We ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform job responsibilities, and to receive other benefits and privileges of employment. Please contact us to request accommodation.