Data Analyst in E-Commerce & Retail India 2026

Pattern 1 — Return rate by category with revenue impact

SELECT
  p.category,
  COUNT(o.order_id)                                 AS total_orders,
  SUM(CASE WHEN o.status = 'returned' THEN 1 END)  AS returns,
  ROUND(
    100.0 * SUM(CASE WHEN o.status = 'returned' THEN 1 END) / COUNT(*), 1
  )                                                 AS return_rate_pct,
  ROUND(SUM(o.sale_price), 0)                       AS total_gmv,
  ROUND(SUM(CASE WHEN o.status = 'returned'
            THEN o.sale_price ELSE 0 END), 0)       AS returned_gmv,
  ROUND(
    100.0 * SUM(CASE WHEN o.status = 'returned' THEN o.sale_price END)
    / SUM(o.sale_price), 1
  )                                                 AS gmv_at_risk_pct
FROM orders o
JOIN products p ON o.product_id = p.product_id
WHERE o.order_date >= DATE_SUB(CURDATE(), INTERVAL 90 DAY)
GROUP BY p.category
ORDER BY returned_gmv DESC;

Pattern 2 — RFM customer segmentation

WITH rfm_base AS (
  SELECT
    customer_id,
    DATEDIFF(CURDATE(), MAX(order_date))  AS recency_days,
    COUNT(DISTINCT order_id)              AS frequency,
    ROUND(SUM(net_amount), 2)             AS monetary
  FROM orders
  WHERE status NOT IN ('cancelled','returned')
  GROUP BY customer_id
),
rfm_scored AS (
  SELECT *,
    NTILE(5) OVER (ORDER BY recency_days ASC)  AS r_score,  -- lower days = higher score
    NTILE(5) OVER (ORDER BY frequency DESC)    AS f_score,
    NTILE(5) OVER (ORDER BY monetary DESC)     AS m_score
  FROM rfm_base
)
SELECT
  customer_id, recency_days, frequency, monetary,
  r_score, f_score, m_score,
  (r_score + f_score + m_score)                 AS rfm_total,
  CASE
    WHEN r_score >= 4 AND f_score >= 4 AND m_score >= 4 THEN 'Champion'
    WHEN r_score >= 3 AND f_score >= 3                  THEN 'Loyal'
    WHEN r_score >= 4 AND f_score <= 2                  THEN 'New Customer'
    WHEN r_score <= 2 AND f_score >= 3                  THEN 'At Risk'
    WHEN r_score <= 2 AND f_score <= 2                  THEN 'Lost'
    ELSE 'Needs Attention'
  END                                           AS segment
FROM rfm_scored
ORDER BY rfm_total DESC;

Pattern 3 — Monthly cohort retention

-- Which monthly cohort retains best?
WITH cohorts AS (
  SELECT
    customer_id,
    DATE_FORMAT(MIN(order_date), '%Y-%m')   AS cohort_month
  FROM orders
  GROUP BY customer_id
),
cohort_orders AS (
  SELECT
    o.customer_id,
    c.cohort_month,
    DATE_FORMAT(o.order_date, '%Y-%m')      AS order_month,
    PERIOD_DIFF(
      DATE_FORMAT(o.order_date, '%Y%m'),
      DATE_FORMAT(c.cohort_month,  '%Y%m')
    )                                       AS month_number
  FROM orders o
  JOIN cohorts c USING (customer_id)
)
SELECT
  cohort_month,
  month_number,
  COUNT(DISTINCT customer_id)               AS customers
FROM cohort_orders
GROUP BY cohort_month, month_number
ORDER BY cohort_month, month_number;
-- Pivot this in Power BI / Excel to see the retention matrix

What does a data analyst do at an Indian e-commerce company?

Data analysts at Indian e-commerce companies typically work on: sales performance analysis (daily, weekly, monthly GMV by category, region, and channel); return rate analysis (which products, categories, and regions drive returns and why); funnel analytics (where users drop off between homepage and purchase); customer segmentation (RFM analysis — Recency, Frequency, Monetary — to identify high-value vs at-risk customers); pricing analytics (how price changes affect conversion and margin); seller analytics (at marketplace companies like Amazon, Flipkart — which sellers drive GMV, which have quality issues); and supply chain analytics (inventory, out-of-stock rates, delivery time vs returns). Most e-commerce analysts work with SQL for querying large transaction tables, Python or Excel for analysis, and Power BI or Tableau for dashboards.

What are the most important metrics for an e-commerce data analyst in India?

