Top 40
Prep plan
Updated weekly · Last refresh Oct 17

State Street Data Analyst Interview Questions

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

40questions
~6htotal time
Track your progressSign up free to work through all 40 questions and resume where you left off.
Start practicing free →
1
Product SenseStart here. 5 questions · ~43 min
2
Metrics5 questions · ~43 min
Derive Insights From Financial MetricsEasy

Explain how to turn financial results into clear insights by linking KPIs, leading indicators, and business outcomes.

KPIsLeading IndicatorsDiagnosisState Street
Analysis That Drove Measurable ImpactEasy

Describe a case where your analysis used the right metrics, shaped a decision, and produced a meaningful business result.

KPIsLeading IndicatorsDiagnosisState Street
More Metrics 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
Pipelines4 questions · ~34 min
Clean Data for Visual AnalyticsEasy

Describe how you clean and preprocess data so dashboards stay accurate and usable.

Data WranglingETLQualityState Street
More Pipelines questions with a free account
4
SQL & Data Manipulation12 questions + 1 drill · ~113 min
SQL in Data Analysis WorkflowsEasy

Explain how SQL fits with Python, spreadsheets, and BI tools in a practical data analysis workflow.

ToolsData WranglingAggregationsState Street
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
SQL Inner JoinEasy
Practice
Recently asked
Practice drill

Filter Wolfspeed Epi production lots by release status and return them in lot-number order.

JoinssqlWolfspeedState Street
More SQL & Data Manipulation questions with a free account
5
Statistics & Probability6 questions · ~52 min
Interest Rate and Credit Risk ModelingHard

Assesses your approach to building and validating risk models for financial decision-making.

model validationrisk modelingState Street
More Statistics & Probability questions with a free account
6
Behavioral & Leadership7 questions · ~60 min
More Behavioral & Leadership questions with a free account
7
More topics1 question · ~9 min
Actionable Insights From Financial DataEasy

Tests your ability to turn financial data into decisions and recommendations.

EstimationCompetitive AnalysisTime SeriesState Street
The finish line: interview-readyComplete all 40 questions plus 1 hands-on drill to finish this plan.