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.