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

Marsh Data Analyst Interview Questions

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

33questions
~5htotal time
Track your progressSign up free to work through all 33 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 3 questions + 2 drills · ~45 min
SQL Joins and AggregationsMedium
Practice

Join policy and ISO ClaimSearch claim data to aggregate claim counts and incurred losses by state and policy type.

JoinsGroup ByAggregationsMarsh
SQL Queries on a ScenarioMedium

Tests SQL query writing and practical data manipulation skills.

scenario analysissql queriesMarsh
Data Cleaning and PreparationMedium

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

Data WranglingETLQualityMarsh
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
Managing the 'Everything' Dashboard RequestMedium
Practice
Practice drill

Create a unified Johns Hopkins University dashboard result by combining department activity, users, and targets.

User NeedsJoinsData WranglingThe Johns Hopkins University
2
Metrics3 questions · ~25 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
More Metrics questions with a free account
3
Behavioral & Leadership24 questions · ~201 min
More Behavioral & Leadership questions with a free account
4
More topics3 questions · ~25 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
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

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