{bc}
Apply
indeed

Business Intelligence Engineer

OpenTable
Toronto, CAN
Hybrid
Discovered 3 weeks ago
SQLPythonData engineeringBusiness intelligenceApplied analyticsSnowflake

Full Job Posting

About the role

The role combines data engineering, analytics, and applied AI to build data infrastructure, intelligent workflows, and automated systems.

Works with strategy, sales, and operations teams to identify operational friction and deliver scalable solutions.

Requires business understanding, technical execution, proactive problem-solving, and communication with non-technical partners.

Workplace

  • This is a hybrid role, working from the Toronto office twice a week.

Responsibilities

  • Partner with cross-functional stakeholders to analyze workflows, identify manual bottlenecks, and define requirements for data models, pipelines, and AI solutions.
  • Build and maintain scalable ETL/ELT pipelines, data models, and Python/SQL automations that load data into Snowflake.
  • Integrate LLM APIs, RAG tools, vector databases, and agentic workflows to automate business operations and accelerate decisions.
  • Create interactive dashboards and visualizations with automated alert triggers and insights for business metrics.
  • Develop validation, evaluation, and monitoring frameworks for data and AI quality, reliability, security, and compliance.
  • Evaluate orchestration tools, AI frameworks, and data sources to improve analytics capabilities.
  • Communicate technical architecture, pipeline logic, and AI outcomes to business partners and leadership.

Minimum qualifications

  • Bachelor's or Master's degree in Computer Science, Statistics, Data Science, Information Systems, Economics, or a related quantitative field.
  • At least 2 years of hands-on experience in data engineering, business intelligence, or applied analytics.
  • Advanced SQL and Python proficiency for data processing, system integration, API development, and data modeling.
  • Hands-on experience with cloud data warehouses such as Snowflake and orchestration frameworks such as Airflow or similar ETL tools.
  • Familiarity with AI APIs, vector databases, RAG architectures, and frameworks such as LangChain or LlamaIndex.
  • Experience designing enterprise dashboards and reports with Superset, MicroStrategy, Tableau, or similar BI tools.
  • Excellent written and verbal communication; proactive, curious, and adaptable, with end-to-end project ownership in ambiguous environments.

Benefits and perks

  • Work from almost anywhere for up to 20 days per year.
  • Company-paid therapy sessions through SpringHealth and a Headspace subscription.
  • An annual company-wide week off and paid parental leave.
  • The description also mentions generous paid vacation; the provided text ends before further benefit details.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at OpenTable

Partner Marketing Manager (Hybrid)

Toronto, CAN

Discovered Today

Senior Engineering Manager - Hospitality

Toronto, CAN

Discovered 2 days agoFull-time

Director, B2B Growth Marketing (Hybrid)

San Francisco, USA

Discovered 3 days ago

Office Manager, Workplace Experience

San Francisco, USA

Discovered 3 days ago

Marketing Manager, Diner Marketing (Temp) (Hybrid)

Toronto, CAN

Discovered 3 days ago

Director, B2B Growth Marketing (Hybrid)

Toronto, CAN

Discovered 3 days ago

Senior Product Designer - Private Dining

Melbourne, AUS

Discovered 3 days ago

Director, B2B Growth Marketing (Hybrid)

New York City, USA

Discovered 3 days ago