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

BNY Mellon Data Analyst Interview Questions

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

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

Tests your judgment and controls for data integrity when decisions impact financial outcomes.

Problem Solvingdata integrityBNY Mellon
Analyzing Fixed Income Securities DataMedium

Tests your ability to structure analysis for fixed income datasets and derive actionable insights.

Data AnalysisBNY Mellon
Cleaning and Validating Financial DataMedium

Tests your data quality workflow for large financial datasets, including validation and quality checks.

data cleaningdata validationBNY Mellon
Choosing SQL Join TypesEasy

Tests your understanding of SQL joins and correct selection for relational data problems.

Data Manipulationquery optimizationBNY Mellon
Ensuring Report Accuracy for LeadersMedium

Tests your approach to verification, reconciliation, and communication of reliable results to leaders.

Stakeholder Managementdata accuracyreportingBNY Mellon
SQL, OOPs, and Data ProjectsMedium

Assesses your ability to apply SQL, reason about OOP concepts, and deliver on data project work.

projectsData StructuressqlBNY Mellon
Top Users by Recent Transaction VolumeMedium
Practice
Practice drill

Find the top 3 users by completed transaction volume in the last 30 days using joins and aggregation.

Data Analysisquery optimizationsqlTTier 1 BankRevolutChime
Top Content by Watch TimeMedium
Practice
Practice drill

Rank Disney+ Hotstar content by monthly watch time using aggregation, joins, and ROW_NUMBER().

Window FunctionsData Analysisquery optimizationDDisney+HotStar
Top Users by Region QueryMedium
Practice
Practice drill

Rank the top 10 ResMed myAir users in each region using joins, aggregation, and ROW_NUMBER().

Data AnalysissqlResmed

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 & Leadership10 questions · ~80 min
Resume Project With Business ImpactEasy

Tests ownership and data-driven communication through a concrete example of analysis that led to measurable business impact.

impactresumesuccess storyBNY Mellon
Explaining Technical Issues ClearlyMedium
Recently asked

Tests whether you can translate technical complexity into business-relevant language for non-technical stakeholders and drive action.

Stakeholder ManagementCommunicationtechnical explanationBNY Mellon
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 16 questions plus 3 hands-on drills to finish this plan.