Product Analyst

As a Product Analyst at MakeMyTrip, you will play a crucial role in driving business growth through data-driven insights and recommendations. MakeMyTrip, one of India's leading online travel companies, is looking for a mid-senior level Product Analyst to join our team in Gurgaon.

The Product Analyst will be responsible for analyzing large datasets to identify trends, opportunities, and challenges, and developing actionable insights to inform product decisions. You will work closely with cross-functional teams, including product management, marketing, and engineering, to drive product innovation and optimization.

Key Responsibilities:

• Analyze customer behavior, market trends, and competitor activity to identify opportunities for product growth and optimization
• Develop and maintain complex data models to track key performance indicators (KPIs) such as conversion rates, customer acquisition costs, and revenue growth
• Collaborate with product managers to design and implement A/B testing experiments to validate product hypotheses and measure the impact of product changes
• Work with engineers to implement data-driven features and product enhancements, ensuring seamless integration with existing systems
• Conduct market research and competitor analysis to stay up-to-date on industry trends and emerging technologies
• Develop and present data-driven insights and recommendations to senior leadership and stakeholders
• Partner with marketing teams to analyze campaign effectiveness, customer segmentation, and target audience analysis

Requirements:

• 5+ years of experience in product analytics, data analysis, or a related field
• Strong analytical skills, with expertise in statistical modeling, data visualization, and data mining
• Proficiency in SQL, Python, and data visualization tools such as Tableau, Power BI, or D3.js
• Experience with A/B testing tools such as Optimizely, VWO, or Google Optimize
• Strong understanding of product development processes and agile methodologies
• Excellent communication and presentation skills, with ability to distill complex data insights into actionable recommendations
• Bachelor's degree in Computer Science, Statistics, Mathematics, or a related field

Nice to Have:

• Experience with machine learning algorithms and predictive modeling
• Familiarity with cloud-based data platforms such as Google Cloud, AWS, or Azure
• Knowledge of HTML, CSS, and JavaScript for data visualization and web development
• Experience with agile project management tools such as Jira, Asana, or Trello

What We Offer:

• Opportunity to work with a leading online travel company and contribute to its growth and success
• Collaborative and dynamic work environment with a team of experienced professionals
• Competitive salary and benefits package, including health insurance, retirement plan, and paid time off
• Professional development opportunities, including training programs, workshops, and conferences
• Flexible work arrangements, including remote work options and flexible hours

As a Product Analyst at MakeMyTrip, you will have the opportunity to work on complex data analysis projects, develop innovative solutions, and drive business growth through data-driven insights. If you are a motivated and analytical individual with a passion for product development and data analysis, we encourage you to explore this exciting opportunity.

Qualification for Product Analyst at MakeMyTrip

Education:

• Bachelor's degree in Computer Science, Information Technology, or related fields (e.g., B.Tech, B.Sc, BCA) from a recognized university.
• Candidates with degrees in Mathematics, Statistics, or Economics are also considered, provided they have relevant experience in data analysis or software development.

Technical Skills:

• Proficiency in programming languages, specifically:
  • Python ( Pandas, NumPy, Scikit-learn)
  • SQL (data modeling, ETL, data warehousing)
  • Java or C++ (optional)
• Experience with data analysis and visualization tools:
  • Data visualization: Tableau, Power BI, or D3.js
  • Data manipulation: Excel, Google Sheets, or similar tools
• Familiarity with big data technologies:
  • Hadoop ecosystem (HDFS, MapReduce, Hive, Spark)
  • NoSQL databases (e.g., MongoDB, Cassandra)
• Knowledge of cloud-based services:
  • Amazon Web Services (AWS) or Microsoft Azure

Experience:

• Minimum 4-6 years of experience in data analysis, product development, or a related field.
• Proven experience in product analysis, preferably in the travel industry.
• Experience working with large datasets, data modeling, and data visualization.

Product Analysis Skills:

• Strong understanding of product development life cycles and product management principles.
• Experience with product analytics tools:
  • Google Analytics
  • Mixpanel
  • Amplitude
• Ability to analyze complex data sets, identify trends, and draw actionable insights.
• Experience with A/B testing, experimentation, and data-driven decision-making.

Business Acumen:

• Strong understanding of the travel industry, including:
  • Travel booking processes
  • Hotel and flight operations
  • Customer behavior and preferences
• Familiarity with market trends, competitors, and industry analysis.

Soft Skills:

• Excellent communication and interpersonal skills.
• Ability to work effectively with cross-functional teams:
  • Product management
  • Engineering
  • Design
• Strong problem-solving skills, with the ability to analyze complex problems and develop creative solutions.
• Adaptability, with a willingness to learn and take on new challenges.

