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 weekly.
Approach for maintaining data quality and integrity across ETL pipelines.
State StreetApproach for cleaning and preparing raw data inside an ETL pipeline.
State StreetExplain how SQL fits with Python, spreadsheets, and BI tools in a practical data analysis workflow.
State StreetExplain how SQL fits with data analysis and visualization tools, and when to use each in an analytics workflow.
State StreetFilter Wolfspeed Epi production lots by release status and return them in lot-number order.
WolfspeedState StreetFind the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.
eClinicalWorks
Informatica
Spectraforce TechnologiesAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Describe how your analysis of marketing KPIs led to a meaningful decision and how you tied short-term and long-term metrics together.
State StreetDescribe how you handled a difficult stakeholder while keeping a product initiative moving forward.
State StreetTests your ability to build models and interpret regression results for decision-making.
State StreetTests your ability to turn financial data into decisions and recommendations.
State Street