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 data5. 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