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

Marsh Data Analyst Interview Questions

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

29questions
~4htotal time
Track your progressSign up free to work through all 29 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 3 questions · ~24 min
Diagnose Churn by Customer SegmentMedium

Investigate why one customer segment drives most churn and what actions to take.

User SegmentsChurnDiagnosisMarsh
Choosing KPI Metrics for DashboardsMedium

Tests your ability to select KPIs aligned to business goals and data analyst reporting needs.

North Star MetricKPIsDiagnosisMarsh
Revenue Impact of Marketing CampaignHard

Tests your ability to design a measurement approach and quantify business impact from marketing.

Funnel AnalysisConversion RateLTVMarsh
2
Behavioral & Leadership21 questions · ~168 min
More Behavioral & Leadership questions with a free account
3
More topics5 questions · ~40 min
Choosing Randomization Unit for UI TestMedium

Choose the right randomization unit for a customer-facing experiment and explain how that choice affects metrics, power, and validity.

ExperimentationGuardrail MetricsA/B TestingMarsh
Data Cleaning and PreparationMedium

Tests your approach to cleaning, transforming, and preparing data for reliable analysis.

Data WranglingETLQualityMarsh
Market Analysis for New ProductMedium

Tests your ability to structure market research and translate findings into product decisions.

Feature PrioritizationUser NeedsProduct VisionMarsh
Designing an A/B TestHard

Tests your experimental design thinking, including metrics, controls, and statistical validity.

MDEGuardrail MetricsA/B TestingMarsh
SQL Queries on a ScenarioMedium

Tests SQL query writing and practical data manipulation skills.

scenario analysissql queriesMarsh

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
Identify Funnel Bottlenecks in OnboardingHard
Practice
Practice drill

Use joins, CTEs, and aggregations to find the weakest step in an onboarding funnel and estimate lost conversions.

Funnel AnalysissqlDiagnosisAtlassianRevolut
Handle Missing Financial Input ValuesMedium
Practice
Practice drill

Use joins, CTEs, and CASE logic to flag and fill missing financial fields for Qlik planning records.

Data WranglingETLQualityQlik
The finish line: interview-readyComplete all 29 questions plus 3 hands-on drills to finish this plan.