Top 10
Prep plan
Updated weekly · Last refresh Oct 17

State Street Global Advisors Data Analyst Interview Questions

The questions to prepare for a State Street Global Advisors Data Analyst interview. Questions from real interview reports rank first. Updated daily.

10questions
~2htotal time
Track your progressSign up free to work through all 10 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 4 questions + 1 drill · ~53 min
Optimizing a Slow QueryMedium
Practice

Rewrite a slow PostgreSQL reporting query to reduce scanned rows, avoid join multiplication, and return accurate monthly site metrics.

Subqueriesdatabase optimizationJoinsState Street Global Advisors
Handling Missing DataMedium
Practice

Standardize missing observation fields with fallback values, missingness flags, and ordered output.

Window Functionsmissing valuesdata cleaningState Street Global Advisors
Extract Data with SQLEasy

Tests your ability to write correct SQL for data retrieval and basic transformations.

JoinsData WranglingAggregationsState Street Global Advisors
Optimize a Slow SQL QueryHard
Practice
Practice drill

Rewrite a slow PostgreSQL loan payment query to reduce scanned rows while preserving the required aggregated results.

database optimizationJoinsData WranglingAmeripriseEEltro Cyberchrome PrivateEnergyHub
More SQL & Data Manipulation questions with a free account
2
Statistics & Probability4 questions · ~43 min
Interpreting P Values in TestingEasy

Explain what a p-value means in hypothesis testing and how it relates to statistical significance.

Hypothesis TestingStatistical SignificanceP-ValuesState Street Global Advisors
Bond Valuation MethodHard

Evaluates your ability to apply quantitative methods to bond valuation problems.

Financial AnalysisState Street Global Advisors
Identify Most Influential FactorsHard

Tests your approach to feature importance and causal or correlational reasoning in financial data.

RegressionCorrelationCausal InferenceState Street Global Advisors
More Statistics & Probability questions with a free account

Sign up to see every question

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

Get my prep plan
3
More topics2 questions · ~22 min
Measure New Investment Product PerformanceMedium

Tests your metrics thinking and ability to evaluate investment performance using data analysis.

KPIsLeading IndicatorsDiagnosisState Street Global Advisors
Data Visualization ToolsEasy

Explain which data visualization tools you prefer, why you choose them, and how you match tools to analytical use cases.

User Researchtechnical usersValue PropositionState Street Global Advisors
The finish line: interview-readyComplete all 10 questions plus 1 hands-on drill to finish this plan.