Agoda Marketing Analyst Interview Guide

The process started with CV screening, followed by an online assessment and a recruiter call. The assessment was the most challenging part for me because it was time-limited and heavily focused on SQL and analytical thinking. I had to write queries based on a business case, including filtering data for a specific country.

During the recruiter call, we discussed my previous experience, my role in reporting and cross-functional projects, decision-making processes, and whether I would be open to relocating to Bangkok. I felt confident when talking about my analytics background and practical experience, but I started sweating during the SQL assessment because of the time pressure and the need to quickly understand the business context behind each question.

At this stage, I have completed the first rounds and am waiting for the next steps, which may include a senior manager interview, a case study, a discussion of the case, and a final hiring manager interview. What surprised me most was that the process focused not only on technical SQL skills, but also on how clearly you can explain your own contribution and connect your analysis to marketing decisions.

Questions asked: The technical questions focused mainly on SQL and practical marketing analytics. I was asked to work with a dataset that included users, bookings, countries, dates, and marketing channels. The questions involved filtering data for a specific country, calculating conversion-related metrics, aggregating results by channel, and comparing performance across different time periods.

I also had to explain my approach rather than simply provide the final query. They were interested in how I would check data quality, handle missing values or duplicate records, and decide which metrics were relevant for evaluating a marketing campaign.

In the case discussion, I was asked to think through a marketing performance problem: how I would identify why one channel was underperforming, what additional data I would request, and what recommendations I would give to the business. There was no single obvious answer, so the main challenge was structuring the problem and clearly explaining my assumptions.

I don’t remember any particularly strange take-home instructions. The most important detail was the time pressure during the assessment. Even relatively straightforward SQL questions became more difficult because I had to understand the business context, choose the right level of aggregation, and make sure the result was logically correct.