Senior Business Analyst
MakeMyTrip · Bengaluru · onsite · Posted 22d ago
Not disclosed3–5 yrsfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
Experience - 3 to 5 yrs
Key Responsibilities
Technical & Domain Skills Required
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.
- 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
- 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.
- 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
- 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.
Sourced from foundit
Skills
power queryssrsdaxGoogle Tag Manageradvanced sqlssasSSISAnalyticsMicrosoft BI StackPythonPower BiSQL ServerMachine Learning
About MakeMyTrip
MakeMyTrip
Internet
2.5k+
employees
2000
26 years old
Gurgaon/Gurugram, Haryana
India
About
MakeMyTrip provides Flight Tickets, Hotels, Holiday Packages, Bus and Train / Railway Reservations for India & International travel.
Industries
Internet
Employee ratings
1,014 reviews
3.4/ 5
Culture
3.4
Career growth
2.9
Work-life
3.5
Employees rate it well for
Work Culture139Work Life Balance127Salary98Senior Management95Learning83
Find them on