Require a Data Analyst(finance) in Bangalore

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 Requirements Qualifications & Experience Bachelors 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
MBA/ PGDM
2-5 years
Qualification: MBA/PGDM from reputed B-school. Experience: 20+ years in corporate sales, institutional leasing, or real estate investment. Requirements: Proven success in closing large deals and strong industry networks. Remuneration will be commensurate with qualifications and experience.