Third Wave Coffee Revenue Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Revenue Analyst in travel, hospitality and food service tracks sales, costs and KPIs across outlets or properties to find where money is made or lost. Day to day you pull data from POS systems, build Excel models, monitor pricing and discounts, and share simple reports that help managers improve margins. At a fast-growing cafe chain like Third Wave Coffee, you might compare store-level revenue, average order value and delivery channel performance.

Role and sector knowledge

1. 1

   What does a Revenue Analyst do in a cafe or food service chain, and how is it different from a finance analyst?

   Focus on daily revenue tracking, pricing, promotions and store-level KPIs. A finance analyst often looks at budgets, audits and statutory reporting, while revenue analysis is more operational and forward-looking.

2. 2

   Which revenue metrics would you track for a coffee chain with dine-in, takeaway and delivery?

   Mention average order value, footfall or covers, revenue per available seat hour, delivery mix, discount rate and same-store sales growth. Show that each channel has different cost and margin profiles.

3. 3

   How do seasonality and location affect revenue in travel, hospitality and food service?

   Give examples like monsoon dips, festival peaks, office vs mall locations and weekday vs weekend patterns. Explain how you would adjust targets or staffing based on these patterns.

4. 4

   What is the difference between revenue, gross margin and contribution margin for a single cafe outlet?

   Revenue is total sales, gross margin is sales minus direct costs like ingredients, and contribution margin is what is left after variable costs to cover fixed costs. Use a simple coffee example to make it clear.

Technical and analytical skills

1. 5

   How would you use Excel to find which menu items are driving or dragging down revenue?

   Describe a pivot table with item, quantity sold and revenue, then calculate item-level contribution. Mention sorting by margin and volume, and flagging low-margin high-volume items.

2. 6

   A store's average order value dropped 10 percent last month. How would you investigate?

   Break the drop by channel, daypart, item mix and discount usage. Compare with footfall and transaction count to see if the issue is fewer items per bill or more discounting.

3. 7

   What is price elasticity, and how could it apply to a cafe raising prices by 5 percent?

   Explain that elasticity shows how demand changes with price. A strong answer says you would test on a few items or stores, watch volume and revenue, and avoid raising prices on highly price-sensitive items.

4. 8

   How would you build a simple dashboard to track daily revenue for 20 outlets?

   Mention key tiles like daily sales, week-on-week growth, top and bottom stores, discount rate and delivery share. Say you would use Google Sheets or a BI tool and keep it updated automatically from POS data.

Practical scenarios

1. 9

   Two outlets in the same city have very different revenue despite similar footfall. What could explain this?

   Consider average order value, menu mix, pricing, delivery share, local competition and catchment income. Suggest comparing item-level sales and discount patterns before concluding.

2. 10

   You are asked to evaluate whether a new combo offer increased profit. What data do you need?

   Ask for baseline sales, combo uptake, discount given, ingredient cost and any cannibalisation of full-price items. Show that revenue growth alone is not enough; profit and margin matter.

3. 11

   A delivery aggregator is charging higher commissions. How would you analyse the impact on revenue?

   Compare net revenue after commission for delivery vs dine-in. Look at order volume, average order value and whether you can shift customers to direct ordering or adjust menu prices for delivery.

4. 12

   You notice a store manager is giving unusually high discounts. How do you handle it?

   First verify the data and check if there is a valid reason like a local event. Then discuss findings with your manager, suggest a discount policy or approval limit, and track the impact after the change.

Behavioural and HR questions

1. 13

   Why do you want to work in revenue analysis for a fast-growing cafe or food service brand?

   Connect your interest in data with the energy of the sector. Mention wanting to see real impact on store performance and learning how pricing and promotions work in practice.

2. 14

   Tell me about a time you found an error or insight in a dataset during a college project or internship.

   Use a clear situation-action-result structure. Show how you checked the data, communicated the finding simply and what changed because of it.

3. 15

   You have to present a revenue report to non-finance store managers. How do you make it useful?

   Talk about using simple charts, one clear takeaway per page and actions they can take. Avoid jargon and focus on what matters to them, like sales per staff hour or wastage.

4. 16

   How do you handle tight deadlines when multiple reports are due on the same day?

   Show prioritisation based on business impact, early communication with stakeholders and using templates or automation to save time. Give a real example if possible.