Senior Business Intelligence Engineer

OpenTable; Toronto; On-site; CAD 110,000 - 130,000; Full time

Job summary

An established industry player is seeking a Senior Business Intelligence Engineer to enhance data infrastructure and analytics. This role involves collaborating with teams to solve business problems through data analysis, designing data models, and creating visualizations that drive key business insights. The ideal candidate will have extensive experience in data analytics, strong technical skills in SQL and Python, and a passion for continuous improvement. Join a welcoming and inclusive environment where your contributions will directly impact the hospitality industry and help shape the future of dining experiences.

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

Qualifications

• 7+ years of experience in data analytics or related fields.
• Strong analytical skills and proficiency in SQL and Python.

Responsibilities

• Develop and optimize data infrastructure to support business decisions.
• Create and manage data dashboards and visualizations.

Skills

SQL

Python

Data Analysis

Problem-Solving

Communication Skills

Statistical Modelling

Data Visualization

Multitasking

Education

Bachelor's degree in a quantitative field

Master's degree in a quantitative field

Tools

Airflow

GitHub

Snowflake

Superset

JIRA

Job description

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 remote Canada based role is $110,000 - 130,000.

In addition to a competitive base salary, roles are eligible for additional compensation and benefits including: annual cash bonus, equity grant; 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 and benefits.

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.