Marketing Analytics

Role: Marketing Analytics

Level: Senior Executive

Reporting To: Senior Manager

Location: Gurugram

About the Function

The Marketing function at MakeMyTrip is responsible for building a strong brand presence, driving customer acquisition, and maximizing engagement across all channels. By combining creativity with data-driven insights, the team designs and executes targeted campaigns that deliver measurable business impact.

Within this, the Customer Lifecycle Marketing (CLM) team owns the strategy and execution of end-to-end lifecycle initiatives across the customer journey- onboarding, engagement, retention, and loyalty. The team focuses on maximizing customer lifetime value (LTV) through data-driven, personalized marketing interventions.

About the role:

This role will own the analytics charter for the CLM team, combining strong technical expertise with business understanding to support data-driven decisions. Key responsibilities include hands-on data analysis, dashboard development, reporting automation, and translating findings into actionable business insights.

As the teams primary technical analytics resource, the individual will independently drive projects end to endfrom data extraction and processing to analysis, automation, and recommendations. Success in this role requires strong SQL and Python skills, a proactive approach to identifying opportunities and solving problems, and the ability to guide

stakeholders with clear, relevant insights.

What will you be doing

1. Data Analytics and Business Insights

• Analyse customer behaviour, business performance and campaign results to identify trends and improvement opportunities.
• Perform customer segmentation, persona identification and cohort analysis to understand customer behaviour, engagement and retention.
• Analyse funnels, conversions and channel performance to identify gaps and opportunities, and recommend actions to improve business outcomes.

2. Dashboarding & Reporting Automation

• Build, automate and maintain business dashboards covering key acquisition, engagement, retention and performance metrics.
• Use SQL and Python to extract, clean, process and analyse large datasets.
• Develop automated reporting workflows to streamline recurring analysis, reduce manual effort and improve reporting efficiency.
• Ensure data accuracy, consistency and timely delivery of reports, proactively identifying and resolving discrepancies.

3. Campaign & Project Analytics

• Develop measurement frameworks and track the performance of marketing campaigns, customer journeys and business initiatives.
• Evaluate performance across key metrics such as traffic, searches, conversions, bookings and revenue.
• Conduct post-campaign analysis, identify performance drivers and provide recommendations for future improvements.

4. End-to-End Project Ownership

• I

  ndependently own analytical projects from requirement gathering and problem definition to execution, delivery and recommendations.
• Proactively identify analytical opportunities, process gaps and areas that can be improved through automation.
• Work with cross-functional teams, including Marketing, Product, Technology and Data, to drive analytical projects and resolve dependencies. Guide business stakeholders on analytical requirements, data interpretation and possible solutions.\
• Proactively communicate project progress, timelines, risks and dependencies, ensuringtimely delivery

Qualification & Experience

• Bachelors degree in Engineering, Computer Science, Statistics, Mathematics, Economics, or a related quantitative field with 24 years of experience in data, business, or marketing analytics, or a similar role.
• Strong SQL skills, including complex queries, joins, CTEs, and analysis of large datasets.
• Hands-on experience using Python for data manipulation, analysis, and automation; familiarity with Pandas and NumPy is preferred.
• Strong Excel skills and experience with visualization tools such as Tableau, Power BI, or Looker.
• Familiarity with Adobe Analytics, Google Analytics, or Mixpanel is an advantage.
• Strong analytical, problem-solving, and communication skills.

Key Success Factors for the Role:

• Technical Expertise: Ability to independently work with SQL and Python, automate analytical processes and build scalable reporting solutions.
• Ownership & Accountability: Take complete ownership of projects and deliverables, from conceptualization to execution, without requiring constant supervision.
• Proactiveness: A self-driven go-getter who identifies problems, flags gaps, anticipates requirements and takes initiative to solve them.
• Business Acumen: Understand business objectives and translate data into meaningful insights and actionable recommendations.
• Stakeholder Management: Communicate effectively, proactively share updates and guide business teams on analytical requirements and solutions.
• Continuous Improvement: Identify opportunities to simplify processes, improve reporting efficiency and adopt better analytical approaches and tools.