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

The Federal National Mortgage Association - Fannie Mae Marketing Analytics Specialist Interview Questions

The questions to prepare for a The Federal National Mortgage Association - Fannie Mae Marketing Analytics Specialist interview. Questions from real interview reports rank first. Updated weekly.

13questions
~2htotal time
Track your progressSign up free to work through all 13 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 3 questions + 3 drills · ~55 min
Explaining Visualization Tool ExperienceEasy

Explain how you use SQL analysis to build dashboards, choose visuals, and communicate insights to stakeholders.

ToolsData WranglingThe Federal National Mortgage Association - Fannie Mae
Ensuring Accurate Financial ReportsEasy

Explain how to keep financial reports accurate and consistent using SQL validation, aggregation discipline, and reconciliation checks.

Data WranglingAggregationsQualityThe Federal National Mortgage Association - Fannie Mae
Measuring Marketing Campaign SuccessMedium

Evaluates how you define metrics, select data sources, and interpret results for marketing decisions.

Metricscampaign analysisThe Federal National Mortgage Association - Fannie Mae
SQL Moving Average With WindowsMedium
Practice
Practice drill

Calculate each customer’s 30-day moving average of daily transaction totals using aggregation and a PostgreSQL window frame.

Data AnalysisJJP Morgan ChaseFinacleThe Federal National Mortgage Association - Fannie Mae
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
Clean Inconsistent Expense EntriesHard
Practice
Practice drill

Clean inconsistent expense records with CTEs, joins, CASE logic, and aggregation to summarize valid spend by department.

Data WranglingAggregationsQualityUniversity of Colorado Denver
2
Behavioral & Leadership9 questions · ~75 min
Using Data to Shift StrategyMedium

Tests data-driven influence in marketing: turning analysis into a strategic recommendation and aligning stakeholders around action.

Influence Without AuthorityCommunicationOwnershipThe Federal National Mortgage Association - Fannie Mae
Explaining Analysis to Non-Technical StakeholdersEasy

Tests communication of complex data to non-technical stakeholders, including clarity, stakeholder management, and actionable storytelling.

Influence Without AuthorityStakeholder ManagementCommunicationThe Federal National Mortgage Association - Fannie Mae
Resolving Team Disagreement on ApproachEasy
Recently asked

Tests conflict resolution in a delivery context, including communication, influence without authority, and ability to preserve team trust while reaching a decision.

Influence Without AuthorityConflict ResolutionCommunicationThe Federal National Mortgage Association - Fannie Mae
Prioritizing Conflicting Analytics RequestsEasy

Tests prioritization under ambiguity, ownership, and stakeholder management when competing analytics demands create unclear trade-offs.

coding experienceProblem Solvingtechnical discussionThe Federal National Mortgage Association - Fannie Mae
More Behavioral & Leadership questions with a free account
3
More topics1 question · ~8 min
Common Customer Analytics MethodsMedium

Explain the main statistical methods used in customer analytics and when each is appropriate.

Confidence IntervalsRegressionHypothesis TestingThe Federal National Mortgage Association - 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 13 questions plus 3 hands-on drills to finish this plan.