Finance and accounting · Updated
Pricing analyst interview questions
12 pricing analyst interview questions, why UK employers ask them and what a strong answer covers, plus what to expect from the SQL or Excel test.
Getting your CV ready too? Read the pricing analyst CV guide.
Pricing analyst interviews test data skills and commercial sense together. Expect a technical test, usually SQL or Excel, plus questions on how you'd analyse promotions, competitor prices or elasticity. Insurance pricing roles go further into statistical modelling, so be ready to discuss GLMs if they're in the advert.
Analytical questions
1. How would you measure whether a promotion worked?
Why they ask: Promotional analysis is a core task.
A strong answer covers: incremental volume against a baseline, the cost of the discount, cannibalisation of other products, halo effects, and margin rather than just sales.
2. What is price elasticity, and how would you estimate it from our data?
Why they ask: It's the foundation of pricing analysis.
A strong answer covers: a clear definition, using past price changes, controlling for seasonality, promotions and competitor moves, and the limits of the estimate.
3. A competitor has cut prices on our best seller. What would you look at?
Why they ask: It tests structured, commercial thinking.
A strong answer covers: how far and how widely they've cut, our sales trend since, which customers are most price-sensitive, and the margin cost of matching.
4. How would you check a large pricing file before it goes live?
Why they ask: Pricing errors cost real money.
A strong answer covers: comparing to current prices for large changes, checking for prices below cost, validating formats and codes, sample checks, and a sign-off step.
5. How would you find discount leakage?
Why they ask: Leakage is a common source of lost margin.
A strong answer covers: comparing invoice and pocket prices, analysing discounts by customer and salesperson, looking for outliers and off-invoice rebates.
Technical questions
6. Which SQL skills do you use most?
Why they ask: SQL is in most pricing analyst adverts.
A strong answer covers: joins, aggregations, window functions and CTEs, with a real example of a query that answered a business question.
7. Walk me through a dashboard or report you built.
Why they ask: Analysts must make findings usable.
A strong answer covers: the audience, the question it answered, data sources, design choices and how it's used.
8. What would you do if the data didn't look right?
Why they ask: Data quality issues are common.
A strong answer covers: checking source and extraction, reconciling to known totals, talking to data owners, and being transparent about any limitations.
Communication and competency questions
9. Tell me about an analysis that changed a commercial decision.
Why they ask: Impact is what matters.
A strong answer covers: the question, your finding, how you presented it, the decision and the result.
10. How would you explain your findings to a category or sales manager?
Why they ask: Pricing analysts work with non-analysts.
A strong answer covers: a clear headline, one simple chart, what it means for them and a recommended action.
11. Tell me about a time you had to work to a tight deadline.
Why they ask: Price changes and reviews run to fixed dates.
A strong answer covers: prioritising, communicating early, and delivering accurate work on time.
12. Why pricing?
Why they ask: They want genuine interest.
A strong answer covers: enjoying the mix of data and commercial impact, and where you'd like to go next, such as pricing manager or commercial finance.
What to expect in the test
Typical tests ask you to join sales and product tables, calculate margin by product or customer, and spot something unusual. Write clean, commented SQL or Excel and finish with a short written conclusion.