Senior Analyst, Revenue Strategy, Analytics & Operations

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

Benefits offered by this job

Remote work days

Mental health support

Headspace subscription

SpringHealth therapy

Parental leave

Vacation & paid time off

Volunteer time

Development dollars

Leadership development

On-demand learning

Travel discounts

Employee Resource Groups

Job summary

OpenTable in Toronto, Canada, is seeking a Sr. Analyst to support Sales, Services and Analytics programs across the organization.

You will manipulate large data sets, identify trends, and deliver data-driven recommendations to cross-functional partners including executive leadership, sales, marketing, and finance. The role requires strong SQL, Tableau/Salesforce experience, and the ability to build financial models and dashboards.

Qualifications

• 4+ years in analytics, operations or strategy.
• Experience with Snowflake or relational databases.
• Strong SQL with ETL design and development.
• Advanced Excel with pivot tables and VLOOKUP; Google Sheets acceptable.
• Knowledge of Salesforce, Preset/Superset, Snowflake.
• Experience measuring efficiency and scaling initiatives.
• High energy and leadership to support growth.
• Strong verbal and written communication; documents processes and requirements.

Responsibilities

• Provide sophisticated analytics to support global Sales, Services, and Marketing decisions.
• Prepare analyses and narratives for field sales to senior leadership.
• Translate datasets into insights, dashboards, and reports for the sales, marketing and operations teams.
• Manage relationships with sales leaders and drive initiatives across business segments.
• Handle inbound ad hoc analyses requests from the RSS team and improve processes.
• Collaborate with Salesforce and BI teams to optimize data and workflows.
• Build and maintain financial models, forecasts and dashboards.
• SFDC data stewardship; dashboard/report upkeep; end-user support.

Skills

Analytics

SQL

Advanced Excel

Communication skills

Cross-functional collaboration

Ambiguity management

Problem solving

Salesforce

Tools

Snowflake

Preset/Superset

ETL processes

Job description

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

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; 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 benefits. This role is eligible to be considered for an annual bonus.

Work Environment & 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.

Inclusion

We r 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.