Top 17
Prep plan
Updated weekly · Last refresh Oct 17

SmithRx Data Analyst Interview Questions

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

17questions
~2htotal time
Track your progressSign up free to work through all 17 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 7 questions + 2 drills · ~81 min
Replace VLOOKUP with SQL JoinsEasy

Explain how SQL JOINs replace VLOOKUP when combining two datasets using a shared unique identifier.

PivotJoinsData WranglingSmithRx
Month-Over-Month Active GrowthMedium

Tests ability to model time-based metrics and compute MoM growth correctly in SQL.

Date FunctionssqlRunning TotalsSmithRx
Top Spenders Per ClientMedium
Practice

Rank members by total spending within each client account and return the top three using PostgreSQL window functions.

Window FunctionsJoinsRankingSmithRx
Group By vs Window FunctionsMedium

Tests SQL design tradeoffs and performance-aware query planning.

Window FunctionsperformanceGroup BySmithRx
Pivot Tables for Drug Tier MixEasy

Tests practical data exploration skills for tier-based claim distribution analysis.

PivotExcelAggregationsSmithRx
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
Rolling Average Payroll VolumeMedium
Practice
Practice drill

Calculate Gusto payroll submission volume and its 7-day rolling average for each active business category.

Window FunctionsDate FunctionsJoinsGusto
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership8 questions · ~70 min
Delivering Analysis Without Full InputsMedium

Tests prioritization under pressure when dependencies block progress, including stakeholder management, influence without authority, and ownership of the outcome.

time managementcross-functional collaborationdeadline managementSmithRx
More Behavioral & Leadership questions with a free account
3
More topics2 questions · ~17 min
Executive Metrics for Approval RatesMedium

Tests metric selection and visualization choices for executive decision-making on pharmacy operations.

KPIdashboardingSmithRx
Dashboard Detail vs SummaryMedium

Tests product thinking about audience needs and information hierarchy in analytics dashboards.

Feature PrioritizationUser NeedsdashboardingSmithRx

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