Search by job, company or skills

Senior Business Analyst

Senior Business Analyst

Makemytrip.Com
3-5 Years
Not Disclosed
Early Applicant
  • Posted 24 days ago
  • Over 50 applicants have applied

Job Description

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.

More Info

Job Type:
Industry:
Employment Type:

About Company

Similar Jobs

2-4 yrs
Bengaluru, India
Skills:
Numpy, Pandas, Power Bi, Data Visualization, Tableau, Python, Sql, AWS, Synapse, Scikit-learn, Azure Fabric
5-7 yrs
Bengaluru, India
Skills:
Power Bi, Data Governance, Sql, OneLake, Lakehouse, Fabric Warehouses, Azure Data Platform, Dataflows Gen2, data quality management, master data management, Microsoft Fabric
5-7 yrs
Bengaluru, India
Skills:
Power Bi, Power Automate, Data Modeling, Data Warehousing, Power Query, Sql, Dimensional Modeling, Vba, Data Cleansing, Dax, Python, Semantic models, AI and generative AI, Data-quality validation, Power BI Service, ETL processes, Star schemas
6-8 yrs
Bengaluru, India
Skills:
Power Bi, Tableau, Excel, Data Analytics, Sql, Salesforce, Clari, CRM
4-6 yrs
Bengaluru, India
Skills:
user requirements , Power Bi, Wireframes, Jira, Sql Queries, Coding, Agile, Use cases, Excel, Sprint organization and planning, Process flows, onenote, Microsoft Suite of Products, Modeling, Teams, Replicon, Process Design