Data Analyst(finance)

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

25 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