Opening For MIS Executive

  • icon job experience 1 - 4 Years
  • icon job opening 5 Openings
  • icon salary Not Disclosed
  • icon job posting Posted 47 days ago
  • 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

€¢ 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
  • 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