Pricing analyst role: margin, discount leakage and price tests

The three questions that fill the week

Almost every request to a pricing analyst is a version of one of these:

1. 1"If we cut the price, will we sell enough extra to make up for it?" This is break-even analysis.
2. 2"Why is our realised price so far below list price?" This is the price waterfall.
3. 3"Did the price change we made last month work?" This is test evaluation.

Question 1, worked: how much extra volume a discount needs

Take a hypothetical product with a list price of ₹1,000 and a variable cost of ₹600, so the contribution margin is ₹400 per unit, or 40%. Sales proposes a 10% discount.

• New price: ₹900. New contribution per unit: ₹900 − ₹600 = ₹300.
• To keep total contribution the same, volume must rise by ₹400 ÷ ₹300 = 1.333, a 33.3% increase.

The general formula for the required volume increase is discount ÷ (margin − discount), with both as fractions of the original price: 0.10 ÷ (0.40 − 0.10) = 0.333. At a 20% margin, the same 10% discount needs volume to double (0.10 ÷ 0.10 = 1.0). This single calculation is the most useful thing a pricing analyst can put in front of a sales head, because it shows that low-margin products can rarely afford discounts.

Question 2: the price waterfall

The list price is rarely what arrives in the bank. For a B2B distributor, a waterfall for one order might look like this (hypothetical):

The pocket price is ₹740, 26% below list. Discount leakage analysis looks for where that gap varies without reason: two similar dealers getting very different special discounts, or freight being absorbed on orders that do not qualify. Much of this is invisible in the invoice header and only appears when you join invoice lines, credit notes and rebate schedules in SQL.

Question 3: evaluating a price change honestly

Before-and-after comparisons are the most common and least reliable method, because demand shifts with season, festivals and competitor moves. Stronger approaches, in rough order of rigour: compare with a matched set of stores, regions or SKUs that did not change price; or run a planned test where some regions change and others do not. Whatever the method, report the effect on contribution, not just revenue or units, and state how long you waited, since customers can stock up before a price rise and buy less for a while afterwards.

A pricing week: promotions, competitor checks and a margin review

• Monday: weekly competitor price scan for the top 200 SKUs; flag where the gap moved by more than a set threshold.
• Tuesday: sales asks for approval of a large special discount; run the break-even and history of this customer's discounts.
• Wednesday: build the discount-leakage cut by region for the monthly commercial review.
• Thursday: design the regional test for a proposed price increase with the category manager.
• Friday: update price-change documentation and the approval log.

Realised margin and discount discipline

Common measures include realised price versus target, gross margin on the portfolio, discount spend as a share of revenue, the accuracy of volume projections for past price changes, and turnaround on deal approvals. The last one matters to sales, who will route around a pricing team that takes three days to reply.

Sales heads, category owners and finance

Pricing analysts report to a pricing manager, revenue manager or commercial finance head. They work with sales, category or product managers, finance, and sometimes procurement, since cost changes drive price reviews.

Pricing analyst versus revenue manager and category analyst

A revenue manager, common in hotels and airlines, adjusts prices dynamically against capacity and demand. A category analyst in e-commerce looks at the whole category, of which price is one lever; see the e-commerce category analyst guide. The pricing analyst's distinct focus is margin and price realisation.

Elasticity, price waterfall and revenue management

• "Price realisation, discount governance" — B2B waterfall work.
• "Competitive price intelligence, scraping" — retail or e-commerce monitoring.
• "Elasticity modelling" — statistics-heavy, often senior.
• "Deal desk" — fast approvals for sales, high volume.
• "Dynamic pricing" — algorithmic, often with a data science team.

Map the waterfall, then question the discounts

Build the waterfall for your company's top customers first; it will show where the money goes. Then own deal approvals with a clear break-even template. By month three, evaluate one past price change with a proper comparison group. Next roles include pricing manager, revenue manager, commercial analytics lead or FP&A. The Data Analyst programme teaches the SQL joins and comparison-group thinking that separate a reliable pricing analysis from a spreadsheet guess.