Require a Data Analyst(finance) in Bangalore
Share
Job Location:
Monthly Salary:
Experience Required:
Posted on:
5 hours ago
Vacancies:
1 Vacancy
Job Summary
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
Required Skills:
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.
Required Education:
MBA/ PGDM
Company Industry
IT Services and IT Consulting
Key Skills
- Data Analytics
- Microsoft Access
- SQL
- Power BI
- R
- Data Visualization
- Tableau
- Data Management
- Data Mining
- SAS
- Data Analysis Skills
- Analytics
