T. Rowe Price Data Analyst Interview Questions
The questions to prepare for a T. Rowe Price Data Analyst interview. Questions from real interview reports rank first. Updated weekly.
Use a CTE, join, and dense ranking to return each client's second-highest distinct transaction amount.
T. Rowe PriceExplain INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF JOINs using finance reporting examples and null-handling implications.
T. Rowe PriceExplain how to handle NULLs in SQL-backed visualizations without misrepresenting counts, averages, or trends.
T. Rowe PriceTests your SQL performance tuning skills and ability to work with large-scale market datasets.
T. Rowe PriceCalculate channel-level conversion rates from a single events table using GROUP BY and conditional aggregation.
Caesars entertainment
Berkshire Hathaway
LeagueCalculate the monthly spending trends for customers using window functions and joins.
The Home Depot
Aviso
World Wide TechnologyTests communication and influence: can you translate technical complexity into business decisions, align stakeholders, and drive action?
T. Rowe PriceTests your ability to translate business KPIs into a clear dashboard design and data model.
T. Rowe PriceTests your approach to defining and monitoring data quality metrics for onboarding processes.
T. Rowe PriceTests your investment performance metric selection and analytical reasoning for T. Rowe Price use cases.
T. Rowe PriceSign up to see every question
Create a free account to unlock this list and practice real interview questions.