Senior Business Analyst

MakeMyTrip; Bengaluru; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

MakeMyTrip is seeking a seasoned Data Analytics Leader to drive advanced analytics, modeling and RCA across travel platforms. You will own BI engineering, data architecture, and stakeholder engagement to translate data insights into product improvements.

The role requires 3–5 years in analytics, strong SQL (TSQL), Python for EDA, and experience with MS BI Stack and modern product analytics tools like GA/GTM. Bengaluru-based, full-time, on-site.

Qualifications

• Experience 3–5 years in analytics or product analytics.
• Strong SQL optimization and data querying skills.
• Hands-on Python for EDA and ML basics.

Responsibilities

• Lead RCAs on business shifts and deliver strategic interventions.
• Oversee data visualization with Power BI and maintain data quality.
• Mentor analytics team and collaborate with product, BD, and engineering.
• Analyze revenue, pricing, funnels, and loyalty campaigns to optimize performance.

Skills

Advanced SQL & T-SQL

Python for EDA

MSBI Stack (SSIS SSAS SSRS)

Product Analytics Tracking (GA/GTM)

Tools

Power BI

SSIS/SSAS/SSRS

Google Analytics / GTM

Job description

• Advanced SQL & T-SQL : Expert-level database query optimization, view creation, and deep structured analytical querying
• Advanced Programming : Hands-on capability in Python for exploratory data analysis (EDA), hypothesis testing, and implementing fundamental Machine Learning (ML) models
• Microsoft BI Stack : Solid foundation across SSIS, SSAS, and SSRS ecosystems
• Modern Product Analytics : Experience tracking user behavior via Google Analytics, Google Tag Manager, or clickstream events is highly preferred.

Experience - 3 to 5 yrs

Key Responsibilities

Technical & Domain Skills Required

• Advanced SQL & T-SQL : Expert-level database query optimization, view creation, and deep structured analytical querying
• Advanced Programming : Hands-on capability in Python for exploratory data analysis (EDA), hypothesis testing, and implementing fundamental Machine Learning (ML) models
• Microsoft BI Stack : Solid foundation across SSIS, SSAS, and SSRS ecosystems
• Modern Product Analytics : Experience tracking user behavior via Google Analytics, Google Tag Manager, or clickstream events is highly preferred.

1. Advanced Analytics, Modeling & RCA

• Root-Cause Analysis (RCA): Lead complex RCAs on volatile business shifts (e.g., sudden booking drops or cancellation spikes) and deliver quick-turnaround strategic interventions
• Rule Based Frameworks: Apply cohort analysis, funnel tracking, and statistical forecasting techniques to predict peak seasonal travel demand
• Advanced Decision Models: Build heuristic and predictive data models to unlock alternative ancillary revenue streams and operational efficiencies

2. BI Engineering & Data Architecture Management

• Data Visualization Integration: Oversee the construction of enterprise-level Power BI dashboards utilizing complex DAX logic and Power Query to surface executive-level insights
• ETL Pipeline Governance: Supervise the development and continuous execution of data pipelines using SSIS, SSAS, or modern data orchestrators
• Data Quality Assurance: Maintain ownership over data modeling, transformation structures, SQL views, and procedures to guarantee data validity.

3. Team Leadership & Stakeholder Management

• Team Mentorship : Lead, mentor, and define performance benchmarks for a high-performing team of data analysts.
• Cross-Functional Collaboration : Act as the primary consultant for Product Managers, Business Development heads, and Engineering teams to transform raw analytics into real feature deployments

4. Strategic Business Drive & Domain Analytics

• Revenue & Pricing Optimization: Analyze demand-supply gaps, inventory utilization patterns, and dynamic pricing effectiveness across routes and geographies
• Conversion & Funnel Management: Deep-dive into customer checkout cohorts, shopping cart drop-offs, and cancellation bottlenecks to drive user retention
• Campaign & Loyalty Analysis: Partner with marketing teams to design, track, and optimize customer rewards and sales promotion campaigns.