E-Commerce MIS Associate (Reporting/ Reconciliations/ Skincare)

PeopleGene; Dadri; On-site; INR 300,000 - 600,000; Full time

Job summary

A leading e-commerce firm in India is looking for an MIS Executive for the skincare segment, responsible for managing and analyzing critical sales and inventory data. You will prepare detailed reports and monitor performance metrics across various platforms, ensuring accurate tracking of SKU levels and expiry dates. Ideal candidates should have a degree in commerce or a related field and 1-3 years of relevant experience, preferably in the beauty or FMCG industry. Strong Excel skills and attention to detail are essential for this role.

Qualifications

• Bachelor’s degree in a related field is preferred.
• 1-3 years of experience in MIS or data reporting.
• Strong understanding of e-commerce operations.
• Strong understanding of e-commerce operations and inventory management.
• High attention to detail due to batch & expiry-sensitive products.

Responsibilities

• Prepare daily, weekly, and monthly MIS reports for online sales.
• Monitor SKU performance across various categories and channels.
• Analyze return reasons and track customer feedback trends.
• Monitor order flow, fulfillment status, RTO, refunds, and delivery TAT.
• Reconcile sales data with marketplace and payment reports.
• 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.
• Track discounts, offers, and campaign performance (sale days, influencer campaigns, launches).
• Analyze price changes, margin impact, and contribution by SKU.
• 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.
• Automate reports using Excel, Google Sheets, or BI tools.
• Maintain documentation and SOPs for reporting processes.

Skills

Advanced Excel

Data Analysis

Inventory Management

Attention to Detail

Data analysis

Education

Bachelor’s degree in Commerce, Business, IT, or related field

Tools

Google Sheets

BI tools

Dashboards

Job description

The MIS Executive – E-commerce (Skincare) will manage and analyze data related to online sales, inventory, and operations for skincare products across marketplaces and D2C platforms. The role focuses on accurate reporting, SKU-level tracking, batch/expiry monitoring, and providing insights to support business growth in the beauty & personal care category.

Responsibilities

• Prepare daily, weekly, and monthly MIS reports for skincare sales, revenue, returns, and cancellations
• Monitor performance by SKU, category (cleansers, serums, moisturizers, sunscreens), and channel
• 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
• 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
• Track discounts, offers, and campaign performance (sale days, influencer campaigns, launches)
• Analyze price changes, margin impact, and contribution by SKU
• 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
• Automate reports using Excel, Google Sheets, or BI tools
• Maintain documentation and SOPs for reporting processes

Good to have

• 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