Novo Nordisk India Data Consultant Interview: Rounds, Questions and Preparation

What the job involves

As a Data Consultant in a GCC or Big 4 setup, you will help client teams turn raw data into clear business decisions, often for life sciences, healthcare, or consumer clients. Day to day you might clean and query datasets, build dashboards, document data definitions, and translate business questions into analytical requirements. You will work with consultants, client stakeholders, and offshore delivery teams, so clear communication and structured problem solving matter as much as SQL or Excel.

Role and domain knowledge

1. 1

   What does a data consultant actually do differently from a data analyst or a data engineer?

   A strong answer separates consultant work: understanding the business problem, framing the analysis, and communicating recommendations. Mention that you still need hands on skills like SQL but the output is a decision, not just a dashboard.

2. 2

   Why would a company like Novo Nordisk India need data consultants in a GCC or consulting setup?

   Talk about using data to improve patient outcomes, commercial effectiveness, supply chain visibility, or regulatory reporting. Show you understand that GCCs support global teams with analytics and consulting firms bring external benchmarking.

3. 3

   How would you explain a data insight to a non technical business stakeholder in a pharma commercial team?

   Focus on plain language, one clear takeaway, and a recommended action. Avoid jargon like p values or joins and instead say what changed, by how much, and what to do next.

4. 4

   What are common data quality issues you expect in healthcare or life sciences datasets?

   Mention missing patient or prescriber IDs, duplicate records, inconsistent units, delayed reporting, and privacy driven masking. Add that you would profile the data first and document assumptions.

Technical and analytical skills

1. 5

   Write a SQL query to find the top 5 products by total sales in the last quarter from a sales table.

   Use SUM, GROUP BY, ORDER BY DESC, and LIMIT or TOP. Explain how you would handle returns or negative values and why you filter on date first.

2. 6

   How would you check if a dataset has duplicate customer records and what would you do next?

   Describe using GROUP BY with HAVING COUNT greater than 1, or window functions like ROW_NUMBER. Then say you would confirm the business key with the client before deleting or merging.

3. 7

   You have monthly sales data with many missing values. How do you decide whether to drop, fill, or flag them?

   Start by quantifying missingness and checking if it is random or systematic. For a fresher, it is fine to say you would flag them for the client and avoid filling with averages unless the business agrees.

4. 8

   What chart would you use to show a trend over time and why not a pie chart?

   Choose a line chart for trends and explain that pie charts are poor for time series and hard to compare. Mention axis labels, clear titles, and avoiding misleading scales.

Practical scenarios

1. 9

   A client says their sales report is wrong but cannot explain why. How do you investigate?

   Show a structured approach: confirm the expected number, trace the data lineage, check filters and date ranges, and compare with source systems. Then document the root cause and propose a validation rule.

2. 10

   You are asked to build a dashboard for a field force team but you have only two days. What do you do?

   Prioritize the single most important metric, use a simple tool like Power BI or Excel, and agree on scope with the stakeholder. Mention that you would ship a basic version and iterate rather than miss the deadline.

3. 11

   Your analysis shows a decline in patient adherence but the client disagrees. How do you handle it?

   Stay neutral, show your assumptions and data sources, and invite the client to review the logic. Offer to run a sensitivity check or segment the data to find where the disagreement comes from.

4. 12

   You need data from a client team that is slow to respond. How do you keep the project moving?

   Suggest a clear data request template, set a deadline, and offer to start with partial data. Escalate politely only after you have tried to unblock yourself and documented the impact.

Behavioral and HR questions

1. 13

   Tell me about a time you had to learn a new tool or skill quickly for a project.

   Use a specific example from college, an internship, or a competition. Highlight the steps you took, how you measured success, and what you would do differently.

2. 14

   Describe a situation where you had to work with someone who disagreed with your analysis.

   Show that you listened first, asked for their evidence, and adjusted your view if needed. End with a respectful resolution and a better outcome for the team.

3. 15

   Why do you want to work as a data consultant in a GCC or Big 4 environment rather than a pure tech company?

   Connect your interest to client exposure, structured problem solving, and domain learning in sectors like healthcare. Mention that you enjoy both analysis and communication.

4. 16

   Where do you see yourself in three years and how does this role fit?

   Show a realistic path: deeper domain expertise, leading small workstreams, and possibly managing client relationships. Avoid saying you want to move out of consulting immediately.