Top 50
Prep plan
Updated weekly · Last refresh Oct 17

Freddie Mac Data Analyst Interview Questions

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

50questions
~8htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 10 questions · ~94 min
SQL CTE for Top 3 ProductsMedium
Practice

Use CTEs, joins, aggregation, and ROW_NUMBER to identify Freddie Mac's top three products by completed-order revenue.

RankingCTEsAggregationsFreddie Mac
SQL Inner Join for MatchesEasy
Practice

Filter Freddie Mac loan records to return only current loans, ordered by loan identifier.

SubqueriesJoinsData WranglingFreddie Mac
More SQL & Data Manipulation questions with a free account
2
A/B Testing & Experimentation5 questions · ~47 min
Design Test for New FeatureMedium

Design an A/B test for a new platform feature, including success metrics, power, guardrails, and a clear ship decision.

experiment designfeature evaluationA/B TestingFreddie Mac
Handle Peeking in Customer ExperimentsHard

Decide how to analyze an experiment when results are checked repeatedly and multiple comparisons may inflate false positives.

PeekingExperimentationStatistical SignificanceFreddie Mac
More A/B Testing & Experimentation 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 & Probability10 questions · ~94 min
Mean and Variance of DataEasy

Compute the mean and variance of a numeric dataset from first principles.

DistributionsVarianceExpected ValueFreddie Mac
More Statistics & Probability questions with a free account
4
Metrics10 questions · ~94 min
Define a Product North StarMedium

Define a North Star Metric for a product and explain how it guides KPI selection and growth decisions.

User SegmentsNorth Star MetricKPIsFreddie Mac
More Metrics questions with a free account
5
Pipelines10 questions · ~94 min
Data Cleaning in ETL PipelinesEasy

Approach for cleaning and preparing raw data inside an ETL pipeline.

Data WranglingETLQualityFreddie Mac
More Pipelines questions with a free account
6
Product Sense3 questions · ~28 min
Align Product With User NeedsMedium

A framework for connecting user needs to business goals, then making product decisions with clear trade-offs and measurable outcomes.

User NeedsValue PropositionProduct VisionFreddie Mac
More Product Sense questions with a free account
7
More topics2 questions · ~19 min
More questions with a free account
The finish line: interview-readyComplete all 50 questions to finish this plan.