MIS Executive - Logistics CPG

The role requires strong Advanced Excel/Google Sheets skills, data accuracy, reporting

discipline, and an understanding of logistics operations such as dispatch, delivery, POD,

TAT, OTIF, RTO.

Key Responsibilities

• Logistics MIS & Reporting
  
  

Prepare daily, weekly and monthly logistics MIS reports.

Maintain shipment-level databases covering dispatch, delivery, POD, RTO and

pending shipments.

Generate city-wise, customer-wise, transporter-wise and warehouse-wise

performance reports.

Track shipment status and identify delayed/pending deliveries.

Prepare management dashboards and operational scorecards.

• Logistics Performance Tracking
  
  

Monitor Key KPIs Such As

• OTIF – On Time In Full
• Delivery TAT
• Pending/Undelivered shipments
• RTO update
• POD compliance
• Transporter SLA performance
  
  

Highlight exceptions and coordinate with operations teams for closure.

• Freight & Cost Analysis
  
  

Prepare transporter billing and freight reconciliation.

Validate freight invoices against agreed rates, shipment weight, distance and service

type.

Identify billing discrepancies, excess freight, weight discrepancies and cost

leakages.

Prepare cost-per-kg, cost-per-box, cost-per-order and freight-to-sales analysis.

• Data Management
  
  

Maintain Accurate Master Data For

• Pincode
• Customer
• Transporter
• Rate cards
• TAT
• Vehicle
• Route
  
  

Ensure timely data updates and data integrity.

Consolidate data received from multiple logistics partners.

• Transporter Coordination
  
  

Collect daily/weekly performance data from logistics partners.

Follow up for pending PODs, delivery status, RTO cases and exception shipments.

Prepare transporter performance scorecards.

Support monthly transporter review meetings.

• Automation & Process Improvement
  
  

Automate repetitive MIS activities using Excel formulas, Pivot Tables, Power

Query, Google Sheets and basic VBA/Apps Script.

Develop dashboards to reduce manual reporting.

Identify opportunities to improve data accuracy and reporting TAT.

Required Skills

Technical Skills

Advanced MS Excel

Pivot Tables & Charts

VLOOKUP/XLOOKUP

INDEX-MATCH

SUMIFS/COUNTIFS

IF/IFS & logical formulas

Conditional Formatting

Power Query – preferred

Google Sheets – preferred

Basic VBA / Apps Script – added advantage

Power BI – added advantage

Logistics Knowledge

B2B logistics operations

3PL management

POD management

RTO management

TAT & SLA monitoring

Freight billing and reconciliation

Vehicle utilization

Shipment tracking

Key Competencies

Strong analytical and problem-solving skills

High attention to detail

Good numerical ability

Strong follow-up and coordination skills

Ability to work with large datasets

Ability to identify trends and exceptions

Good communication skills

Ability to work under tight reporting timelines

Preferred Candidate Profile

Candidate should have experience in a logistics, courier, e-commerce, FMCG, retail or

supply-chain environment, preferably handling high-volume shipment data and multiple

logistics partners.

About Company

Founded in 2011, Purplle has emerged as one of India's premier omnichannel beauty destinations, redefining the way millions shop for beauty. With 1,000+ brands, 60,000+ products, and over 7 million monthly active users, Purplle has built a powerhouse platform that seamlessly blends online and offline experiences.

Expanding its footprint in 2022, Purplle introduced 6,000+ offline touchpoints and launched 100+ stores, strengthening its presence beyond digital. Beyond hosting third-party brands, Purplle has successfully scaled its own D2C powerhouses—FACES CANADA, Good Vibes, Carmesi, Purplle, and NY Bae—offering trend-driven, high-quality beauty essentials.

What sets Purplle apart is its technology driven hyper-personalized shopping experience. By curating detailed user personas, enabling virtual makeup trials, and delivering tailored product recommendations based on personality, search intent, and purchase behavior, Purplle ensures a unique, customer-first approach.

In 2022, Purplle achieved unicorn status, becoming India's 102nd unicorn, backed by an esteemed group of investors including ADIA, Kedaara, Premji Invest, Sequoia Capital India, JSW Ventures, Goldman Sachs, Verlinvest, Blume Ventures, and Paramark Ventures.

With a 3,000+ strong team and an unstoppable vision, Purplle is set to lead the charge in India's booming beauty landscape, revolutionizing the way the nation experiences beauty.