Senior Business Intelligence Engineer

Summary

Join OpenTable, a leading hospitality technology company, as a Senior Business Intelligence Engineer! Reporting to the Manager, Business Intelligence, you will play a vital role in developing and optimizing our data infrastructure. Collaborate with cross-functional teams to solve business problems using data analysis, create and manage data dashboards, and evaluate new data sources. This role requires strong analytical and technical skills, excellent communication, and the ability to thrive in ambiguous situations. You will leverage your expertise in data modeling, ETL processes, and data visualization to drive data-informed decisions. OpenTable offers a welcoming and inclusive environment with competitive benefits and flexible work arrangements.

Requirements

• 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

Responsibilities

• 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

Preferred Qualifications

Experience with statistical modelling background

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)
• 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)
• Parental leave and benefits