Dataford
Top 3
Prep plan
Updated weekly · Last refresh Sep 22
C

Connor Clark & Lunn Financial Group Data Analyst Interview Questions

The questions to prepare for a Connor Clark & Lunn Financial Group Data Analyst interview. Questions from real interview reports rank first. Updated daily.

3questions
~1htotal time
Track your progressSign up free to work through all 3 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 1 question + 3 drills · ~38 min
Ensuring SQL Data AccuracyEasy
Recently asked

Explain how to ensure data accuracy in SQL workflows using validation checks, reconciliation, and careful query design.

JoinsData WranglingQualityCConnor Clark & Lunn Financial Group
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
2
Behavioral & Leadership2 questions · ~16 min
Biggest Achievement and PrideEasy
Recently asked

Assesses ownership, impact, judgment, and self-awareness through a candidate's most meaningful professional achievement.

achievementaccountabilitybehavioralCConnor Clark & Lunn Financial Group
Motivation for Finance WorkEasy
Recently asked

Tests intrinsic motivation for finance through a concrete example, including business impact and long-term career fit.

CommunicationLeadershipOwnershipCConnor Clark & Lunn Financial Group

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