Data Analyst Job at MakeMyTrip – Bengaluru (On-site, Full-Time)

MakeMyTrip; Bengaluru; On-site; INR 700,000 - 1,200,000; Full time

Benefits offered by this job

Competitive compensation

Growth opportunities in analytics

Collaborative work culture

Job summary

MakeMyTrip, India’s leading online travel company, is hiring a Data Analyst for its Bengaluru office. This role involves transforming raw data into actionable insights and working with cross-functional teams in a fast-paced environment.

The ideal candidate should have strong skills in SQL, advanced Excel, and data visualization tools like Tableau. You'll be responsible for complex reporting and data integrity management while driving business decisions through analytics.

This is an on-site position, providing an opportunity to work with large datasets in a leading technology hub.

Qualifications

• Strong proficiency in SQL for querying and analyzing large datasets.
• Advanced Excel expertise, including pivot tables and complex formulas.
• Experience with BI tools like Tableau and Power BI.

Responsibilities

• Design, develop, and maintain MIS and DWM reports.
• Create intuitive dashboards and visual reports for stakeholders.
• Automate repetitive reporting tasks to improve efficiency.

Skills

SQL

Advanced Excel

Data Visualization

MIS Reporting

Analytics and Problem-Solving Skills

Education

Bachelor’s degree in Engineering, Computer Science, Statistics, Mathematics, Economics

Tools

Tableau

Power BI

Looker

Job description

Company: MakeMyTrip

Job Title: Data Analyst

Location: Bengaluru, Karnataka, India

Job Type: Full-Time | On-site

Industry: Travel & Technology

MakeMyTrip, India’s leading online travel company, is hiring a Data Analyst for its Bengaluru office. This role is ideal for professionals who excel at transforming raw data into actionable business insights and enjoy working closely with cross‑functional stakeholders in a fast‑paced, data‑driven environment.

If you are highly skilled in SQL, Advanced Excel, MIS reporting, dashboards, and data visualization, this opportunity offers the chance to work with large‑scale datasets and contribute directly to strategic business decisions at one of India’s most recognizable digital brands.

About MakeMyTrip

MakeMyTrip is a pioneer in India’s online travel ecosystem, offering comprehensive travel services including flight bookings, hotels, holiday packages, rail, bus, and cab services. With millions of users and vast volumes of transactional data, MakeMyTrip relies heavily on analytics and business intelligence to enhance customer experience, optimise operations, and drive growth.

Joining MakeMyTrip means working in a high‑impact analytics role where data is central to decision‑making.

Key Responsibilities

As a Data Analyst at MakeMyTrip, you will be responsible for the following core functions:

Advanced Reporting & MIS

• Design, develop, and maintain complex MIS and DWM reports using advanced logic and structured reporting frameworks.
• Translate large datasets into clear, actionable insights that support business and operational teams.
• Ensure reports are accurate, timely, and aligned with business objectives.

Data Visualization & Storytelling

• Create intuitive dashboards and visual reports using Excel or BI tools such as Tableau, Power BI, or Looker.
• Present data in a simplified and compelling manner for non‑technical stakeholders.
• Enable leadership teams to quickly interpret trends, KPIs, and performance metrics.

Process Automation

• Identify repetitive manual reporting or data‑handling tasks and automate them using Macros, VBA, or advanced Excel formulas.
• Reduce reporting turnaround time and improve operational efficiency.
• Continuously improve existing workflows through automation and optimisation.

Data Integrity & Quality Management

• Act as the gatekeeper of data accuracy and consistency.
• Perform detailed data reconciliation, validation, and quality checks before publishing reports.
• Investigate data discrepancies and ensure a single source of truth across reports and dashboards.

Required Skills & Competencies

To succeed in this role, candidates should have the following skills:

• Strong proficiency in SQL for querying, extracting, and analysing large datasets.
• Advanced Excel expertise, including pivot tables, complex formulas, charts, and automation techniques.
• Hands‑on experience with BI and data visualization tools such as Tableau, Power BI, Looker, or similar platforms.
• Excellent analytical and problem‑solving skills with strong attention to detail.
• Ability to work efficiently with high‑volume data and generate meaningful business insights.
• Strong communication and presentation skills, enabling effective collaboration with business stakeholders.

Preferred Qualifications

While not mandatory, the following qualifications will be an added advantage:

• Bachelor’s degree in Engineering, Computer Science, Statistics, Mathematics, Economics, or a related quantitative discipline.
• Prior experience in MIS reporting, dashboard development, or business analytics roles.
• Working knowledge of Python or R for data analysis and automation (good to have).

Why Work at MakeMyTrip?

• Opportunity to work with large‑scale, real‑world datasets in a leading consumer internet company.
• High‑visibility role with direct impact on business decisions.
• Exposure to advanced analytics, reporting, and automation use cases.
• Collaborative work culture with strong learning and growth opportunities.
• Competitive compensation and long‑term career prospects in analytics and data science.

Job Location

This is an on‑site role based in Bengaluru, Karnataka, one of India’s leading technology and analytics hubs.

How to Apply

Interested candidates can apply directly through the job listing website below:

Apply Now.

Make sure your resume highlights your experience with SQL, Advanced Excel, dashboards, MIS reporting, automation, along with measurable business outcomes from your previous roles.