Dataford
Dataford
Top 50
Topic roadmap
Updated weekly · Last refresh Nov 1

Top 50 financial data Interview Questions

The most frequently asked financial data questions across all roles and companies, ranked by real interview frequency. Updated daily.

50questions
~17htotal time
58companies covered
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 48 questions · ~970 min
Rolling Averages with SQL Window FunctionsMedium
Practice
Recently asked

Calculate three-record rolling account balance averages using PostgreSQL window functions.

Window Functionsfinancial datacalculationsAAppstrailBBrukerLLegal & General
Rolling Average with SQL Window FunctionsMedium
Practice

Calculate each commodity's 30-day rolling average price using a PostgreSQL window function.

Date Functionsfinancial dataData AnalysisCCommerzbankiidealo internet44flow
SQL Month-over-Month Revenue ComparisonMedium
Practice
Recently asked

Compare each product's current and previous month revenue, including absolute and percentage changes.

Window FunctionsLag/LeadDate FunctionsGoogleAmazonKeyrus France
SQL Window Functions for Portfolio AnalysisHard
Practice
Recently asked

Rank portfolios by monthly net transaction value using PostgreSQL window functions.

Window FunctionsPivotfinancial dataMacquarie GroupThe Blackstone Group
SQL Window FunctionsMedium
Practice
Recently asked

Rank accounts by aggregated positive risk exposure within each region using a window function.

Window FunctionsJoinsfinancial dataJPMorganChase
Multi-Tenant Ledger SchemaHard
Practice
Recently asked

Design a tenant-isolated Mercury ledger schema and report posted account balances with transaction counts.

ledgerfinancial datamany-to-oneMercury
SQL with Window FunctionsMedium
Practice

Rank users by monthly traded value within account type using Robinhood-style trade data.

Window FunctionsData Manipulationfinancial dataRobinhood
Second-Highest Per DepartmentMedium
Practice
Recently asked

Use a window function to return each department's transactions tied at the second-highest amount.

Window FunctionsJoinsfinancial dataTredenceOptum Technology
More SQL & Data Manipulation 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
2
More topics2 questions · ~40 min
More questions with a free account
The finish line: interview-readyComplete all 50 questions to finish this plan.