1. Sales & Performance MIS
Prepare daily, weekly, and monthly MIS reports for skincare sales, revenue, returns, and cancellations
Track key e-commerce KPIs: GMV, Net Sales, AOV, Conversion Rate, ROAS, CAC
Monitor performance by SKU, category (cleansers, serums, moisturizers, sunscreens), and channel
2. Marketplace & D2C Reporting
Track performance across platforms such as Amazon, Flipkart, Myntra, Nykaa, and Shopify
Monitor order flow, fulfillment status, RTO, refunds, and delivery TAT
Reconcile sales data with marketplace and payment reports
3. Inventory, Batch & Expiry MIS (Skincare-Specific)
Maintain SKU-wise inventory reports including batch numbers and expiry dates
Track near-expiry stock and support liquidation / discount planning
Monitor stock ageing, replenishment needs, and out-of-stock risks
Coordinate with warehouse and supply chain teams for stock accuracy
4. Pricing, Promotions & Campaign Analysis
Track discounts, offers, and campaign performance (sale days, influencer campaigns, launches)
Analyze price changes, margin impact, and contribution by SKU
Support marketing teams with campaign performance data
5. Returns & Quality MIS
Analyze return reasons (damaged, leakage, allergic reaction, incorrect item)
Track customer complaints and feedback trends
Share insights with QA and product teams to reduce return rates
6. Data Accuracy & Process Improvement
Ensure accuracy and consistency across all MIS reports
Automate reports using Excel, Google Sheets, or BI tools
Maintain documentation and SOPs for reporting processes
Required Skills & Qualifications
Bachelors degree in Commerce, Business, IT, or related field
13 years of MIS / data reporting experience (beauty, skincare, FMCG preferred)
Advanced Excel / Google Sheets (Pivot Tables, XLOOKUP, formulas, dashboards)
Strong understanding of e-commerce operations and inventory management
High attention to detail due to batch & expiry-sensitive products