I applied through a recruiter. The process took 2 months. I interviewed at Agoda in Feb 2024
Interview
4 Rounds,
1. Online test which assesses various skillsets including SQL, Excel, chart interpretation, etc.
2. Mini-case to test analytical thinking using excel. Quite straightforward
3. 1 week take-home case study, given a huge of dataset and ask open-ended questions to test data visualization and analytical thinking skill
4. Specific business case with the hiring manager, it seems to be problems you will really face when you work in this role. Asked about how you're gonna approach the problem or the kind of data you would use.
Interview questions [1]
Question 1
Second, small data of spreadsheet and ask which treatment yields better result
Third round, given the huge dataset of booking, how does it correlate to booking lead time and other findings
Fourth, How to increase an open rate of the email
Detailed with assessment test that do not reflect the duties or skills of the role applied for. Quick response time on the first point of contact. Would be insightful to recieve Shl results and summary automatically as part of the service
1 HR interview + 3 interviews (1 take-home data analysis case study presentation) they really gril you to see if you know your stuff well so be prepared for follow up questions
Very long and consist of many rounds. 1. Case interview 2. Data case pitching 3. Final case interview. All conducted in english. Need business knowledge. Some case is similar to consulting.
Interview questions [1]
Question 1
How to use urgency message to improve Agoda revenue