The most important e-commerce metrics for Indian data analysts: GMV (Gross Merchandise Value — total transaction value before deductions); Net Revenue (GMV minus discounts, returns, and cancellations); Conversion Rate (sessions that result in a purchase — typically 1-4% for Indian e-commerce); Return Rate (% of delivered orders returned — typically 8-25% depending on category); Customer Acquisition Cost (CAC — marketing spend / new customers acquired); Customer Lifetime Value (LTV — how much revenue a customer generates over their lifetime); Repeat Purchase Rate (what % of customers buy again within 90 days); Average Order Value (AOV); Cart Abandonment Rate; and NPS (Net Promoter Score, though this is a survey-based metric).

What is RFM analysis and how is it used in Indian e-commerce?

RFM stands for Recency, Frequency, Monetary — a customer segmentation technique that classifies customers based on: Recency (how recently did they last purchase?), Frequency (how many times have they purchased?), and Monetary (how much total have they spent?). In Indian e-commerce, RFM is used to identify: Champions (bought recently, buy often, high spenders — these are VIP customers; send early access to sales); At-Risk customers (used to be frequent buyers but have not bought in 3+ months — send a re-engagement offer); New Customers (one purchase only — onboarding communications to drive second purchase); Lost Customers (no purchase in 6+ months — assess whether win-back campaign is worth the cost). RFM is implemented in SQL using NTILE() or CASE statements to score each dimension 1-5 and combine into a segment.

What is GMV and how is it different from revenue in Indian e-commerce?

GMV (Gross Merchandise Value) is the total value of goods sold on a platform before any deductions. Revenue is what the company actually earns. The difference is significant: for a marketplace like Flipkart, GMV is all orders placed; revenue is only the commission Flipkart earns from sellers (typically 5-20% of GMV). For a D2C brand (own product, own store), GMV and revenue are closer but still differ: GMV includes returned orders, which reduce net revenue; GMV may include cancelled orders that never shipped. Indian analysts must know both — GMV is used in investor reporting and marketing (higher number), net revenue is used in P&L and profitability analysis. The gap between GMV and net revenue is one of the most-asked interview questions at e-commerce companies.

Which Indian e-commerce companies hire data analysts in Noida and Delhi NCR?

Major e-commerce employers of data analysts in Delhi NCR in 2026: Noida Expressway — Snapdeal (legacy marketplace, analytics team), several D2C brand analytics teams (beauty, fashion, FMCG brands with Noida fulfilment centres); Gurugram — Nykaa analytics (beauty D2C), Meesho data team (social commerce), IndiaMart analytics, Policybazaar/Paisabazaar (insurance/finance marketplace), Udaan (B2B commerce); Delhi NCR broadly — Lenskart analytics, Boat Lifestyle, Mamaearth. Amazon India and Myntra (Flipkart group) have their primary analytics teams in Bangalore but also hire in NCR. For freshers and junior analysts, many D2C brands with Noida offices hire for analytics and MIS roles — these brands often appear in job listings as "lifestyle brand" or "e-commerce company, Noida" rather than named companies.

How do I build an e-commerce analytics portfolio project for my resume?

For an e-commerce analyst portfolio: download the "E-Commerce Sales Dataset" from Kaggle (it has orders, products, customers, returns); write SQL to answer: (1) which categories have the highest and lowest return rates; (2) which cities drive the most GMV; (3) build an RFM customer segmentation; (4) calculate monthly cohort retention (what % of customers who bought in January also bought in February, March, etc.); (5) identify the top 10 products by revenue and their return rates. Build a Power BI dashboard with a sales overview page, a returns analysis page, and a customer segmentation page. Write a GitHub README explaining your findings and recommendations. This single project, done well, is enough to land a junior e-commerce analyst interview at most Indian companies.

What is the difference between working at a D2C brand versus a marketplace like Flipkart?

D2C (Direct-to-Consumer) brand analytics: you analyse your own products, your own customers, your own marketing spend. Data is focused — fewer SKUs, deeper customer insight. Analysts influence pricing, product, and marketing decisions directly. Smaller teams mean broader scope (you do everything from MIS to product analytics). Marketplace analytics (Flipkart, Amazon India, Nykaa platform): you analyse platform-wide data — millions of SKUs, hundreds of thousands of sellers, billions of events. More specialised — you may only analyse one vertical (electronics, fashion) or one function (seller quality, logistics). Better tech stack and data engineering support. Higher salary ceiling. Both are excellent — D2C for broader impact at a smaller company, marketplace for specialisation and scale.