Tools and Software:

• Familiarity with product management tools:
  • Jira
  • Asana
  • Trello
• Experience with version control systems:
  • Git
  • SVN

Certifications:

• Relevant certifications in data analysis, product management, or a related field are a plus:
  • Certified Data Analyst (CDA)
  • Certified Product Manager (CPM)

Location:

• The role is based in Haryana, India.

Other Requirements:

• Ability to work in a fast-paced environment with multiple priorities and deadlines.
• Willingness to travel occasionally (up to 10-15% of the time).

Nice to Have:

• Experience with machine learning algorithms and natural language processing (NLP).
• Familiarity with cloud-based data warehousing solutions:
  • Amazon Redshift
  • Google BigQuery
• Knowledge of DevOps practices and tools:
  • Jenkins
  • Docker

The ideal candidate will possess a strong analytical mindset, excellent communication skills, and a passion for product development. They will be able to work effectively in a team environment and drive business growth through data-driven insights.

• Develop and maintain a deep understanding of the travel industry, specifically focusing on trends, customer behavior, and market analysis to drive business growth for MakeMyTrip
• Collaborate with cross-functional teams, including product management, marketing, and sales to identify business needs and develop data-driven solutions
• Analyze large datasets to identify patterns, trends, and correlations that can inform product decisions, using tools such as SQL, Excel, and data visualization software
• Design, develop, and maintain complex data models to support business intelligence and analytics, ensuring data quality and integrity
• Provide actionable insights and recommendations to stakeholders, including product managers, marketing teams, and senior leadership, to drive business outcomes
• Develop and maintain dashboards, reports, and other analytics tools to track key performance indicators (KPIs) and business metrics
• Conduct A/B testing and experimentation to measure the impact of product changes and identify areas for improvement
• Work closely with product managers to define product requirements and prioritize features based on data-driven insights
• Develop and maintain a thorough understanding of MakeMyTrip's products and services, including flights, hotels, packages, and bus bookings
• Analyze customer feedback and sentiment to identify areas for improvement and opportunities to enhance the customer experience
• Stay up-to-date with industry trends and emerging technologies, including machine learning, artificial intelligence, and data science
• Collaborate with data engineers to design and implement data pipelines and architectures that support business intelligence and analytics
• Develop and maintain technical documentation of data models, dashboards, and analytics tools
• Work with stakeholders to identify and prioritize business problems to be solved through data analysis and product development
• Develop and maintain relationships with key stakeholders, including product managers, marketing teams, and senior leadership
• Provide training and support to stakeholders on the use of analytics tools and data analysis
• Participate in the development of the product roadmap, providing input on data-driven insights and business outcomes
• Conduct market research and competitor analysis to stay informed about industry trends and emerging technologies
• Develop and maintain a thorough understanding of MakeMyTrip's target markets, including customer demographics, behavior, and preferences
• Analyze data to identify opportunities to improve customer engagement, conversion, and retention
• Collaborate with marketing teams to develop targeted marketing campaigns and promotions
• Develop and maintain a thorough understanding of MakeMyTrip's revenue management systems and pricing strategies
• Work with stakeholders to develop and implement pricing strategies that drive business outcomes
• Participate in the development of business cases and proposals for new product development and initiatives
• Develop and maintain a thorough understanding of MakeMyTrip's data governance policies and procedures
• Ensure compliance with data governance policies and procedures in all analytics and product development work
• Stay current with emerging trends and technologies in data analysis, machine learning, and artificial intelligence
• Develop and maintain a network of contacts within the industry, including peers, thought leaders, and experts
• Participate in industry conferences, webinars, and other events to stay informed about emerging trends and technologies
• Develop and maintain a thorough understanding of MakeMyTrip's corporate strategy and goals
• Work with stakeholders to develop and implement strategies that drive business outcomes and achieve corporate goals.
• Travel to different locations (India and International) for onsite meetings, workshops and conferences as required.
• Perform other duties as assigned by the supervisor or manager.
• Contribute to the development of the team and share knowledge with junior team members.

• Resume & Profile Screening

• HR and the Product Analytics hiring team scan for 3‑5 years of experience in data‑driven product roles, preferably within travel, e‑commerce, or SaaS.

• Look for proven impact on product decisions (e.g., “increased conversion by 12% through cohort analysis”).

• Technical stack expectations: strong SQL (CTE, window functions), Python/R for statistical modeling, and familiarity with BI tools such as Tableau, PowerBI, or Looker.

• Highlight any exposure to A/B testing frameworks, product metrics design, and stakeholder management across engineering, design, and marketing.

