Top 32
Prep plan
Updated weekly · Last refresh Oct 17

UBS Data Analyst Interview Questions

The questions to prepare for a UBS Data Analyst interview. Questions from real interview reports rank first. Updated daily.

32questions
~4htotal time
Track your progressSign up free to work through all 32 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 2 drills · ~70 min
Second-Highest Transaction Amount QueryMedium
Practice

Find the second-highest distinct transaction amount using a subquery in PostgreSQL without LIMIT.

SubqueriesRankingsalaryUBS
Handling Missing Data in SQLEasy

Explain how to identify, assess, and handle missing values in SQL using NULL checks, COALESCE, and validation logic.

Data WranglingCase WhenQualityUBS
Customer Orders: LEFT vs INNER JOINEasy

Explain how INNER JOIN and LEFT JOIN differ, and when to use each for matched-only versus all-left-row analysis.

JoinsData WranglingGroup ByUBS
SQL Window Functions ExperienceMedium
Practice
Practice drill

Use SQL window functions to rank regions by average 2024 yield within each country.

Window FunctionsJoinsData ManipulationErnst & YoungKBRMaximus Tech
Data Sources for ResearchMedium
Practice
Practice drill

Identify active research sources that meet review, reliability, and independent verification thresholds.

data accuracyfinancial dataresearchUBS
More SQL & Data Manipulation questions with a free account
2
Statistics & Probability5 questions · ~42 min
Black-Scholes Option PricingHard

Tests knowledge of option pricing theory and practical modeling assumptions.

financial datamodelingExpected ValueUBS
Stationarity for Time SeriesMedium

Tests time-series fundamentals and stationarity checks for valid modeling.

RegressionTime SeriesUBS
More Statistics & Probability 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
3
Behavioral & Leadership18 questions · ~151 min
More Behavioral & Leadership questions with a free account
4
More topics3 questions · ~25 min
Walk Through a Data ProjectMedium

Assesses end-to-end problem solving, tooling choices, and insight quality from a real data project.

Data AnalysisUBS
UBS Market Trends and AnalyticsMedium

Tests ability to connect market context with analytics use cases for UBS.

Value Propositioncompetitive landscapeUse CasesUBS
Power BI Dashboard EffortMedium

Assesses practical dashboard optimization and prioritization for decision-making at UBS.

dashboardingUBS
The finish line: interview-readyComplete all 32 questions plus 2 hands-on drills to finish this plan.