Top 18
Prep plan
Updated weekly · Last refresh Oct 17

Cenlar FSB Data Analyst Interview Questions

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

18questions
~3htotal time
Track your progressSign up free to work through all 18 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 3 questions · ~26 min
Version Control BI Deployment PipelinesMedium

How to version control BI assets and deploy them safely through automated pipelines.

InfrastructureToolsOrchestrationCenlar FSB
Loan Modification Request Lifecycle ModelHard

Tests data modeling skills for end-to-end workflow tracking across multiple lifecycle stages.

lifecycleAutomationData ModelingCenlar FSB
Power BI/Tableau Direct Query PerformanceMedium

Tests practical BI performance optimization techniques for large datasets with direct query.

InfrastructureToolsperformanceCenlar FSB
2
SQL & Data Manipulation4 questions + 2 drills · ~55 min
Star vs Snowflake for Sales AnalyticsMedium

Compare star and snowflake schemas for warehouse design, including trade-offs in normalization, query simplicity, and analytics performance.

JoinsData WranglingGroup ByCenlar FSB
Delinquent Loans QueryMedium
Practice

Identify loans over 90 days delinquent with payment history and outstanding principal balances.

Joinsfinancial datacomplex queriesCenlar FSB
Window Functions for Rate ChangesMedium

Tests proficiency with window functions to compute time-based changes in loan metrics.

Window FunctionsLag/LeadRankingCenlar FSB
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
Analyze Restaurant Performance With SQLMedium
Practice
Practice drill

Aggregate daily Kfc France costs and sales, rank locations by operating contribution, and compare performance with the previous day.

Lag/LeadJoinsfinancial dataKfc France
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
3
Metrics3 questions · ~26 min
Escrow KPI MonitoringMedium

Tests ability to define KPIs that balance operational efficiency and regulatory compliance for escrow operations.

KPIefficiencyComplianceCenlar FSB
Root Cause for Delinquency SpikeMedium

Tests diagnostic analytics approach to isolate drivers of delinquency spikes by region.

root causeDiagnosisCenlar FSB
More Metrics questions with a free account
4
Behavioral & Leadership8 questions · ~69 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 18 questions plus 2 hands-on drills to finish this plan.