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

Nerdwallet Data Analyst Interview Questions

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

19questions
~3htotal time
Track your progressSign up free to work through all 19 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 3 drills · ~78 min
Building SQL for KPIsHard

Assesses data modeling thinking and SQL query writing to support KPI reporting at Nerdwallet.

sqlNerdwallet
Top Clicked Products by StateMedium

Tests SQL skills for segmentation, ranking, and time-window filtering.

Window FunctionsDate FunctionsRankingNerdwallet
Moving Average of Monthly DefaultsMedium
Practice
Practice drill

Calculate monthly loan defaults and a three-month moving average using PostgreSQL window functions.

Window FunctionsDate Functionsfinancial dataUnited Auto Credit
SQL for Lead Conversion RatesMedium
Practice
Practice drill

Calculate monthly paid search lead conversion rates and month-over-month percentage-point changes.

Date FunctionsJoinsConversion RateTempus AI
SQL Window Functions for Top GamesHard
Practice
Practice drill

Rank the three most purchased games for each PlayStation Network region and month.

Window FunctionsDate FunctionsJoinsPlaystation Network
More SQL & Data Manipulation questions with a free account
2
Metrics5 questions · ~40 min
Short Analysis HomeworkMedium

Assesses how you structure and execute a time-bounded analysis from question to results.

Data AnalysisNerdwallet
Defining KPIs for New FeaturesMedium

Evaluates KPI definition and the ability to translate metrics into SQL queries for Nerdwallet product decisions.

KPIsqlNerdwallet
DAU vs MAU for Seasonal ProductMedium

Tests understanding of active-user metrics and seasonality effects.

DAU/MAUseasonalityEngagement MetricsNerdwallet
More Metrics questions with a free account
3
Behavioral & Leadership5 questions · ~40 min
More Behavioral & Leadership questions with a free account
4
More topics3 questions · ~24 min
Define Metrics for New FeaturesMedium

Define a success metric for a new feature that captures real user value, not just raw usage.

MetricsFeature Prioritizationuser valueNerdwallet
A/B Test for Credit Card LayoutMedium

Tests experimental design, measurement, and practical considerations for A/B tests.

experiment designGuardrail MetricsConversion RateNerdwallet
Engagement vs Conversion Trade-offMedium

Tests product analytics judgment and metric trade-off reasoning.

Trade-offsConversion RateEngagement MetricsNerdwallet

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 19 questions plus 3 hands-on drills to finish this plan.