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

Macquarie Group Financial Analyst Interview Questions

The questions to prepare for a Macquarie Group Financial 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. 5 questions + 3 drills · ~70 min
Handling Duplicates and Nulls in SQLEasy
Recently asked

Explain practical SQL approaches for identifying, removing, and preventing duplicates and NULL-related data quality issues.

Data WranglingGroup ByCase WhenMacquarie Group
Difference Between WHERE and HAVING ClausesEasy
Recently asked

Explain the differences between WHERE and HAVING clauses in SQL and when to use each.

JoinsData WranglingAggregationsMacquarie 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
SQL Duplicate DetectionEasy
Practice
Practice drill

Find duplicate customer profiles by grouping on identifying fields and returning only repeated records.

Group ByHavingAggregationsAdtalem Global EducationUniversity of Southern CaliforniaBlue Cross Blue Shield of Michigan
SQL Window Functions for Portfolio AnalysisHard
Practice
Recently asked
Practice drill

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

Window FunctionsPivotfinancial dataMacquarie GroupThe Blackstone Group
More SQL & Data Manipulation questions with a free account
2
Strategy5 questions · ~40 min
Tell Me About YourselfEasy
Recently asked

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

brand cultureBusiness AcumenCompetitive AnalysisMacquarie Group
How Would You Invest $1mMedium
Recently asked

Evaluates your investment approach, assumptions, and risk awareness for a portfolio decision.

financial planningMacquarie Group
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
Finance & Accounting25 questions · ~200 min
Risks in Investing in Toll RoadsMedium
Recently asked

Evaluates your ability to identify and analyze project and investment risks for infrastructure assets.

Financial AnalysisMacquarie Group
Depreciation Impact on FinancialsHard
Recently asked

Evaluates your understanding of how depreciation flows through the income statement, balance sheet, and cash flow.

Financial StatementsdepreciationMacquarie Group
More Finance & Accounting questions with a free account
4
Statistics & Probability5 questions · ~40 min
Growth Rate MathMedium
Recently asked

Tests your ability to reason about exponential growth and translate it into time estimates.

logicProblem SolvingMacquarie Group
Sequential Probability ApproachHard
Recently asked

Tests problem-solving methodology and ability to apply probability concepts sequentially.

EstimationProblem SolvingConditional ProbabilityMacquarie Group
More Statistics & Probability questions with a free account
5
Behavioral & Leadership10 questions · ~80 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.