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 daily.
Use a CTE, join, and dense ranking to return each client's second-highest distinct transaction amount.
T. Rowe PriceExplain how to handle NULLs in SQL-backed visualizations without misrepresenting counts, averages, or trends.
T. Rowe PriceExplain INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF JOINs using finance reporting examples and null-handling implications.
T. Rowe PriceTests your SQL performance tuning skills and ability to work with large-scale market datasets.
T. Rowe PriceCalculate each Hinge user's 30-day rolling average of daily interactions using CTEs and window functions.
HingeCCatalyst Operations & AnalyticsAAlight SolutionsCalculate channel-level conversion rates from a single events table using GROUP BY and conditional aggregation.
Caesars entertainment
Berkshire Hathaway
LeagueTests ownership and stakeholder management in leading a data project from vague problem definition through delivery and measurable impact.
T. Rowe PriceTests your investment performance metric selection and analytical reasoning for T. Rowe Price use cases.
T. Rowe PriceTests your approach to defining and monitoring data quality metrics for onboarding processes.
T. Rowe PriceTests your ability to translate business KPIs into a clear dashboard design and data model.
T. Rowe PriceSign up to see every question
Create a free account to unlock this list and practice real interview questions.