Job Title - MIS Executive - Logistics

Department - Logistics / Supply Chain

Location Mumbai, India

Job Summary The MIS Executive will be responsible for managing logistics data, generating operational reports, tracking key performance indicators (KPIs), and providing analytical support to improve supply chain visibility and decision-making. The role requires strong analytical skills, proficiency in Excel and reporting tools, and the ability to transform large datasets into meaningful business insights.

Key Responsibilities

Reporting & Dashboard Management

- Prepare daily, weekly, and monthly logistics performance reports.
- Develop and maintain dashboards for freight costs, shipment tracking, D&D; impacts, Vessel Rollovers, etc.
- Generate reports using Excel, Power BI, or other reporting tools.
- Ensure timely and accurate distribution of MIS reports to stakeholders.

Data Analysis

- Analyze logistics and transportation data to identify trends/hot spots, exceptions, and improvement opportunities.

- Track KPIs such as
- On-Time Delivery (OTD)
- Contract compliance, Spot Trends

- Carrier Performance
- Ocean lead time to markets
- Support root-cause analysis for logistics service constraints.

Logistics Operations Support

- Monitor shipment status and update logistics performance trackers.
- Support freight procurement and transportation teams with data-driven insights.
- Maintain logistics master data including rates, transit times, carriers, and warehouses.
- Assist in capacity planning and network optimization exercises.

Data Quality & Governance





- Ensure accuracy and integrity of logistics databases and reports.
- Validate data received from warehouses, transporters, freight forwarders, and ERP systems.
- Maintain standard reporting templates and documentation.

Stakeholder Management

- Coordinate with Customer Service, Planning, Procurement, Finance, and Logistics teams for reporting requirements.
- Sharing reports on daily, weekly, fortnightly and monthly basis.
- Support management with ad hoc analysis and presentations.

Required Qualifications

Education

- Graduate with good proficiency in Excel and other MIS related platforms like Power Bi, etc.

Experience

- 2-5 years of experience in Logistics MIS, Supply Chain Analytics, Transportation Analytics, or similar roles.
- Experience in FMCG, Manufacturing, Retail, 3PL, or Shipping industries preferred.

Technical Skills

Mandatory

- Advanced Microsoft Excel

- Pivot Tables

- Power Query

- VLOOKUP/XLOOKUP

- Macros (preferred)

- Power BI / Tableau
- ERP Systems (SAP, Oracle, Dynamics, etc.)
- Solid data analysis and reporting skills

Key Competencies

- Analytical Thinking
- Attention to Detail
- Problem Solving
- Data Interpretation
- Planning & Organizing
- Stakeholder Management
- Communication Skills
- Process Improvement Mindset
- Business Acumen

Key Performance Indicators (KPIs)

- Report accuracy 99%
- On-time report submission
- Dashboard adoption and utilization
- Reduction in manual reporting effort
- Data quality improvement
- Logistics cost visibility and savings identification
- KPI tracking accuracy
- Automation initiatives completed

📌 Ocean Freight Executive (Mumbai)
🏢 Capgemini
📍 Mumbai