Morgan Stanley India Data Consultant Interview: Rounds, Questions and Preparation

What the job involves

Data Consultants in GCCs, consulting firms, and the Big 4 help clients and internal teams turn raw data into decisions, dashboards, and process improvements. Day to day, they gather requirements, write SQL and Python to clean and analyse data, build reports in tools like Power BI or Tableau, and present findings to stakeholders. At a firm like Morgan Stanley India, this often means supporting financial services clients or internal risk, compliance, and operations teams with data-driven insights.

Role and Technical Knowledge

1. 1

   What is the difference between a fact table and a dimension table in a data warehouse, and why does it matter for reporting?

   Explain that fact tables store measurable events like transactions, while dimension tables store descriptive context like customer or product. Strong answers link this to faster, clearer dashboards and consistent KPIs.

2. 2

   Write a SQL query to find the second highest salary from an Employee table.

   Use a subquery with MAX and a WHERE clause, or a window function like DENSE_RANK. Mention how you would handle ties and nulls, and note that window functions are often preferred in modern SQL.

3. 3

   How would you explain a p-value to a business stakeholder who has never studied statistics?

   Avoid jargon. Say it is the probability of seeing a result this extreme if there were truly no effect, and that a small p-value suggests the result is unlikely to be due to chance alone. Emphasise that it does not prove causation.

4. 4

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

   Cover checking for missing values, duplicates, inconsistent formats, outliers, and incorrect data types. Mention documenting your cleaning decisions so the analysis is reproducible and auditable.

Practical Scenarios

1. 5

   A client says their monthly sales dashboard shows numbers that do not match their finance team's reports. How do you investigate?

   Start by clarifying definitions of key metrics like revenue and date ranges. Check data sources, refresh schedules, filters, and join logic. Suggest a reconciliation exercise and a single source of truth going forward.

2. 6

   You are given a large transaction dataset and asked to identify unusual spending patterns. What is your approach?

   Outline a structured plan: understand the business context, define what unusual means, use summary statistics and visualisations, then apply simple rules or clustering. Mention that you would validate findings with the business before raising alerts.

3. 7

   Your manager asks for a report by tomorrow, but the data you need is incomplete. What do you do?

   Show that you prioritise transparent communication. Suggest delivering a preliminary analysis with clear caveats, listing what is missing and its impact, and proposing a timeline for the full version. Avoid silently guessing or missing the deadline.

4. 8

   How would you design a dashboard for a wealth management team to track client portfolio performance?

   Ask about the audience and key decisions first. Then propose metrics like returns, asset allocation, and risk exposure, with filters for client segments and time periods. Mention keeping it simple, with drill-downs rather than clutter.

Behavioural and HR

1. 9

   Why do you want to work as a Data Consultant in a GCC or consulting environment rather than a pure product company?

   Show awareness of the variety of client problems, exposure to senior stakeholders, and structured learning. Link it to your interest in both analytics and business strategy, and mention comfort with fast-paced, project-based work.

2. 10

   Tell me about a time you had to explain a technical idea to someone non-technical.

   Use a clear STAR structure. Focus on how you simplified the concept, checked understanding, and adapted your language. End with the outcome and what you learned about communication.

3. 11

   Describe a situation where you received critical feedback on your work. How did you respond?

   Pick a genuine example, not a humble-brag. Show that you listened, asked clarifying questions, made specific changes, and followed up. Demonstrate that you see feedback as a tool for faster learning in a consulting setting.

4. 12

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

   Align your growth with the firm's path, such as deepening analytics skills, leading small workstreams, or gaining domain expertise in financial services. Avoid saying you want to leave for an MBA immediately, and show commitment to learning.

Sector and Company Awareness

1. 13

   What are some common data challenges in financial services that a consultant might help solve?

   Mention data silos across systems, regulatory reporting accuracy, risk modelling, and customer 360 views. Show awareness that GCCs often support global teams with data quality, compliance, and automation.

2. 14

   How would you handle sensitive client data in a consulting project?

   Emphasise confidentiality, access controls, anonymisation where possible, and compliance with firm policies and regulations. Mention that you would never move data to unauthorised tools or share it outside approved channels.

3. 15

   What do you think a Data Consultant at a firm like Morgan Stanley India does differently from a data analyst at a startup?

   Highlight the scale, regulatory environment, and stakeholder complexity. Note that consultants often work on multiple projects, need strong documentation, and must balance speed with accuracy and auditability.

4. 16

   Why should we hire you over other freshers with similar technical skills?

   Combine a unique strength, such as a project where you delivered business impact, with soft skills like structured thinking and clear communication. Keep it confident but grounded in evidence from your internships, projects, or competitions.