
Agoda Business Analyst interview typically runs 5 rounds: recruiter screen, technical interview, case study, second technical interview, and conceptual assessment. It usually takes several weeks and is notably multi-stage.
$76K
Avg. Base Comp
$115K
Avg. Total Comp
5
Typical Rounds
3-6 weeks
Process Length
Our candidates report that Agoda is looking for business analysts who can move comfortably between execution and judgment. The SQL portion is practical rather than theoretical: the emphasis is on whether you can work cleanly with larger datasets and use the core building blocks you’d actually reach for on the job, like CTEs, joins, and unions. But that’s only part of the picture. A recurring theme is that the company also wants to see how you think about the business, especially in a travel context, where the case work leans on Excel and PowerPoint and rewards candidates who can turn analysis into a clear recommendation.
What stands out most is the split between hands-on data fluency and fine-grained conceptual precision. Multiple candidates noted that the later conceptual assessment felt more microscopic than expected, with syntax questions that were unusually detailed. That tells us Agoda is not just screening for people who can get to an answer, but for people who are careful with the mechanics and can defend their reasoning when the questions get specific. In our view, the candidates who do best here are the ones who stay steady across formats: they can handle a straightforward SQL task, then switch into a more qualitative discussion without losing rigor.
Synthetized from 1 candidates reports by our editorial team.
Had an interview recently?
Share your experience. Unlock the full guide.
Real interview reports from people who went through the Agoda process.
Share your own interview experience to unlock all reports, or subscribe for full access.
Sourced from candidate reports and verified by our team.
Topics based on recent interview experiences.
| Question | |
|---|---|
| P-value to a Layman | |
| Regularization and Validation | |
| Empty Neighborhoods | |
| Customer Orders | |
| 2nd Highest Salary | |
| Rolling Bank Transactions | |
| Bagging vs Boosting | |
| Paired Products | |
| Upsell Transactions | |
| Comments Histogram | |
| 500 Cards | |
| Closest SAT Scores | |
| Top Three Salaries | |
| Month Over Month | |
| Subscription Overlap | |
| Jars and Coins | |
| Monthly Customer Report | |
| Random SQL Sample | |
| Find the Missing Number | |
| Over 100 Dollars | |
| Longest Streak Users | |
| Minimum Change | |
| Google Maps Improvement | |
| Weekly Aggregation | |
| Compute Deviation | |
| Total Spent on Products | |
| Download Facts | |
| Average Quantity | |
| Target Indices |
Synthesized from candidate reports. Individual experiences may vary.
An initial behavioral conversation with the recruiter. This stage covered your background, motivation, and general fit for the Business Analyst role.
A short technical round focused mainly on SQL fundamentals and practical data work. Expect questions on larger datasets and core concepts like CTEs, joins, and unions.
A case study centered on a travel-related business problem. The work was completed using Excel and PowerPoint, suggesting an emphasis on analysis, synthesis, and presenting recommendations clearly.
A second technical conversation that was more conceptual and qualitative than the first SQL round. This stage likely tested business judgment, analytical thinking, and how you reason through ambiguous problems.
A granular assessment with very detailed syntax and conceptual questions. The experience suggests this was a tougher screening step that tested precision and depth of understanding.