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

John Hancock Financial Analyst Interview Questions

The questions to prepare for a John Hancock 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
StrategyStart here. 3 questions · ~24 min
Where You See YourselfEasy

Explain how your skills, client impact, and career ambitions would develop over five years as a BlackRock Account Executive.

analytical thinkingBusiness AcumenGo-to-MarketJohn Hancock
Resume WalkthroughEasy

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

Estimationanalytical thinkingBusiness AcumenJohn Hancock
Market Outlook ResponseMedium

Assesses your ability to interpret market conditions and translate them into forward-looking decisions.

AnalysisJohn Hancock
2
Finance & Accounting6 questions · ~48 min
12b-1 FeeMedium

Evaluates knowledge of mutual fund fee structures and implications.

John Hancock
Glide Path ExplanationMedium

Assesses understanding of retirement investment concepts and terminology.

John Hancock
Increase Equity DriversMedium

Evaluates your understanding of financial drivers that impact equity in an insurance context.

John Hancock
More Finance & Accounting 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
Behavioral & Leadership39 questions · ~312 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~16 min
Statistics BackgroundMedium

Assesses statistical foundations relevant to financial analysis.

backgroundstatisticsJohn Hancock
Excel Data ManipulationMedium

Evaluates your practical Excel skills for transforming data into usable financial insights.

Data ManipulationExcelJohn Hancock
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
Your Data ProjectMedium
Practice
Practice drill

Use joins, aggregation, and a CTE to identify TikTok Shop sellers with at least two completed orders.

experienceJoinsData ManipulationTikTokTikTok Shop
Cleaning Inconsistent Log Data in ExcelMedium
Practice
Practice drill

Clean inconsistent log fields with PostgreSQL string, timestamp, NULL-handling, and conditional functions.

data cleaningData Manipulationinconsistent dataOpenX
Technical Excel FunctionsEasy
Practice
Practice drill

Return the latest response for each Excel function question using a left join and row numbering.

Data Manipulationtechnical skillsexcel functionsAlvarez & Marsal
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.