Dataford
Top 50
Prep plan
Updated weekly · Last refresh Sep 10

Marsh & Mclennan Business Analyst Interview Questions

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

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
ExecutionStart here. 6 questions · ~48 min
Your Strengths and WeaknessesEasy

Tests self-awareness and how you position yourself for success in an Account Executive role at Aqr.

Trade-offsSuccess CriteriaRisk AssessmentMarsh & Mclennan
Managing Multiple ProjectsMedium

Assesses your ability to prioritize work and deliver across concurrent UX/UI initiatives.

organizationProject ManagementMarsh & Mclennan
More Execution questions with a free account
2
Strategy3 questions · ~24 min
Tell Me About YourselfEasy

Craft a concise self-introduction that highlights fit, communication style, and relevance for an Account Executive role.

brand cultureBusiness AcumenCompetitive AnalysisMarsh & Mclennan
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
SQL & Data Manipulation6 questions + 3 drills · ~78 min
SQL and Data Tools ExperienceMedium

Assesses your data tooling familiarity for analysis tasks.

ToolsData AnalysisMarsh & Mclennan
Excel for Data AnalysisMedium

Assesses practical Excel usage for analyzing and interpreting data.

Data AnalysisExcelMarsh & Mclennan
Click-Through Rate Per CampaignMedium
Practice
Practice drill

Calculate click-through rate per campaign using a join and conditional aggregations.

null handlingJoinssql queryAmazon DSP
SQL for Underperforming ShiftsMedium
Practice
Practice drill

Find the lowest-performing 10% of monthly shifts using performance ratios, ranking, and date filtering.

Date Functionsnull handlingsql queryttjx
SQL for Search Filters Leading to No ResultsMedium
Practice
Practice drill

Rank the three most common Airbnb search filter combinations associated with zero-result sessions.

null handlingJoinsData AnalysisAirbnb
More SQL & Data Manipulation questions with a free account
4
Behavioral & Leadership32 questions · ~256 min
More Behavioral & Leadership questions with a free account
5
More topics3 questions · ~24 min
MWRR/TWRR and Cash FlowHard

Evaluates your ability to explain investment return metrics and connect them to cash flow concepts.

cash flowfinancial metricsMarsh & Mclennan
Statistical Project DepthHard

Evaluates your statistical reasoning and ability to handle complex analytics work.

Marsh & Mclennan
Investment Growth CalculationHard

Tests quantitative reasoning and ability to set up a time-value-of-money calculation.

financial planningMarsh & Mclennan
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.