Top 19
Prep plan
Updated weekly · Last refresh Aug 30

Nerdwallet Data Analyst Interview Questions

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

19questions
~3htotal time
Track your progressSign up free to work through all 19 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 5 questions · ~40 min
DAU vs MAU for Seasonal ProductMedium

Tests understanding of active-user metrics and seasonality effects.

DAU/MAUseasonalityEngagement MetricsNerdwallet
Investigating CTR Drop Root CauseHard

Tests diagnostic thinking across data, product, and instrumentation changes.

KPIDiagnosisEngagement MetricsNerdwallet
More Metrics questions with a free account
2
SQL & Data Manipulation6 questions + 3 drills · ~78 min
Top Clicked Products by StateMedium

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

Window FunctionsDate FunctionsRankingNerdwallet
Optimizing Complex SQL JoinsHard

Tests SQL performance tuning for large datasets and complex aggregations.

JoinsperformanceAggregationsNerdwallet
Weekly Renewal Rate QueryMedium

Tests ability to write correct SQL for subscription metrics.

Date Functionsfinancial dataAggregationsNerdwallet
Weekly Service KPI by TeamMedium
Practice
Practice drill

Analyze weekly service delivery performance by team using joins, a CTE, date aggregation, and KPI calculations.

KPIJoinssqlDeloitteReputation
Daily Peak-Hour Driver Acceptance RateMedium
Practice
Practice drill

Use joins, a CTE, CASE logic, and date filtering to compute daily peak-hour acceptance rate for San Francisco ride requests.

Date FunctionssqlAggregationsLyft
Track Agency Utilization QueryMedium
Practice
Practice drill

Calculate Omnicom Health team utilization by week using joins, date ranges, aggregation, and a safe percentage calculation.

Date FunctionssqlAggregationsOmnicom Health
More SQL & Data Manipulation 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.