Role & responsibilities

Company Name: Urban Yatra
Department: MIS / Business Operations
Designation: Senior Executive MIS
Reporting To: MIS Manager / Operations Head / Management
Location: Soubhagya Nagar
Employment Type: Full-Time

1. Job Purpose

The Senior Executive – MIS will be responsible for collecting, consolidating, analysing, and reporting business data related to sales, tour bookings, customer enquiries, travel operations, revenue, and team performance. The role will ensure accurate and timely reporting to support management decisions, improve operational efficiency, and monitor business performance.

2. Key Roles and Responsibilities

A. MIS Reporting and Data Management

- Prepare and circulate daily, weekly, and monthly MIS reports for management.
- Maintain accurate databases of sales, bookings, customer enquiries, revenue, cancellations, and refunds.
- Consolidate data from various departments and ensure data accuracy and consistency.
- Develop and maintain standardized reporting formats, dashboards, and trackers.
- Identify data discrepancies and coordinate with relevant teams for timely correction.

B. Sales and Business Performance Analysis

- Prepare sales performance reports for domestic tours, international tours, holiday packages, and other travel services.
- Track leads generated, enquiries received, conversions, booking values, and revenue performance.
- Monitor individual and team-wise sales targets versus actual achievements.
- Analyze lead conversion ratios, lost enquiries, and reasons for non-conversion.
- Prepare business performance summaries and highlight key trends to management.

C. Tour Operations and Booking MIS

- Track confirmed bookings, upcoming departures, tour schedules, and package-wise performance.
- Maintain reports on booking status, cancellations, refunds, and pending customer payments.
- Monitor supplier payments, vendor-related data, and tour-wise cost information,



in coordination with the relevant departments.
- Prepare operational trackers for customer documentation, vouchers, tickets, hotel bookings, and other travel arrangements, as applicable.
- Highlight pending tasks, booking discrepancies, and operational exceptions to the concerned teams.

D. Financial and Revenue Reporting

- Prepare revenue, collection, outstanding payment, and refund reports.
- Track tour-wise and package-wise revenue and costs in coordination with the Finance team.
- Assist in monitoring gross margins and profitability of travel packages.
- Reconcile MIS data with sales and finance records.
- Support management in budgeting, forecasting, and business planning through accurate reports.

E. Dashboard Development and Automation

- Use advanced Excel
- Develop automated reports and dashboards to reduce manual work and improve reporting efficiency.
- Use Power Query and Power BI, where applicable, to streamline data consolidation and visualization.
- Maintain data integrity, confidentiality, and proper documentation of reports.

F. Coordination and Management Support

- Coordinate with Sales, Tour Operations, Reservations, Customer Support, and Finance teams to collect and validate data.
- Ensure reports are shared within defined deadlines.
- Prepare management summaries highlighting achievements, gaps, trends, and areas requiring attention.
- Support management with ad hoc reports, business analysis, and special projects.

3. Required Skills and Competencies

- Robust knowledge of MS Excel and MIS reporting.




- Experience in data analysis, dashboard preparation, and report automation.
- Valuable analytical, numerical, and problem-solving skills.
- Strong attention to detail and data accuracy.
- Ability to manage multiple reports and meet strict deadlines.
- Good communication and interdepartmental coordination skills.
- Knowledge of travel bookings, tour packages, travel operations, or travel CRM systems will be an advantage.

4. Educational Qualifications

- Graduate in Commerce, Business Administration, Statistics, Mathematics, Computer Applications, or a related discipline.
- Additional certification in Advanced Excel, MIS, Data Analytics, or Power BI will be preferred.

5. Experience

- 3–5 years of experience in MIS, reporting, business analysis, or operations reporting.
- Experience in the tours and travel, hospitality, e-commerce, or service industry will be preferred.
- Prior experience in preparing management dashboards and handling large datasets is desirable.

6. Key Performance Indicators (KPIs)

Performance will be evaluated based on:

- Timely submission of daily, weekly, and monthly MIS reports.
- Accuracy and completeness of reports and business data.
- Reduction in manual reporting effort through automation.
- Accuracy of sales, revenue, booking, and collection tracking.
- Timely identification and escalation of discrepancies.
- Effectiveness of dashboards and actionable business insights.
- Coordination and responsiveness to management reporting requirements.

7. Working Relationships

The role will work closely with:

- Sales and Business Development
- Tour Operations and Reservations
- Customer Support
- Finance and Accounts
- Management Team

Bottom of Form

Experience- 3 to 5 years

Salary Offered- 18k- 22k

Kindly drop your resume at: [email protected]

Preferred candidate profile

Perks and benefits

📌 Senior Operations Executive (Bhubaneswar)
🏢 Urban Yatra
📍 Bhubaneswar