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

Collinson Data Analyst Interview Questions

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

15questions
~2htotal time
Track your progressSign up free to work through all 15 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 7 questions + 3 drills · ~86 min
Validating Data Before ReportingEasy

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

JoinsData WranglingQualityCollinson
Handling Missing and Dirty SQL DataMedium

Explain how to profile, clean, and standardize missing or dirty data before analysis.

Data WranglingCase WhenQualityCollinson
Finding Drop-Off DriversHard

Tests your ability to derive actionable insights from data using rigorous analysis.

Data Analysisuser engagementCollinson
Explaining Trends to ManagersHard

Tests your data storytelling and visualization skills for stakeholder decision-making.

Communicationdata visualizationCollinson
SQL for Complex RequestsMedium

Tests your SQL problem-solving approach and ability to deliver clear results.

Data Analysiscomplex queriessqlCollinson
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
Normalize Messy CRM Contact DataHard
Practice
Practice drill

Clean inconsistent CRM contacts by joining source tables, standardizing values, and flagging bad records.

Data WranglingCase WhenQualityAlphaSense
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership6 questions · ~48 min
Handling Critical Feedback on AnalysisEasy

Tests how you receive and act on feedback about your analysis, including communication, stakeholder management, and self-awareness.

CommunicationOwnershipDealing With AmbiguityCollinson
More Behavioral & Leadership questions with a free account
3
More topics2 questions · ~16 min
Predicting Churn and LoyaltyMedium

Tests your modeling choices for churn and loyalty prediction in a customer behavior context.

Collinson
Revamping Customer PropositionMedium

Assesses product sense and analytical thinking for improving customer propositions at Collinson.

experienceCollinson

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