Dataford
Top 50
Prep plan
Updated weekly · Last refresh Aug 30

Fannie Mae Business Analyst Interview Questions

The questions to prepare for a Fannie Mae Business Analyst interview. Questions from real interview reports rank first. Updated weekly.

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
ExecutionStart here. 4 questions · ~32 min
Scalable Secure SystemsHard

Tests your ability to think about scalability and security tradeoffs in system delivery.

system designcloud infrastructureSecurityFannie Mae
Requirements Gathering ProcessMedium

Tests your requirements discipline, documentation quality, and stakeholder alignment.

documentationProject ManagementFannie Mae
More Execution questions with a free account
2
SQL & Data Manipulation3 questions + 3 drills · ~54 min
SQL for Business InsightsMedium

Tests your ability to use SQL to derive insights that inform business decisions.

Data AnalysissqlFannie Mae
Top Earners via Table JoinMedium
Practice
Practice drill

Rank Motorola Solutions employees by total earnings using a LEFT JOIN, aggregation, COALESCE, and ROW_NUMBER.

JoinssqlMotorola SolutionsMotorola
Weekly Service KPI by TeamMedium
Practice
Practice drill

Analyze weekly service delivery performance by team using joins, a CTE, date aggregation, and KPI calculations.

KPIJoinssqlDeloitteReputation
Retention Cohorts With Complex JoinsHard
Practice
Practice drill

Build twelve-month Twitch viewer retention cohorts with CTEs, joins, date offsets, and conditional aggregation.

JoinssqlCohort AnalysisTwitch
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
Statistics & Probability3 questions · ~24 min
Probability and Math QuestionsMedium

Tests quantitative reasoning relevant to data analysis and business problem solving.

MathprobabilityFannie Mae
More Statistics & Probability questions with a free account
4
Behavioral & Leadership36 questions · ~288 min
More Behavioral & Leadership questions with a free account
5
More topics4 questions · ~32 min
Fannie Mae’s Role in HousingMedium

Tests understanding of Fannie Mae’s impact on housing finance and the lending ecosystem.

Fannie Mae
General Experience OverviewEasy

Tests your overall fit and how you frame relevant security engineering work.

User NeedsUse CasesFannie Mae
Resume WalkthroughEasy

Tests your ability to tell a coherent story about your background and relevance to Baird research.

EstimationUser ResearchFannie Mae
Duration and Yield CurveMedium

Evaluates foundational finance knowledge relevant to mortgage and interest-rate concepts.

Fannie Mae
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.