Dataford
Dataford
Top 25
Prep plan
Updated weekly · Last refresh Oct 7

CIBC Data Analyst Interview Questions

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

25questions
~3htotal time
Track your progressSign up free to work through all 25 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 7 questions + 3 drills · ~86 min
Handling Missing and Dirty SQL DataMedium
Recently asked

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

Data WranglingCase WhenQualityCIBC
Choosing SQL JoinsMedium
Recently asked

Assesses your foundational knowledge of SQL joins used in data preparation.

JoinssqlCIBC
Making Recommendations with DataMedium
Recently asked

Assesses how you apply data analysis to drive decisions and outcomes.

Data AnalysisCIBC
SQL Dashboard Management ExperienceMedium
Recently asked

Assesses your hands-on experience building and maintaining dashboards for stakeholders.

data visualizationCIBC
Power BI Dashboard PerformanceMedium
Recently asked

Evaluates your ability to build and optimize performant dashboards for large-scale data.

Data Analysisdata visualizationpower biCIBC
Using Window Functions in SQLMedium
Recently asked

Tests your understanding of SQL window functions for analytics and reporting.

Window FunctionssqlCIBC
SQL, Java, Polymorphism, JoinsHard
Practice
Recently asked
Practice drill

Use joins and conditional logic to summarize polymorphic account activity while retaining accounts with no recent events.

javaJoinsData ManipulationCIBC
Schema Design ScenarioHard
Practice
Practice drill

Design a normalized account schema and produce balances, owners, latest activity, and type-level rankings.

data relationshipsschema designnormalizationCIBC
Using SQL Window FunctionsMedium
Practice
Practice drill

Demonstrate LEAD, LAG, and RANK to compare employee usage across months and rank usage within each month.

Window FunctionsLag/LeadJoinsComcast
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership17 questions · ~136 min
Resolving Conflict With a ColleagueEasy
Recently asked

Tests conflict resolution in a sales context, including communication, influence, and preserving internal alignment around an account.

Conflict ResolutionCommunicationDealing With AmbiguityCIBC
More Behavioral & Leadership questions with a free account
3
More topics1 question · ~8 min
Automating Data Transformations with PythonMedium
Recently asked

Tests your practical skills for automating repeatable data workflows using Python.

AutomationpythonscriptingCIBC

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