• Initial HR Phone Conversation (15‑20 min)

• Focuses on cultural fit with MakeMyTrip’s “customer‑first” ethos and the fast‑paced, data‑centric environment of the Haryana office.

• Expect questions about your motivation for the travel industry, willingness to work cross‑functionally, and ability to handle ambiguous problems.

• HR will verify logistical details (notice period, relocation willingness, salary expectations) and outline the subsequent interview cadence.

• Technical Screening – Live SQL Exercise (45‑60 min)

• Conducted via a shared screen on a virtual whiteboard (e.g., Miro or Google Docs).

• Candidates receive a realistic dataset (booking logs, user sessions, pricing tables) and must write queries to extract insights such as “top 5 cities with highest booking cancellations in the last quarter.”

• Evaluation criteria: query correctness, optimization (indexes, avoiding sub‑queries), readability, and ability to explain the logic step‑by‑step.

• Data‑Science Case Study (90‑120 min)

• A take‑home or live problem mimicking a real MakeMyTrip product challenge (e.g., “Diagnose a sudden dip in flight search conversions”).

• Required deliverables: data cleaning plan, exploratory analysis, hypothesis generation, statistical testing (t‑test, chi‑square), and a concise recommendation deck.

• Emphasis on storytelling: clear visualizations, actionable insights, and alignment with business goals (revenue, NPS, churn).

• Product Sense & Metrics Interview (60 min)

• Conducted by senior product managers and a lead analyst.

• Questions probe your ability to define and prioritize product metrics (e.g., “What is the North Star metric for a flight‑search experience?”).

• Expect scenario‑based prompts: redesign the “price‑alert” feature, improve “search‑to‑booking” funnel, or evaluate a new “bundle‑offer” experiment.

• Assessment looks for structured thinking, trade‑off analysis, and awareness of MakeMyTrip’s competitive landscape (e.g., OTA vs. direct airline APIs).

• Advanced Analytics & Modeling Interview (60 min)

• Led by the Head of Analytics or a senior data scientist.

• Dive deep into predictive modeling (e.g., demand forecasting, propensity to purchase).

• Discuss model selection, feature engineering (seasonality, geo‑demographics), validation techniques, and deployment considerations (real‑time scoring vs. batch).

• Candidates may be asked to sketch a regression or time‑series model on a virtual whiteboard and explain assumptions.

• Stakeholder Management & Leadership Round (45‑60 min)

• Panel includes engineering lead, UX designer, and a senior business stakeholder.

• Focus on collaboration stories: how you translated ambiguous data into product road‑maps, handled conflicting priorities, and drove consensus.

• Behavioral probes: “Tell us about a time you challenged a product decision with data,” “How do you mentor junior analysts?”

• Final Senior Leadership Interview (30‑45 min)

• One‑on‑one with the Director of Product Analytics or VP of Product.

• High‑level strategic discussion: vision for analytics in the travel domain, emerging trends (AI‑driven personalization, dynamic pricing), and how you would contribute to MakeMyTrip’s growth targets for FY 2025‑26.

• Opportunity for you to ask deep‑dive questions about data infrastructure, roadmap autonomy, and cross‑regional collaboration (Bangalore, Delhi, and international teams).

• Offer Review & Acceptance

• Compensation package discussion includes base salary, performance‑linked bonus, equity component, and benefits (health, travel perks, learning budget).

• HR will outline onboarding timeline, relocation assistance for Haryana, and the first‑90‑day success plan.

How to Prepare Effectively for Each Stage

• Deep Dive into MakeMyTrip’s Product Suite

• Use the public website, app, and recent press releases to map core products: flight search, hotel booking, holiday packages, and emerging services (e.g., “Instant Refund”).

• Identify key performance indicators for each vertical (conversion rate, average order value, booking abandonment, repeat purchase frequency).

• Master the Required Technical Stack

• Practice complex SQL queries on publicly available travel datasets (e.g., OpenFlights, Kaggle flight‑price data). Emphasize window functions, CTEs, and performance tuning.

• Refresh Python libraries: pandas for data manipulation, scikit‑learn for modeling, and matplotlib/seaborn for visualization. Build a mini‑project that predicts booking likelihood from user session data.

• Build a Portfolio of Real‑World Case Studies

• Document end‑to‑end analyses: problem statement, data pipeline, insights, and business impact. Use a clean slide deck format (title, methodology, key charts, recommendation).

• Highlight any experience with A/B testing platforms (Optimizely, LaunchDarkly) and statistical rigor (confidence intervals, power analysis).

• Polish Product‑Sense Frameworks

