Senior Business Intelligence Engineer

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

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 identify business problems and develop solutions through data analysis, create and manage data dashboards and visualizations, and evaluate new data sources and tools to improve the effectiveness and efficiency of the data analytics team.

The Senior Business Intelligence Engineer level position is expected to have a strong understanding of the OpenTable Systems and its impact on the data architecture. This position will have to be a strong communicator, have an analytical approach and strong technical skills and be comfortable delivering results in ambiguity. Experience with statistical modelling background preferred.

In this role, you will:

• Gather and analyze business requirements to design data models and build data pipelines for data extraction, transformation, and loading (ETL).
• Translate business problems into data questions, find solutions to solve those questions with resourcefulness while ensuring data accuracy, integrity, and consistency.
• Create and manage data dashboards, reports, and visualizations that provide insight into key business metrics
• See 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 analytics team
• Ensure data accuracy, completeness, and security in accordance with company policies and industry standards
• Stay up-to-date with industry trends and standard methodologies in data analytics, and find opportunities for improvement in data processes and methodologies

Please apply if:

• Bachelor's or Master's degree in a quantitative field such as Computer Science, Statistics, Mathematics, Economics, or a related field
• 7+ years of experience in data analytics or a related field
• Strong analytical and problem-solving skills and can translate complex data into actionable insights
• Proficient in SQL and Python for data analysis and data wrangling
• Good working knowledge of Airflow and GitHub
• Experience with Snowflake or any other relational database
• Experience with design and development of ETL processes
• Experience with data visualization tools such as Superset
• Excellent communication and interpersonal skills, with the ability to communicate sophisticated data concepts to non-technical partners
• Proficient in using JIRA and adept at orchestrating analytical projects
• Strong multitasking abilities coupled with an agile approach
• Experience in understanding and translating ambiguous and sophisticated business problems into data solutions and communicating findings to the leadership
• High energy and contagious passion; willing to take on tough projects

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)

There are a variety of factors that go into determining a salary range, including but not limited to external market benchmark data, geographic location, and years of experience sought/required. The range for this Toronto, Canada based role is $110,000 - 130,000 CAD.

We offer a competitive base salary and benefits including: health benefits; flexible spending account; retirement benefits; life insurance; paid time off (including PTO, paid sick leave, medical leave, bereavement leave, floating holidays and paid holidays); and parental leave benefits. This role is eligible to be considered for an annual bonus and equity grant.

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.

#LI - BB1