Top 20
Prep plan
Updated weekly · Last refresh Oct 17

New York Life Data Analyst Interview Questions

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

20questions
~3htotal time
Track your progressSign up free to work through all 20 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 3 questions · ~26 min
Data Profiling in ETL PipelinesEasy

Discuss practical data profiling techniques used to understand source quality before and during ETL development.

Data ModelingQualityNew York Life
Metadata Management for Data GovernanceMedium

Tests understanding of metadata, lineage, and governance practices in regulated environments.

regulatory constraintsNew York Life
Measuring Enterprise Data QualityMedium

Tests ability to set data quality standards, metrics, and monitoring for enterprise governance.

Data Qualitydata warehouseQualityNew York Life
2
SQL & Data Manipulation4 questions + 2 drills · ~54 min
Ensuring Data QualityMedium

Evaluates your approach to data quality checks, validation, and remediation in analytics pipelines.

Data QualityvalidationNew York Life
SQL Deduplication for TransactionsMedium
Practice

Identify duplicate transaction records and mark the retained row using PostgreSQL window functions.

deduplicationdata cleaningsqlNew York Life
Optimizing Slow Multi-Join QueriesHard

Tests performance tuning, query planning, and join strategy choices for large financial data.

Performance TuningJoinsfinancial dataNew York Life
Handling Missing and Corrupt DataMedium

Tests practical data cleaning, validation, and recovery strategies for large-scale datasets.

null handlingData WranglingpythonNew York Life
SQL Random Number SelectionEasy
Practice
Practice drill

Select five random numbers from a PostgreSQL table using randomized ordering and a row limit.

Data Manipulationsqldatabase queryingNew York Life
SQL For Multiple Active PoliciesMedium
Practice
Practice drill

Identify New York Life policyholders with multiple active policies spanning at least two product lines.

JoinsGroup ByHavingNew York Life

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Behavioral & Leadership13 questions · ~112 min
Resolving Data Quality Under PressureMedium

Tests ownership of data quality issues, risk communication to leadership, and stakeholder management under business pressure.

Data QualityCommunicationLeadershipNew York Life
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 20 questions plus 2 hands-on drills to finish this plan.