Job Description
Unlock the Science of Travel.
As an Associate Data Analyst, you will act as the “Intelligence Hub” for your team. Agoda is famous for its experimentation culture, meaning you will likely spend a significant amount of your time designing and analyzing A/B tests to see what truly makes travelers click “Book Now.”
✨ Job Highlights & Quick Details
| Detail | Information |
| Role Name | Associate Data Analyst |
| Location | Pune, Maharashtra |
| Industry | Travel Tech / E-commerce / SaaS |
| Qualification | Bachelor’s Degree (Math, Stats, CS, Econ, or Business) |
| Experience | Fresher – 1 Year (2025/2026 Batch) |
| Salary (CTC) | ₹7.0 – ₹12.0 LPA (Performance bonuses + Travel perks) |
| Core Skills | SQL, Excel, Data Visualization (Tableau/Metabase), Statistics |
Keyword Focus: Agoda Pune Hiring 2026, Associate Data Analyst Freshers Agoda, Agoda Recruitment Process 2026, Travel Tech Data Analyst Jobs, SQL Interview Questions for Agoda.
💡 The Role: From Raw Data to Global Insights
Agoda moves fast. Your role is to ensure that the speed of business doesn’t outpace the accuracy of its data.
- KPI Tracking: Developing and maintaining automated dashboards to monitor business health (Conversion rates, Take rates, Cancellation trends).
- Experimentation (A/B Testing): Determining if a new feature is successful by calculating statistical significance. You might use the Z-score formula to compare conversion rates:$$Z = \frac{(\hat{p}_1 – \hat{p}_2)}{\sqrt{\hat{p}(1-\hat{p})(\frac{1}{n_1} + \frac{1}{n_2})}}$$
- Deep-Dive Analysis: Investigating “Why” something happened—for example, why hotel bookings dropped in a specific region—and presenting findings to stakeholders.
- Data Cleaning: Working with engineers to ensure the data pipelines feeding into your reports are clean and reliable.
📝 Selection Process: The Agoda “Metrics” Mindset
Agoda values logical scalability. They want to see if you can handle large datasets without losing sight of the business objective.
- Stage 1: Online Analytical Assessment:
- Numerical Reasoning: Fast-paced math and data interpretation.
- SQL Test: Usually 2–3 queries involving JOINs, GROUP BY, and perhaps a Window Function.
- Stage 2: Technical Interview (Case Study):
- You’ll be given a business problem. Example: “We want to launch a ‘Free Breakfast’ filter. How would you measure its success?”
- Focus on your ability to define clear metrics (North Star Metric vs. Guardrail Metrics).
- Stage 3: SQL & Data Manipulation Round:
- Live coding or deep-dive into how you would clean a messy dataset using Python (Pandas) or SQL.
- Stage 4: Culture Fit / Managerial Round:
- Agoda is a “Direct” culture. They value ownership, speed, and the ability to accept constructive feedback on your data models.
➡️ How to Apply for Agoda
- Official Portal: Apply directly through the careers page: Apply Now – Agoda Off Campus.
- Resume Tip: Agoda loves Quantifiable Achievements. Instead of saying “Analysed data,” say “Identified a 5% drop in conversion using SQL analysis, leading to a UI fix.”
- Master SQL: This is non-negotiable. Be extremely comfortable with
LEFT JOINvsINNER JOINandCASE WHENstatements. - Travel Passion: In the interview, show that you understand the travel industry. Mentioning trends like “Bleisure” (Business + Leisure) or the impact of dynamic pricing shows you’re thinking like a business owner.