Barclays Risk Analyst Interview Questions
The questions to prepare for a Barclays Risk 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.
BarclaysExplain how PostgreSQL aggregate functions treat NULL values and when to use COALESCE in risk reporting queries.
BarclaysExplain how LEFT JOIN vs INNER JOIN changes report completeness, NULL handling, and KPI interpretation in Meta-style reporting.
BarclaysAggregate active portfolio exposure by counterparty using LEFT JOINs, conditional filters, and GROUP BY.
BarclaysCalculate calendar-day rolling exposure averages for active UK counterparties using CTEs, aggregation, and window functions.
BarclaysCompute the probability that two balls drawn without replacement are different colors.
BarclaysTests reasoning about statistical relationships and avoiding causal fallacies.
BarclaysTests experimental design and metric selection for credit product risk and performance.
BarclaysSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests credit risk assessment approach and judgment under macroeconomic stress.
BarclaysAssesses understanding of market drivers relevant to credit risk.
Barclays