We are looking for a skilled and detail-oriented Route Coordinator / Back Office Executive with robust knowledge of Chandigarh, Mohali, and Panchkula local areas. The candidate must have excellent computer skills and advanced MS Excel knowledge to prepare cab rosters, manage routes, coordinate pickups and drops, and maintain daily operational data.

Key Responsibilities

- Prepare and manage daily cab rosters for employee pick-up and drop services.
- Have proper knowledge of local areas, sectors, landmarks, and routes across Chandigarh, Mohali, Panchkula, and Zirakpur.
- Plan efficient routes and pickup/drop sequences to minimize travel time and distance.
- Coordinate with drivers, transport supervisors, and clients regarding daily operations and route changes.
- Prepare and maintain Excel sheets for rosters, route details, vehicle allocation, and daily reports.
- Use advanced MS Excel formulas such as VLOOKUP, XLOOKUP, IF, SUMIFS, COUNTIFS, INDEX-MATCH, Pivot Tables, and conditional formatting.
- Handle large amounts of operational data accurately and efficiently.
- Maintain proper records of vehicle details, employee pickup/drop points, shift timings, and route changes.




- Monitor roster accuracy and resolve route-related issues promptly.
- Prepare daily, weekly, and monthly MIS reports as required.
- Perform general back-office computer work, data entry, email communication, and documentation.

Required Skills & Qualifications
- Minimum 1–3 years of experience in route coordination, cab operations, transport, or back-office work preferred.
- Strong knowledge of Chandigarh, Mohali, Panchkula, and Zirakpur local areas.
- Advanced MS Excel knowledge with practical experience using formulas.
- Excellent computer skills and strong command over PC operations.
- Good typing speed, data accuracy, and attention to detail.
- Strong coordination, communication, and problem-solving skills.
- Ability to work under pressure and manage multiple rosters and deadlines.

Preferred Candidate A candidate with previous experience in corporate employee transportation, IT/BPO cab services, or transport operations will be preferred. send cv on (phone hidden)

Pay: ₹18,000.00 - ₹25,000.00 per month

Benefits

- Provident Fund

Work Location: In person

📌 Route Cordinator (Chandigarh)
🏢 Panjeta Travels Private
📍 Chandigarh