Senior Analyst, Revenue Strategy, Analytics & Operations

OpenTable; Vancouver; Hybrid; CAD 95,000 - 105,000; Full time

Benefits offered by this job

Work from anywhere up to 20 days/year

Mental health focus: SpringHealth

Headspace subscription

Annual company-wide week off

Parental leave

Generous vacation + birthday time off

Development Dollars

Leadership development

Access to on-demand e-learnings

Travel Discounts

Employee Resource Groups

20 days PTO

Private health and dental insurance

Life and Disability insurance

Job summary

OpenTable in Canada is seeking a Senior Analyst for Revenue Strategy, Analytics & Operations to support a range of sales and services programs across the organization. You will manipulate large data sets to uncover trends, build dashboards, and partner with finance, product, and leadership to inform strategy.

You will collaborate with Salesforce and BI teams, develop financial models, and deliver data-driven recommendations.

Qualifications

• 4+ years of experience in analytics, operations, or strategy
• Experience with Snowflake or relational databases
• Strong SQL coding skills and ETL design
• Advanced Excel skills including pivot tables and VLOOKUP
• Knowledge of Salesforce, Preset/Superset, Snowflake
• Operational experience in measuring efficiency and scale
• High energy with ability to lead peers
• Strong verbal and written communication of processes and requirements

Responsibilities

• Sophisticated analytics to support global Sales, Services, and Marketing decisions
• Prepare and present analyses and narratives for various audiences
• Translate data sets into insights, dashboards, and reports
• Cultivate and manage strategic relationships with sales leaders
• Manage inbound ad hoc analyses requests from RSS team
• Partner with Salesforce and BI teams to implement data improvements
• Build and maintain financial models, forecasts, dashboards
• SFDC data stewardship; dashboard/report creation and user support

Skills

Analytics experience

SQL

Excel (Advanced)

Salesforce

Data analysis

Operations analytics

Communication skills

AI tooling awareness

Tools

Snowflake

Salesforce

Preset/Superset

Job description

Senior Analyst, Revenue Strategy, Analytics & Operations

About OpenTable:

With millions of diners,70,000+ restaurant partners and 25+ years of experience, OpenTable, part of Booking Holdings, Inc. (NASDAQ: BKNG), is an industry leader with a passion for helping restaurants thrive. Our world-class technology empowers restaurants to focus on what matters most – their team, their guests, and their bottom line – while enabling diners to discover and book the perfect restaurant for every occasion.

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 team and its portfolio of metasearch brands. Hospitality is all about taking care of others, and it defines our culture.

The Role

Reporting to the Sr. Director, Revenue Strategy, Operations, and Analytics, this position is responsible for supporting a variety of sales and services related programs, operations, initiatives, and analytics in the United States. Candidates for this role must have experience manipulating large sets of data to discover trends and make recommendations. The role will work cross-functionally with multiple departments including executive leadership, sales, marketing, operations, finance, product, and data analytics to support the design, implementation and continued optimization of multiple business needs. This includes delivering data-driven insights to internal partners to inform short and long term strategy and action plans. The ideal candidate will be able to recognise and understand the relationship between clean data, clear & efficient processes, and reporting.

The Sr. Analyst level position is expected to have an excellent understanding of the OpenTable Sales and Services organization, the ability to learn quickly, and to be able to work in ambiguity. You'll be able to navigate the roles, reporting, and reality of the business in the field. This position needs to have excellent communication, project management and data analysis skills and be comfortable building recommendations. Experience with Salesforce, Tableau, SQL queries, and a finance or analytics background preferred. This posting is for an existing vacancy.

Responsibilities

• Sophisticated analytics to support global Sales, Services, and Marketing decisions, including recurring monitoring of key performance metrics and the health of specific business segments


• Prepare and present analyses and narratives for audiences ranging from field sales to senior leadership


• Translate data sets into impactful insights, recommendations, dashboards, and reports for the larger sales, marketing and operations teams


• Cultivate and manage strategic relationships with various sales leaders, partnering with them to drive key initiatives and measurable results across diverse business segments


• Manage flow of inbound requests from the Global Restaurant Sales and Services (RSS) team for various ad hoc analyses, reporting needs, process and system enhancement requests


• Partner with Salesforce and BI teams to implement process and data optimizations


• Build and maintain financial models, forecasts and dashboards for various business scenarios


• Salesforce.com (SFDC) data stewardship and improvement; dashboard and report creation and upkeep; end user support and documentation management

Minimum Qualifications

• 4+ years of experience in an analytics, operations, or strategy role


• Experience with Snowflake or any other relational database


• Strong SQL coding skills + experience with design and development of ETL processes


• Advanced Excel skills required, including proficiency with pivot tables and VLOOKUP. Equivalent Google Sheets experience preferred


• Knowledge in Salesforce, Preset/Superset, Snowflake


• Operational experience in measuring and improving efficiency, utilization, scale initiatives etc.


• High energy and contagious enthusiasm. Willing to take on tough projects and be a peer leader in order to support growth


• Shown strong verbal and written communication skills; including detailing business processes, use cases, and business requirements

Preferred Qualifications

• Excellent analytical and reporting capabilities, problem solving, negotiation, task and project coordination, and organization skills


• Demonstrated ability to use AI tools to accelerate research, synthesis, reporting, and workflow automation


• Understanding of sales process within OpenTable, or equivalent sales process experience


• Background in finance or advanced business analytics.

Benefits and Perks

• 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


• 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.

The expected range of compensation for this position based in Toronto, Canada, including commission and/or bonuses, is $95,000-$105,000 CAD.There are a variety of factors that go into determining a compensation range, including but not limited to external market benchmark data, geographic location, and years of experience sought/required.

We offer a competitive base salary and benefits including: health benefits; 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.

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.

Inclusion

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.

#LI-LR1