Job Description

Position: Senior MIS Executive Administration
Department: Ground Transport Operations Work Type: Full-Time | Rotational 24x7 Shifts Location: Gurugram, Haryana
Education & Experience Requirements:
Bachelors degree in any discipline.
Minimum 5+ years of experience in managing Ground Transport Operations, with a strong focus on MIS and analytics.
Excellent oral and written communication skills in English.
Proficient in Microsoft Office Suite (Word, Excel, PowerPoint), and Outlook.
Willingness to work in a 24x7 shift environment.
Role Summary:
The Senior MIS Executive will be responsible for managing, analyzing, and reporting transport-related data to ensure smooth and efficient operations across India's Ground Transport function. This role requires a keen eye for detail, excellent analytical abilities, and a proactive approach to identifying operational inefficiencies and reporting them through actionable insights.
Key Responsibilities:
Manage and maintain MIS data related to ground transport operations across India.
Oversee daily transport operations including fleet management, route planning, logistics coordination, and vendor management.
Perform daily trip sheet data entry, reconciliation of trip data, and ensure timely submission of completed trips by vendors.
Maintain accurate vehicle-wise trip logs and cross-verify them against billing MIS data.
Prepare daily, weekly, and monthly MIS reports with clear visualizations and KPIs such as:
On-Time Arrival (OTA)
On-Time Departure (OTD)
No-Show Reports
Utilization Reports
Ensure data accuracy through regular audits, validations, and real-time updates within internal systems.
Create and maintain dashboards and reports using advanced Excel and other reporting tools.
Analyze operational trends and present insights and recommendations to senior management.
Automate recurring reports to improve operational efficiency and reduce manual effort.
Act as a liaison between internal teams and external vendors for regular updates and coordination of transport reporting.
Ensure timely receipt and submission of vendor invoices to the finance team for processing.
Utilize data analytics and BI tools to support strategic decision-making and enhance operational performance.
Preferred Skills:
Advanced proficiency in Excel (Pivot Tables, VLOOKUP, Macros, Dashboards).
Experience with data visualization tools (e.g., Power BI, Tableau) is a plus.
Strong attention to detail and data accuracy.
Ability to handle large datasets and generate actionable insights.
Excellent organizational and time management skills.

Skills Required