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

Macquarie Group Business Analyst Interview Questions

The questions to prepare for a Macquarie Group 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
SQL & Data ManipulationStart here. 3 questions + 2 drills · ~45 min
SQL Window Functions for Portfolio AnalysisHard
Practice
Recently asked

Rank portfolios by monthly net transaction value using PostgreSQL window functions.

Window FunctionsPivotfinancial dataMacquarie Group
Customer Orders: LEFT vs INNER JOINEasy
Recently asked

Explain how INNER JOIN and LEFT JOIN differ, and when to use each for matched-only versus all-left-row analysis.

JoinsData WranglingGroup ByMacquarie Group
SQL Top Five CustomersEasy
Practice
Practice drill

Find Farallon Capital Management's top five customers by aggregated sales volume using filtering, GROUP BY, ORDER BY, and LIMIT.

RankingGroup ByAggregationsFarallon Capital ManagementMacquarie GroupNyc Staffing
Complex Joins for ReconciliationHard
Practice
Practice drill

Reconcile duplicate, missing, and mismatched transaction records across two source systems using complex joins and layered aggregation.

complex queriessqldata validationMacquarie GroupHHackerRank
More SQL & Data Manipulation questions with a free account
2
Finance & Accounting5 questions · ~41 min
Time Value of Money and DiscountingMedium
Recently asked

Evaluates your understanding of discounting and time value of money concepts.

cash flowmotivationMacquarie Group
Calculate Compound GrowthHard
Recently asked

Tests mental math and financial reasoning for compound growth calculations.

Macquarie Group
More Finance & Accounting questions with a free account
3
Execution4 questions · ~33 min
5L and 3L Jug to Make 4LHard
Recently asked

Tests structured problem solving and ability to reason through constraints.

logicProblem SolvingMacquarie Group
More Execution questions with a free account
4
Behavioral & Leadership35 questions · ~288 min
More Behavioral & Leadership questions with a free account
5
More topics3 questions · ~25 min
Resume WalkthroughEasy
Recently asked

Present a concise, structured resume walkthrough that connects your experience to the Research Analyst role at Baird.

Estimationanalytical thinkingBusiness AcumenMacquarie Group
Manual Compound Growth under PressureMedium
Recently asked

Tests mental math approach and structured thinking for compound growth scenarios.

financial calculationsmental mathMacquarie Group
Structure a Trading Desk Business CaseHard
Recently asked

Tests product sense and ability to structure ROI and risk for trading-focused initiatives.

Value PropositionUse CasesMacquarie Group

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