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 weekly.
Explain how to detect and handle NULL values in SQL using filtering, COALESCE, CASE, and business-aware imputation.
State Street Global AdvisorsTests data quality handling and correct treatment of missingness.
State Street Global AdvisorsTests your performance troubleshooting skills across query design and database behavior.
State Street Global AdvisorsUse ROW_NUMBER() to keep the earliest created_at 'Repl created' per entity and return out-of-order duplicates to delete.
ReplitMerge CRM orders with GA events via an identity map to build a customer-level view using joins, window functions, and monthly rollups.
ArtefactRank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.
WaymoExplain what a p-value means in hypothesis testing and how it relates to statistical significance.
State Street Global AdvisorsTests your approach to feature importance and causal or correlational reasoning in financial data.
State Street Global AdvisorsTests breadth of statistical thinking for analyzing data and drawing conclusions.
State Street Global AdvisorsSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests your metrics thinking and ability to evaluate investment performance using data analysis.
State Street Global AdvisorsTests your ability to choose effective visualization tools for clear stakeholder communication.
State Street Global Advisors