Dataford
Top 50
Prep plan
Updated weekly · Last refresh Aug 30

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 weekly.

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

Tests your career planning and whether your trajectory aligns with the AE path.

Go-to-MarketGrowth StrategyProduct VisionJohn Hancock
Market Outlook ResponseMedium

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

AnalysisJohn Hancock
Resume WalkthroughEasy

Tests your ability to tell a coherent story about your background and relevance to Baird research.

EstimationUser ResearchJohn Hancock
2
Finance & Accounting5 questions · ~40 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 & Leadership40 questions · ~320 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
Monthly Fusion Team Adoption SummaryMedium
Practice
Practice drill

Use joins, a CTE, CASE, and date functions to summarize monthly Autodesk Fusion team activity and paid-seat adoption.

Data ManipulationExcelFinancial AnalysisAutodesk
Excel Live AssessmentMedium
Practice
Practice drill

Use joins, CASE logic, and aggregation to recreate an Excel-style lookup and pivot report.

PivotData ManipulationExcelAmazon Web Services
Normalize Customer Addresses by RegionHard
Practice
Practice drill

Standardize inconsistent addresses using joins, CTEs, and CASE logic to map each record to a normalized region.

data cleaningData WranglingExcelTelus Digital
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.