• Adopt the “CIRCLES” method (Comprehend, Identify, Report, Cut, List, Evaluate, Summarize) for product design questions.

• Prepare metric trees for typical travel features (search latency → conversion, price‑alert click‑through → revenue uplift).

• Simulate Stakeholder Conversations

• Role‑play scenarios where you must explain a technical finding to a non‑technical product manager. Focus on concise storytelling, visual aids, and linking data to revenue or user experience.

• Prepare examples of conflict resolution: data contradicting a product hypothesis, and how you navigated the discussion.

• Stay Updated on Industry Trends

• Follow travel‑tech newsletters (Skift, Phocuswright) and recent MakeMyTrip earnings calls to understand market pressures (fuel price volatility, regulatory changes).

• Be ready to discuss how emerging AI personalization or dynamic pricing could be operationalized within MakeMyTrip’s existing data pipelines.

• Mock Interviews & Time Management

• Schedule at least two full‑length mock interviews covering SQL, case study, and product sense with peers or mentors. Record and review for clarity and pacing.

• For live exercises, practice thinking aloud while coding; interviewers value transparent problem‑solving over silent perfection.

• Prepare Thoughtful Questions for Interviewers

• Inquire about data infrastructure (Snowflake vs. Redshift), model deployment pipelines (Airflow, Kubeflow), and cross‑functional cadence (weekly analytics syncs).

• Ask about growth opportunities specific to the Haryana office: mentorship programs, exposure to international markets, and roadmap ownership.

• Logistics & Mindset

• Ensure a quiet, stable internet connection and a dual‑monitor setup for coding and note‑taking.

• Adopt a growth mindset: treat each interview as a data point, collect feedback, iterate on your approach, and maintain confidence in your analytical storytelling abilities.

• Company Overview

• MakeMyTrip, founded in 2000, is India’s leading online travel company, offering a full suite of travel services including flight bookings, hotel reservations, holiday packages, and corporate travel solutions.

• Headquartered in Gurgaon, Haryana, the company operates across 25+ countries and serves over 30 million customers annually, processing more than 1.2 billion transactions to date.

• Recognized as a pioneer in the Indian travel tech space, MakeMyTrip holds a market share of approximately 35 % in the domestic online travel segment, with a strong foothold in both consumer and B2B segments.

• Strategic Vision & Mission

• Vision: To become the most trusted and innovative travel platform that empowers every traveler to explore the world effortlessly.

• Mission: Deliver seamless, personalized travel experiences through cutting‑edge technology, data‑driven insights, and a customer‑first mindset.

• The company’s long‑term roadmap includes expanding its AI‑powered recommendation engine, deepening its presence in tier‑2 and tier‑3 Indian cities, and launching a suite of sustainable travel products.

• Core Values in Practice

• Customer Obsession – Real‑time support centers in Gurgaon and Hyderabad handle over 150,000 tickets daily, with a 96 % satisfaction rating.

• Innovation – A dedicated “Innovation Lab” in Haryana prototypes voice‑activated booking, blockchain‑based loyalty, and dynamic pricing algorithms that reduce fare volatility by up to 12 %.

• Ownership – Employees are given “impact budgets” of INR 2 lakh per quarter to fund small‑scale experiments that improve internal processes or customer touchpoints.

• Transparency – Quarterly “All‑Hands” meetings broadcast live to all offices, featuring open Q&A with the CEO and product leads, and detailed KPI dashboards accessible to every employee.

• Work Culture & Environment

• Open‑plan campuses in Gurgaon feature collaborative zones, quiet pods, and a 24/7 cafeteria serving a rotating menu of regional Indian cuisines and international dishes.

• Flexible work arrangements: 70 % of roles allow hybrid schedules, with a minimum of two days per week in‑office to foster cross‑functional collaboration.

• “Hackathon Fridays” every month encourage engineers, data scientists, and product managers to form cross‑disciplinary teams and deliver a prototype within 48 hours; winning projects receive seed funding and mentorship.

• Employee Resource Groups (ERGs) for Women in Tech, LGBTQ+, and veterans drive mentorship programs, host quarterly speaker series, and influence policy updates.

• Technology Stack & Engineering Excellence

• Front‑end: React.js with Next.js for server‑side rendering, leveraging GraphQL for efficient data fetching across mobile and web platforms.

• Back‑end: Micro‑service architecture built on Java Spring Boot and Node.js, orchestrated via Kubernetes on a hybrid cloud environment (AWS + on‑premise data centers).

• Data & Analytics: Real‑time streaming pipelines using Apache Kafka, data lake on Amazon S3, and analytics powered by Snowflake and Looker for business intelligence.

