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

Fannie Mae Data Analyst Interview Questions

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

35questions
~5htotal time
Track your progressSign up free to work through all 35 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 8 questions + 3 drills · ~94 min
Validate Data Integrity Before AnalysisMedium
Recently asked

Tests data quality checks and reliability practices before analysis.

Data Qualitydata integrityFannie Mae
Handle Missing or Inconsistent DataMedium
Recently asked

Tests data cleaning strategies and judgment for financial datasets.

Data Qualitydata cleaningdata integrityFannie Mae
Top Users by Recent Transaction VolumeMedium
Practice
Practice drill

Find the top 3 users by completed transaction volume in the last 30 days using joins and aggregation.

Data Analysisquery optimizationsqlTTier 1 BankRevolutChime
SQL Duplicate Record DetectionEasy
Practice
Practice drill

Find duplicate American Institutes for Research assessment submissions using a CTE, GROUP BY, HAVING, and joins.

deduplicationsqldata integrityAmerican Institutes for ResearchMacy's
Top Users by Region QueryMedium
Practice
Practice drill

Rank the top 10 ResMed myAir users in each region using joins, aggregation, and ROW_NUMBER().

Data AnalysissqlResmed
More SQL & Data Manipulation questions with a free account
2
Metrics4 questions · ~32 min
Trend Analysis for Mortgage DelinquencyMedium
Recently asked

Tests project structuring, metric definition, and trend analysis for housing finance.

Fannie Mae
Break-Even Point for Product InitiativeMedium
Recently asked

Tests cost-revenue reasoning and ability to operationalize break-even decisions.

product metricsFinancial AnalysisFannie Mae
More Metrics 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
Pipelines3 questions · ~24 min
Approach an Ambiguous Data ProjectMedium
Recently asked

Tests problem framing, data exploration, and planning under uncertainty.

Data AnalysisProblem SolvingFannie Mae
Start Improving Data Reporting EfficiencyMedium
Recently asked

Tests structured problem solving and prioritization for reporting improvements.

process improvementFannie Mae
More Pipelines questions with a free account
4
Behavioral & Leadership18 questions · ~144 min
More Behavioral & Leadership questions with a free account
5
More topics2 questions · ~16 min
Maximize Profit Margins From Sales GraphMedium
Recently asked

Tests business-oriented analytics and ability to translate trends into actions.

Fannie Mae
Improving Ride EfficiencyMedium

Assesses your product sense and ability to use data to drive operational efficiency improvements.

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