Dataford
Top 50
Prep plan
Updated weekly · Last refresh Aug 30

MSCI Data Analyst Interview Questions

The questions to prepare for a MSCI Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
Statistics & ProbabilityStart here. 16 questions · ~128 min
Financial Assets and MarketsMedium

Tests your breadth of market and asset concepts relevant to MSCI's data and analytics work.

CorrelationVarianceExpected ValueMSCI
Pricing Simple Options for a VPHard

Tests your approach to tackling urgent, domain-specific modeling work with VP-level expectations.

VarianceExpected ValueConditional ProbabilityMSCI
Types of Bonds and BehaviorMedium

Tests your understanding of different bond types and how their characteristics affect returns.

CorrelationVarianceExpected ValueMSCI
More Statistics & Probability questions with a free account
2
Behavioral & Leadership29 questions · ~232 min
More Behavioral & Leadership questions with a free account
3
More topics5 questions · ~40 min
Prioritize User Problems with DataMedium

Framework for using product data to identify and prioritize the user problem that should be solved first.

Feature PrioritizationUser NeedsPain PointsMSCI
Your SQL ExperienceEasy

Tests your hands-on SQL skills for data extraction and analysis tasks.

JoinsGroup ByAggregationsMSCI
Portfolio Management KnowledgeMedium

Tests your understanding of portfolio management concepts and how they relate to analytics.

KPIsLeading IndicatorsDiagnosisMSCI
Implementing a Data PipelineHard

Tests your ability to design and implement reliable data pipelines for analytics and indexing.

ETLOrchestrationData ModelingMSCI
SQL Top 10 Clients by RevenueMedium

Tests your ability to write correct SQL for ranking and aggregations.

RankingGroup ByAggregationsMSCI

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
Analyze Customer Purchase Trends with Window FunctionsEasy
Practice
Practice drill

Calculate the monthly spending trends for customers using window functions and joins.

The Home DepotAvisoWorld Wide Technology
7-Day Rolling Average With SQLMedium
Practice
Practice drill

Calculate each customer's 7-day rolling transaction average using PostgreSQL window frames and a customer lookup join.

Window FunctionsDate FunctionsRunning TotalsMSCI
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.