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

Marsh & Mclennan Data Analyst Interview Questions

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

36questions
~5htotal time
Track your progressSign up free to work through all 36 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 3 questions · ~24 min
Large Dataset Analysis PipelineEasy

Discuss a large-scale data analysis project with focus on the pipeline, tooling, and data quality approach.

ToolsData ModelingQualityMarsh & Mclennan
Data Cleaning in ETL PipelinesEasy

Approach for cleaning and preparing raw data inside an ETL pipeline.

Data WranglingETLQualityMarsh & Mclennan
More Pipelines questions with a free account
2
Behavioral & Leadership27 questions · ~216 min
More Behavioral & Leadership questions with a free account
3
More topics6 questions · ~48 min
Evaluate a New Marketing InitiativeMedium

Design an experiment to test whether a new marketing initiative improves conversion without harming key guardrails.

ExperimentationStatistical SignificanceA/B TestingMarsh & Mclennan
SQL Query With ConditionsEasy

Tests SQL fundamentals and ability to filter and retrieve relevant data.

SubqueriesJoinsData WranglingMarsh & Mclennan
Find a Data TrendMedium

Tests your analytical thinking and ability to translate insights into results.

KPILeading IndicatorsDiagnosisMarsh & Mclennan
Linear Regression ImplementationMedium

Tests your understanding of model setup, training, and evaluation basics.

RegressionCorrelationVarianceMarsh & Mclennan
Client Satisfaction MetricsMedium

Tests your ability to select meaningful metrics and connect them to business outcomes.

KPILeading IndicatorsDiagnosisMarsh & Mclennan
Optimize a Slow QueryHard

Tests SQL performance tuning skills and ability to diagnose bottlenecks.

JoinsData WranglingCTEsMarsh & Mclennan

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
Workday Integration ExperienceHard
Practice
Practice drill

Audit latest Workday EIB and custom integration records for failures, security issues, transformation mismatches, and missing feeds.

Joinstechnical skillsCTEsMarsh & Mclennan
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
Cleaning a Messy DatasetMedium
Practice
Practice drill

Filter invalid game events and normalize event names using PostgreSQL string and null handling.

missing valuesdata cleaningnull handlingQuantiumScopelyCarvana
The finish line: interview-readyComplete all 36 questions plus 3 hands-on drills to finish this plan.