Top 16
Prep plan
Updated weekly · Last refresh Oct 17

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 daily.

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
SQL, OOPs, and Data ProjectsMedium

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

projectsData StructuressqlBNY Mellon
Handling Missing or Inconsistent DataMedium

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

Problem Solvingdata integrityBNY Mellon
Choosing SQL Join TypesEasy

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

Data Manipulationquery optimizationBNY 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
Ensuring Report Accuracy for LeadersMedium

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

Stakeholder Managementdata accuracyreportingBNY Mellon
Top Nth Salary Without LIMITMedium
Practice
Practice drill

Find the Nth distinct highest salary using PostgreSQL ranking without LIMIT.

Data Manipulationsql querysalaryAAbjayonDDigiValetAAmdocs
Cleaning a Messy Dataset for a High-Stakes ReportMedium
Practice
Practice drill

Clean invalid sales records and produce a region-level report with valid totals, averages, and data-quality counts.

data cleaningdata accuracydata validationApple
Detect and Resolve Duplicate TransactionsMedium
Practice
Practice drill

Identify duplicate transaction rows and explain a safe resolution process for Zions Bancorporation.

deduplicationdata cleaningdata accuracyZions Bancorporation

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
Prioritizing Under Deadline PressureMedium

Tests prioritization under pressure, ownership, and stakeholder management when several urgent demands compete at once.

stress managementperformance under pressureresilienceBNY 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.