Data Engineer

OpenTable, part of Booking Holdings, Inc. (NASDAQ: BKNG), powers reservations for the hospitality industry. OpenTable’s software seats more than 1 billion people per year and helps more than 60,000 restaurants, bars, wineries and other venues attract guests, manage capacity, improve operations and maximize revenue.

As an employee of OpenTable, you will be part of a global network that includes OpenTable and KAYAK's portfolio of metasearch brands including Swoodoo, checkfelix, momondo, Cheapflights, Mundi and HotelsCombined. Many employees are dedicated to one brand, but we all have the benefit of using each other's strengths and insights. Together, we're able to help people experience the world through dining and travel.

The Role

Reporting to the Manager, Business Intelligence, this position will play a crucial role in developing, maintaining, and optimizing our data infrastructure to support business decisions across OpenTable. The role will collaborate with cross-functional teams to work on business problems and develop solutions through data gathering.

In the Data Engineer position, you will develop a strong understanding of the OpenTable Systems and its impact on the data architecture. We are looking for a team player who is a strong communicator, has an analytical mindset and strong technical skills and will be comfortable delivering results in ambiguity. 

Responsibilities:

• Gather and analyze business requirements to create and design data models and build data pipelines for data extraction, transformation, and loading (ETL)
• Translate requirements into technical specifications and builds dimensional data warehouse solutions to meet the requirements
• Collaborate with business stakeholders and technical teams to ensure data accuracy, integrity, and consistency
• Develops project plans, tracks progress and keeps all project partners updated throughout the process.
• Identify opportunities for process improvement and automation to streamline data workflows
• Evaluate new data sources and tools to improve the effectiveness and efficiency of the data infrastructure
• Ensure data accuracy, completeness, and security in accordance with company policies and industry standards
• Solid understanding of data mapping, data validation, data manipulation, data analysis use cases and provide observations of the system and suggest automated steps to fulfill the business operations and the requirements
• Stay up-to-date with industry trends and best practices in data analytics, and continuous developments in data processes and methodologies
• Sense of ownership; engages domain experts and other team members to work through challenges and cultivates positive team engagement; steps-in to other projects as needed

Please apply if: 

• 3+ years of Data Warehouse/BI Modeling Experience
• 3+ years of extensive Python, SQL/database query skill
• 2+ years of experience with Apache Airflow
• Strong analytical and problem-solving skills with the ability to translate complex data into actionable insights
• Skilled in parsing structured and unstructured data.
• Experience with Snowflake or any other relational database
• Experience with data visualization tools such as Superset or MicroStrategy
• Bachelor's or Master's degree in a quantitative field such as Computer Science, Statistics, Mathematics, Economics, or a related field
• Excellent communication and interpersonal skills to collaborate effectively with team members in Agile iterative processes and translate sophisticated data concepts to non-technical stakeholders
• High energy and contagious enthusiasm with the willingness to tackle tough projects and strives for success in ambiguous work environments

Benefits

• Paid Vacation
• One Celebration Day per calendar year
• Employee Assistance Program (EAP)
• Pension Fund

Diversity and Inclusion

We aspire to have a workplace that reflects all of the diverse communities we serve. We know that when we have diverse teams we produce more creative ideas, products, and better outcomes for our team members. OpenTable/KAYAK is proud to be an Equal Opportunity Employer, and we welcome and encourage candidates from all backgrounds and experiences to apply for roles on our team. Whoever you are, just be you.

We will 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.