Opening For MIS Executive

  • icon job experience 1 - 4 Years
  • icon job opening 5 Openings
  • icon salary Not Disclosed
  • icon job posting Posted today
  • Face-to-Face interview Face-to-Face interview
  • icon job location Noida
Key Skills

VLOOKUP HLOOKUP MIS Reporting Advanced Excel Pivot Table MIS

Job Description

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
  • Experience

    1 - 4 Years

  • No. of Openings

    5

  • Education

    Graduate

  • Role

    MIS Executive

  • Industry Type

    Wellness / Fitness / Sports / Beauty

  • Gender

    [ Male / Female ]

  • Job Country

    India

  • Type of Job

    Full Time

  • Work Location Type

    Work from Home

  • Face interview location

    Noida Sector 142

About AICS Consultancy Service Pvt. Ltd

We are your reliable partner in building stronger teams and transforming careersbecause finding the right talent or job shouldnt be a challenge.
Read More...
Similar Jobs
Apply Now

Register to Get Relevant Jobs

Get Noticed By Top Recruiters

Become a Premium Job Seeker

  • Higher Boosting
  • Resume Highlighter
  • Verified Stamp
  • Resume Exposure

499/- for 3 months

Pay Now