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
€¢ Bachelor€™s degree in Commerce, Business, IT, or related field
€¢ 1€“3 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