Senior Operations Executive

Urban Yatra; Khordha; On-site; INR 201,000 - 246,000; Full time

Job summary

Urban Yatra invites applications for the Senior Executive – MIS role based in Soubhagya Nagar. The incumbent will collect, consolidate, analyze, and report data on sales, tour bookings, customer enquiries, operations, revenue, and team performance to support management decisions and drive efficiency.

The position requires strong MS Excel, MIS reporting, data analysis, and dashboard skills, with experience in Power BI and Power Query.

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.

Responsibilities

• Prepare daily, weekly, and monthly MIS reports for management.
• Maintain databases of sales, bookings, revenue, and refunds.
• Consolidate data from multiple departments and ensure accuracy.
• Develop standardized reporting formats, dashboards, and trackers.
• Identify data discrepancies and coordinate with teams for correction.
• Prepare sales performance reports for domestic and international tours and other services.
• Track leads, enquiries, conversions, booking values, and revenue.
• Monitor sales targets vs actuals and analyze conversion rates.
• Maintain reports on bookings, status, cancellations, and payments.
• Prepare operational trackers for documentation, vouchers, tickets, and travel arrangements.
• Highlight pending tasks and discrepancies to relevant teams.
• Prepare revenue, collection, and refund reports and assist in budgeting and forecasting.
• Develop automated reports and dashboards to reduce manual work.

Skills

MS Excel

MIS reporting

Data analysis

Dashboard preparation

Automation

Communication

Interdepartmental coordination

Education

Graduate in Commerce

Certs in Advanced Excel / MIS / Data Analytics / Power BI

Tools

Power BI

Power Query

Excel

Job description

Role & responsibilities

Company Name: Urban YatraDepartment: MIS / Business OperationsDesignation: Senior Executive MISReporting To: MIS Manager / Operations Head / ManagementLocation: Soubhagya NagarEmployment 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

• Strong knowledge of MS Excel and MIS reporting.
• Experience in data analysis, dashboard preparation, and report automation.
• Good 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

Experience- 3 to 5 years

Salary Offered- 18k- 22k