Wood Mackenzie India Research Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Research Analyst in the BPO/KPO/ITES sector supports clients by gathering, cleaning, and analysing data on markets, industries, or competitors, then producing clear reports and presentations. Day to day work includes secondary research, Excel modelling, database queries, and writing summaries that help senior analysts or clients make decisions. In fast-growing firms, you may also handle client queries and contribute to process improvements.

Role and Sector Knowledge

1. 1

   What do you understand by the BPO/KPO/ITES sector, and how does a Research Analyst fit into it?

   Explain that KPO involves knowledge-intensive services like research and analytics, and that analysts provide data-driven insights to clients. Avoid confusing BPO with KPO; highlight the analytical nature of the role.

2. 2

   What are the key differences between primary and secondary research? Which would you use for a market study?

   Define primary as first-hand data collection (surveys, interviews) and secondary as existing data (reports, databases). For a market study, secondary research is often the starting point due to cost and speed, but primary may validate findings.

3. 3

   How would you ensure data accuracy when working with large datasets?

   Mention cross-checking with multiple sources, using Excel functions like VLOOKUP or COUNTIF to spot anomalies, and maintaining a validation log. Emphasise attention to detail and double-checking before submission.

4. 4

   What are some common sources you would use for industry research?

   List credible sources like company annual reports, government databases, industry associations, and paid databases (e.g., Bloomberg, Capital IQ). Mention that you would evaluate source credibility and date of publication.

Technical and Analytical Skills

1. 5

   Explain how you would use VLOOKUP or INDEX-MATCH in Excel for data analysis.

   Describe a scenario where you need to merge data from two sheets. Explain that VLOOKUP searches a value in the first column, while INDEX-MATCH is more flexible. Mention common errors like #N/A and how to troubleshoot.

2. 6

   What steps would you take to clean a messy dataset before analysis?

   Cover removing duplicates, handling missing values, standardising formats, and checking for outliers. Mention using Excel tools like Remove Duplicates, Text to Columns, and filters.

3. 7

   How would you interpret a trend line in a sales chart that is declining? What factors would you investigate?

   Suggest looking at seasonality, market conditions, competitor actions, and internal factors like pricing or product quality. Emphasise that correlation does not imply causation and you would seek more data.

4. 8

   If you had to summarise a 50-page industry report into a 2-page executive summary, how would you approach it?

   Focus on key findings, methodology, and recommendations. Mention skimming for headings, extracting data points, and writing concisely for a busy client. Avoid jargon and use bullet points.

Practical Scenarios

1. 9

   You are assigned to research a new market for a client, but you have only two days. How do you prioritise?

   Break the task into phases: define scope, gather readily available secondary data, identify gaps, and focus on high-impact insights. Communicate early if timeline is tight and propose a phased deliverable.

2. 10

   A client asks for a data point that you cannot find from reliable sources. What do you do?

   Suggest offering a proxy or estimate with clear assumptions, or explaining the limitation. Never fabricate data. Propose alternative sources or a primary research approach if feasible.

3. 11

   You notice a mistake in a report that has already been sent to the client. How do you handle it?

   Immediately inform your supervisor, assess the impact, and prepare a corrected version with an apology. Emphasise transparency and learning from the error to prevent recurrence.

4. 12

   You are working on multiple projects with tight deadlines. How do you manage your time?

   Use prioritisation tools like Eisenhower matrix or to-do lists. Communicate with stakeholders about timelines and delegate if possible. Mention staying calm and focusing on one task at a time.

Behavioural and HR Questions

1. 13

   Tell me about a time you had to learn something quickly for a project or assignment.

   Use STAR format: describe the situation, the task, the actions you took (e.g., online tutorials, asking mentors), and the result. Highlight adaptability and self-learning.

2. 14

   Why do you want to work in the KPO/Research sector, and why this company?

   Show genuine interest in research and analytics. Mention the company's reputation, client base, or learning opportunities. Avoid generic answers; research the company beforehand.

3. 15

   Describe a situation where you worked in a team to achieve a goal. What was your role?

   Focus on collaboration, communication, and your specific contribution. Highlight how you handled disagreements or supported teammates. End with the outcome.

4. 16

   Are you comfortable working in shifts or with tight deadlines? How do you handle stress?

   Be honest but positive. Mention strategies like planning, breaks, and prioritisation. Show willingness to adapt to business needs while maintaining work quality.