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.

This is a hybrid role; working from our office in Toronto twice a week.

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.

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

Generous paid vacation + 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

20 days of paid time off

Private health and dental insurance

Life and Disability insurance

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.

At OpenTable, we pride ourselves on fostering a global and dynamic work environment. As a team member with us, you will benefit from a schedule tailored to accommodate a global workforce operating across multiple time zones. While the majority of your responsibilities may align with conventional business hours, there will be instances where you are expected to manage communications - via calls, Slack messages, or emails - outside of regular working hours to effectively collaborate with international colleagues, respond to restaurant partners, and/or address urgent matters. OpenTable will always abide by and consider local laws and regulations.

We’re committed to creating a workplace where everyone feels they belong and can thrive. We know the best ideas come when we bring different voices to the table, so we're building a team as dynamic as the diners and restaurants we serve - and fostering a culture where everyone feels welcome to be themselves.

If you need accommodations during the application or interview process, or on the job, we’re here to support you. Please reach out to your recruiter to request any accommodations.