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

Current (NY) Data Analyst Interview Questions

The questions to prepare for a Current (NY) Data Analyst interview. Questions from real interview reports rank first. Updated daily.

15questions
~2htotal time
Track your progressSign up free to work through all 15 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 3 questions + 2 drills · ~46 min
Top Users by Recent Transaction VolumeMedium
Practice

Find the top 3 users by completed transaction volume in the last 30 days using joins and aggregation.

Data Analysisquery optimizationsqlCurrent (NY)
Optimize Slow Transaction QueriesHard

Tests query optimization skills for high-volume transaction datasets.

performanceReconciliationtransactionsCurrent (NY)
7-Day Rolling Average Balance QueryMedium
Practice
Practice drill

Calculate each Current user's seven-day rolling average balance while handling dates and missing balance values.

Window FunctionsDate Functionsnull handlingCurrent (NY)
7-Day Rolling Active UsersMedium
Practice
Practice drill

Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.

Window FunctionsDate FunctionsRunning TotalsMetaSpotifyMeta IT
More SQL & Data Manipulation questions with a free account
2
Metrics3 questions · ~26 min
Investigate Deposit Drop Root CauseHard

Tests diagnostic thinking using data segmentation, funnels, and time-series comparisons.

Funnel AnalysisDiagnosisCohort AnalysisCurrent (NY)
Checkings Health and Engagement MetricsMedium

Tests ability to define actionable product and data metrics for Current (NY) checking usage.

KPIEngagement MetricsCurrent (NY)
Calculate Mobile Banking LTVMedium

Tests proficiency in LTV modeling, assumptions, and interpretation for fintech decisions.

KPILTVCohort AnalysisCurrent (NY)
3
Behavioral & Leadership6 questions · ~53 min
More Behavioral & Leadership questions with a free account
4
More topics3 questions · ~26 min
Customer Segmentation for CurrentMedium

Assesses your ability to translate customer behavior into actionable segmentation for a consumer fintech product.

Current (NY)
A/B Testing and StatisticsMedium

Evaluates your experimental design thinking and statistical reasoning for product decisions.

experiment designCurrent (NY)
Design A/B Test for NotificationsHard

Tests experimental design, metric selection, and guardrails for fintech growth experiments.

experiment designGuardrail Metricsprimary metricsCurrent (NY)

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