Real, anonymous reports from people who interviewed for Business Analyst at Kantar, newest first and distilled into what to expect across the loop.
My process started with a fairly puzzle-style round. I was given a question involving finding the missing number from a range (it included duplicates/uniques in the description) and I had to reason through how I’d identify the missing value from 1 to 5000. The next questions were more number-heavy and practical: estimating bike counts for Bangalore’s population and then a “chair brand ambassador” style guesstimate, where I had to determine how many chairs would be needed after a set number of months.
The interview journey felt very centered on data work. After the initial steps, I went into questions that tested practical familiarity with Excel and Python, framed around data science-style thinking. SQL and core OOP concepts came up as well, so I couldn’t just speak generally—I had to show I understood how these pieces connect.
The interview process typically begins with an online assessment that includes aptitude tests, data interpretation, and logical reasoning. Candidates should prepare for a variety of question types that test both analytical skills and communication under time pressure.
Candidates can expect multiple technical rounds focusing on SQL, Python, and data analysis. Questions often require practical application of concepts, including data cleaning and presenting insights, so familiarity with these tools is essential.
Interviews often include behavioral questions aimed at assessing cultural fit and alignment with company values. Candidates should be prepared to discuss their strengths, weaknesses, and decision-making processes in various scenarios.
A significant part of the process may involve a case study where candidates present their findings based on real-world data. This showcases analytical skills and the ability to communicate insights effectively, so practicing presentation skills is beneficial.
The overall tone of interviews is generally friendly and interactive, allowing candidates to connect their experiences to the role. However, candidates should be aware that communication can sometimes falter, leading to uncertainty about next steps.
The interview process can extend over several weeks, with varying levels of communication regarding scheduling and feedback. Candidates should be prepared for potential delays and ensure they follow up if communication lapses occur.