Dataford
Top 35
Prep plan
Updated weekly · Last refresh Aug 30

CVS Health Financial Analyst Interview Questions

The questions to prepare for a CVS Health Financial Analyst interview. Questions from real interview reports rank first. Updated weekly.

35questions
~5htotal time
Track your progressSign up free to work through all 35 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 10 questions + 3 drills · ~110 min
Translate VLOOKUP to SQL JoinsEasy

Explain how Excel VLOOKUP maps to SQL joins, including exact matches, missing values, and why LEFT JOIN is usually the closest equivalent.

JoinsData WranglingCase WhenCVS Health
VLOOKUP vs INDEX MATCH in SQLMedium

Explain VLOOKUP vs INDEX/MATCH and how lookup design maps to SQL joins and key matching.

JoinsData WranglingAggregationsCVS Health
SQL: Store Performance and MarginHard
Practice
Practice drill

Join CVS store, sales, and inventory data to calculate margin, rank stores, and flag underperforming locations.

JoinsGroup ByAggregationsCVS Health
Top Paid Per DepartmentEasy
Practice
Practice drill

Find the top 3 highest-paid employees in each department using window functions.

Window FunctionsRankingBrillioAubay SpainSabre Systems
SQL: 7-Day Rolling AverageMedium
Practice
Practice drill

Calculate each CVS store's 7-day rolling sales average using a CTE, aggregation, join, and window function.

Window FunctionsDate FunctionsRunning TotalsCVS Health
More SQL & Data Manipulation questions with a free account
2
Strategy5 questions · ~40 min
Sizing an Untapped Product MarketHard

Framework for estimating TAM, adoption, and revenue for a new product launch in an untapped market.

revenue modelnew product launchMarket SizingCVS Health
Salary ExpectationsEasy

Tests compensation alignment for the Research Scientist role.

EstimationPricing StrategyCVS Health
More Strategy 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
Behavioral & Leadership16 questions · ~128 min
More Behavioral & Leadership questions with a free account
4
More topics4 questions · ~32 min
Financial Modeling ExperienceMedium

Tests your ability to build and interpret models that support decisions in structured finance and related markets.

RegressionCorrelationTime SeriesCVS Health
Analyze Sales for StrategyMedium

Tests analytical approach to translating sales data into actionable strategy.

KPIsLeading IndicatorsDiagnosisCVS Health
Variance Analysis ApproachMedium

Tests your method for explaining variances and translating them into actionable insights.

Data WranglingFinancial StatementsFinancial ModelingCVS Health
Three Financial Statements WalkthroughMedium

Assesses your ability to explain what each statement shows and how they connect.

Financial StatementsCVS Health
The finish line: interview-readyComplete all 35 questions plus 3 hands-on drills to finish this plan.