Top 17
Prep plan
Updated weekly · Last refresh Aug 30

Collinson Financial Analyst Interview Questions

The questions to prepare for a Collinson Financial Analyst interview. Questions from real interview reports rank first. Updated weekly.

17questions
~2htotal time
Track your progressSign up free to work through all 17 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 3 drills · ~78 min
Reconciling Discrepant Financial DataMedium

Explain how to reconcile discrepant financial datasets using joins, CTEs, aggregations, and exception classification.

JoinsData WranglingQualityCollinson
Validating Data Before ReportingEasy

Explain how to validate SQL data before reporting, including null checks, duplicates, outliers, and aggregation reconciliation.

JoinsData WranglingQualityCollinson
Build a Forecast From ScratchMedium

Tests your forecasting methodology, assumptions management, and end-to-end execution.

ForecastingData AnalysisFinancial ModelingCollinson
Model Cost Increase ImpactHard

Tests your financial modeling skills and ability to translate cost changes into forecast impacts.

scenario analysiscost analysisFinancial ModelingCollinson
ERP and Accounting ToolsEasy

Tests your hands-on experience with accounting systems relevant to Collinson's finance operations.

technical experienceerp systemsCollinson
Accuracy With Large DatasetsMedium

Tests your data quality controls, validation approach, and attention to detail.

Data AnalysisAccuracydata integrityCollinson
Resolve Conflicting Customer AttributesMedium
Practice
Practice drill

Use joins, CTEs, and row ranking to resolve conflicting customer profile values across ACME House systems.

JoinsData WranglingQualityRamsey SolutionsACME House
Reconcile Conflicting Invoice TotalsMedium
Practice
Practice drill

Reconcile billing and ERP invoice totals using joins, a CTE for latest snapshots, and CASE-based discrepancy classification.

JoinsData WranglingQualityLiterati
Audit CRM Data Integrity by TeamMedium
Practice
Practice drill

Use joins and CASE WHEN to find CRM records with missing, invalid, or conflicting ownership data by team.

JoinsData WranglingQualityAlphaSense

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
2
Behavioral & Leadership11 questions · ~88 min
Prioritizing Under a Tight DeadlineMedium

Tests prioritization under pressure, including trade-off judgment, stakeholder alignment, and ownership of outcomes.

project experiencetime managementPrioritizationCollinson
Handling Stakeholder Disagreement ConstructivelyMedium

Tests conflict resolution and influence without authority when a stakeholder or financial advisor disagrees with your recommendation.

Influence Without AuthorityConflict ResolutionStakeholder ManagementCollinson
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 17 questions plus 3 hands-on drills to finish this plan.