• AI & ML: Recommendation engines use TensorFlow and PyTorch models trained on 10 TB of historical booking data, delivering personalized itinerary suggestions with a 15 % uplift in conversion.

• Security: ISO 27001 certified, with continuous penetration testing, automated compliance checks, and a dedicated Security Operations Center (SOC) monitoring 24/7.

• Product Portfolio & Market Reach

• Consumer Travel – Flight, hotel, bus, and rail bookings integrated into a single UI, with over 30 million active users in India alone.

• Corporate Travel – MakeMyTrip for Business offers policy‑compliant booking, expense integration with SAP Concur, and a dedicated account management team handling 12,000+ enterprise clients.

• Experiences & Activities – Partnerships with over 5,000 local experience providers, enabling users to book tours, adventure sports, and cultural events directly from the platform.

• International Expansion – Offices in Singapore, Dubai, and the United Kingdom support cross‑border travel, with localized payment gateways handling 150+ currencies.

• Talent Development & Learning Opportunities

• “MakeMyTrip Academy” provides over 200 internal courses covering cloud architecture, data science, product design, and leadership, with certifications recognized across the industry.

• Annual “Leadership Sprint” program selects high‑potential employees for a 6‑month rotational stint across product, engineering, and operations, culminating in a capstone project presented to the executive board.

• Tuition reimbursement up to INR 1.5 lakh per year for employees pursuing advanced degrees or industry‑recognized certifications (e.g., AWS Certified Solutions Architect, PMP).

• Mentorship circles pair junior staff with senior leaders for bi‑weekly coaching sessions, focusing on career pathing, technical depth, and soft‑skill development.

• Compensation, Benefits & Well‑Being

• Competitive salary structures benchmarked against top Indian tech firms, with performance‑linked bonuses averaging 20 % of base pay.

• Equity grants: Employees receive stock options vesting over four years, aligning personal success with company growth.

• Health & wellness: Comprehensive medical coverage (including mental health counseling), on‑site yoga classes, and a wellness allowance of INR 5,000 per month for fitness or nutrition subscriptions.

• Family‑friendly policies: 26 days of paid leave, 12 weeks of fully paid maternity leave, and a “Parenting Support” program offering childcare subsidies and flexible return‑to‑work plans.

• Corporate Social Responsibility & Sustainability

• “Travel Green” initiative partners with airlines and hotels to promote carbon‑offset programs, offering travelers the option to contribute to reforestation projects; over 2 million trees planted since 2018.

• Community outreach: Annual “MakeMyTrip Scholars” program funds scholarships for 500 under‑privileged students in Haryana, focusing on STEM education.

• Diversity & Inclusion metrics publicly disclosed in the annual sustainability report, showing a 30 % increase in women in technical roles over the past three years.

• Recognition & Awards

• Winner of the “Best Online Travel Agency” at the India Travel Awards 2023 for three consecutive years.

• Ranked #4 in “Great Place to Work® India” 2022, based on employee feedback on culture, leadership, and growth opportunities.

• Received the “Data Innovation Excellence” award from the Data Analytics Association for its predictive pricing engine that reduced fare discrepancies by 18 %.

• Future Outlook & Growth Trajectory

• Planned rollout of a “Travel‑as‑a‑Service” (TaaS) platform targeting SMBs, leveraging API‑first architecture to enable third‑party integration.

• Investment of INR 1 billion over the next two years in AI research labs focused on natural language processing for multilingual customer support across 12 Indian languages.

• Strategic partnership with a leading fintech firm to introduce a “Buy‑Now‑Pay‑Later” (BNPL) option for travel bookings, projected to increase average order value by 9 %.

• Leadership Team & Governance

• Founder & CEO: Deep Kalra, a veteran entrepreneur with a background in investment banking and a track record of scaling tech startups.

• CTO: Anjali Mehta, former senior architect at a global e‑commerce giant, leading the transition to a cloud‑native, micro‑service ecosystem.

• Board of Directors includes representatives from major venture capital firms, ensuring robust governance and strategic oversight.

• Employee Experience Highlights Specific to Haryana

• Proximity to Delhi’s international airport enables seamless travel for business trips and client visits.

• Collaboration with local universities (e.g., Maharishi Dayanand University) for internship pipelines and joint research projects in travel analytics.

• Haryana‑based employee wellness hub offers a 5,000 sq ft gym, meditation rooms, and a rooftop garden used for team‑building activities and seasonal festivals.

These points collectively portray MakeMyTrip’s robust market position, innovative culture, technology leadership, and commitment to employee growth and societal impact, providing a comprehensive snapshot for prospective talent interested in joining the organization in Haryana.