Dataford
Dataford
Top 35
Prep plan
Updated weekly · Last refresh Oct 17

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 daily.

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
Outer Join SQLMedium

Tests your ability to write correct SQL joins and handle unmatched records.

sqlFannie Mae
Handle Missing or Inconsistent DataMedium

Tests data cleaning strategies and judgment for financial datasets.

Data Qualitydata cleaningdata integrityFannie Mae
Second and Nth Highest ValuesMedium
Practice
Practice drill

Find the second highest distinct salary and adapt the query to retrieve any requested salary rank.

Data Manipulationsqldatabase queryingSnowflake ComputingKKGISLSBS
Using SQL and PythonMedium
Practice
Practice drill

Use SQL aggregation and Python validation to explain how a workplace data problem was solved and measured.

JoinsProblem SolvingsqlLalamove
Consecutive Login Days SQLHard
Practice
Practice drill

Find each user's longest consecutive login streak by deduplicating login dates and identifying gaps between days.

Date FunctionsData ManipulationProblem SolvingDidi ChuxingByteDance
More SQL & Data Manipulation questions with a free account
2
Metrics4 questions · ~32 min
Trend Analysis for Mortgage DelinquencyMedium

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

Fannie Mae
Profitability Metrics from Sales DataMedium

Tests metric selection tied to business outcomes and profitability.

Fannie Mae
More Metrics questions with a free account
3
Pipelines3 questions · ~24 min
Approach an Ambiguous Data ProjectMedium

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

Data AnalysisProblem SolvingFannie Mae
Start Improving Data Reporting EfficiencyMedium

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
Improving Ride EfficiencyMedium

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

efficiencycomparisonFannie Mae
Maximize Profit Margins From Sales GraphMedium

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

Fannie Mae

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 35 questions plus 3 hands-on drills to finish this plan.