Commercial Analyst

Full Time
London, UK
3 months ago

Our Commercial Insights and Planning team utilises its understanding of key and secondary trading drivers and metrics behaviour to generate insights and analysis, driving data-led decisions, with the goal of maximising revenue. If you have a curious mind and a strong analytical background and are comfortable in a fast paced environment, we would love to hear from you!

 

About Secret Escapes

Secret Escapes is the world’s leading members-only online travel deal company, offering inspiring travel experiences and hand-picked offers to over 75 million users worldwide across our family of brands.

Operating across Europe and Asia, Secret Escapes Group continues to grow and establish itself as a world-class business, dedicated to giving our members the best range and value in luxury travel deals at low prices.

Secret Escapes operates a flexible working policy and we are all in the office 1 day a week (minimum) and have core hours of 10am-4pm (you can make up the other hours to suit you). In keeping with being an inspirational travel brand, we also have a ‘work from anywhere’ policy, so you can work from anywhere in the world for up to a month each year!

We’re a diverse and inclusive bunch of individuals from different backgrounds and with varied interests, but the one thing we all have in common is that we’re good people (if we do say so ourselves!).

 

Things you’ll be working on

  • Tracking commercial trends and determining drivers of performance.
  • Building, developing and maintaining dashboards to track KPIs (mostly in Tableau), along with secondary KPIs to track the drivers of revenue performance and supply quality.
  • Providing BAU and ad-hoc insights and recommendations on how to improve revenue performance.
  • Planning and forecasting future revenue performance for different destinations.
  • Deal and portfolio optimisation – maximising the performance of individual deals and developing expertise to advise the business on optimal hotel portfolio and deal mix per destination.
  • You will partner closely with the Sales Steering and Revenue, Contracting, Customer Insight, Marketing and Operational teams, providing insight and analysis that is action oriented to gel with their tactics and strategy.

 

How the magic happens

Commercial Excellence and Insights is the analytical powerhouse for the revenue organisation at Secret Escapes. We look at the commercial performance of our portfolio, analysing past successes and failures while looking forward to plan and optimise for the future. The team so far consists of two senior commercial analysts and two commercial analysts (you will be the third!). The analysts report to the senior analysts, and senior analysts to the Director of Trading and Commercial Insights. We also partner closely with our Data and Customer Insight teams and collaborate in the building of dashboards and reporting - mostly using Snowflake, Tableau and for the more custom analysis - Data Build Tool (DBT).

 

You should have:

  • Advanced Microsoft Excel skills - pivot tables, SUMIFs, VLOOKUPs,INDEX/MATCH, charts, conditional formatting and data cleaning.
  • Demonstrable experience of building complex reports.
  • Proficiency in Tableau (or dashboarding equivalent) and SQL.
  • Experience with stakeholder management.
  • Experience of working with large data sets.
  • Experience developing and completing analysis projects from end to end.
  • Experience presenting analysis to diverse audiences and driving actions from insights .
  • Demonstrable interest in travel and/or e-commerce.
  • Attention to detail, taking ownership for accuracy of output.
  • Ability to work to tight deadlines and prioritise work effectively.

 

And you are...

  • Highly numerate.
  • Commercially aware and revenue focused.
  • Excellent communication skills.
  • Enthusiastic and driven.
  • Organised, with attention to detail.
  • Hungry to learn and develop.
  • Willing to adapt and pick up new techniques.
  • Innovative, creative and imaginative.

 

We are an equal opportunity employer:

Diversity and inclusion are important to us at Secret Escapes and we encourage a culture where everyone can be themselves at work. We value and actively seek out a richly diverse range of talent and our policies ensure that every job application and employee is treated fairly, with equal opportunity to succeed. All applicants will be considered for employment without regard to any characteristic protected by law.