Job Description
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
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
- OTIF – On Time In Full
- Delivery TAT
- Pending/Undelivered shipments
- RTO update
- POD compliance
- Transporter SLA performance
- Freight & Cost Analysis
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
- Pincode
- Customer
- Transporter
- Rate cards
- TAT
- Vehicle
- Route
Consolidate data received from multiple logistics partners.
- Transporter Coordination
Follow up for pending PODs, delivery status, RTO cases and exception shipments.
Prepare transporter performance scorecards.
Support monthly transporter review meetings.
- Automation & Process Improvement
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.
Job Details
| Role Level: | Mid-Level | Work Type: | Full-Time |
|---|---|---|---|
| Country: | India | City: | Mumbai |
| Company Website: | https://www.purplle.com | Job Function: | Supply Chain & Logistics |
| Company Industry/ Sector: |
Software Development | ||
What We Offer
About the Company
Searching, interviewing and hiring are all part of the professional life. The TALENTMATE Portal idea is to fill and help professionals doing one of them by bringing together the requisites under One Roof. Whether you're hunting for your Next Job Opportunity or Looking for Potential Employers, we're here to lend you a Helping Hand.
Disclaimer: talentmate.com is only a platform to bring jobseekers & employers together. Applicants are advised to research the bonafides of the prospective employer independently. We do NOT endorse any requests for money payments and strictly advice against sharing personal or bank related information. We also recommend you visit Security Advice for more information. If you suspect any fraud or malpractice, email us at abuse@talentmate.com.
Job Snapshot
