Role Summary
The Data Analyst – Finance is responsible for ensuring complete, accurate, and timely recognition of all revenue streams across the e-commerce marketplace amongst other things. The role identifies leakages, drives root-cause analysis, strengthens controls, and partners with Category, Growth, Tech, CX, and Finance Ops teams to ensure revenue integrity across the order-to-cash cycle.
Key Responsibilities
1. Revenue Validation & Reconciliation
- Reconcile daily orders vs. revenue booked (web, app, POS, clinic, dark store, marketplace)
- Validate settlement files from payment gateways, COD partners, logistics partners
- Ensure accuracy of commissions, platform fees, delivery fees, and convenience charges
- Detect mismatches between order value, settlement value, and ledger entries
2. Audit of Discounts, Promos & Pricing
- Validate promo codes, category discounts, cashback schemes, platform fee logic
- Identify leakage from incorrect discount configurations or unauthorized promotions
- Periodic price-to-revenue mapping checks across channels
- Partner with Category/Growth to ensure guardrails on promo burn
3. Returns, Cancellations & Refunds Governance
- Audit cancellations (customer vs seller vs ops-driven) and ensure correct revenue reversal
- Validate refund amounts, timelines, and gateway charges
- Monitor abnormal refund patterns, abuse, or system errors
- Ensure compliance with marketplace policies and SLA-linked charges
4. Delivery Fee & Platform Fee Assurance
- Validate delivery fee computation based on thresholds, pin codes, SLA, SDD/NDD
- Identify leakages due to incorrect rule configuration in CMS or backend
- Run periodic simulations to ensure rule engines match business policies
5. Payment Gateway & Logistics Reconciliation
- Validate MDR, gateway fees, chargebacks, and deductions
- Reconcile COD handovers, remittances, undelivered returns, and fake delivery claims
- Track disputes and ensure timely recovery
- Highlight partner-level revenue leakages
6. GST, Invoice & Compliance Checks
- Validate GST rates across categories, HSN codes, and invoices
- Ensure revenue classification aligns with compliance requirements
- Work with Finance Controller on reconciliation of GST liability vs revenue
7. Root-Cause Analysis & Control Improvement
- Identify root causes for revenue loss (tech bugs, logic mismatch, CX errors, category inputs, leakage in returns, fraud)
- Build controls, SOPs, alerts, and dashboards for early detection
- Partner with Product/Tech to fix order engine or settlement engine issues
- Track and close RCA with owners (Category, SCM, CX, Tech)
8. Reporting & Dashboards
- Build automated dashboards (Sheets/Excel/PowerBI) for:
- Revenue leakages
- Promo misuse
- Delivery fee collection
- Refund losses
- Rate-card validation
- Present monthly revenue assurance scorecards to leadership
Qualifications & Experience
- Bachelor’s degree in Data Analytics, Statistics, Mathematics, Economics, Engineering, or related field
- 2–5 years in data analytics
- Experience in e-commerce, fintech, retail, logistics, marketplace preferred
- Strong Excel/Sheets skills; SQL/Python/PowerBI is a plus
- Strong understanding of order lifecycle, payment gateways, reconciliations
