Top 26
Prep plan
Updated weekly · Last refresh Sep 25

PNY Data Analyst Interview Questions

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

26questions
~3htotal time
Track your progressSign up free to work through all 26 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 12 questions + 3 drills · ~126 min
Ensuring Accurate Financial ReportsEasy

Explain how to keep financial reports accurate and consistent using SQL validation, aggregation discipline, and reconciliation checks.

Data WranglingAggregationsQualityPNY
Optimizing Slow PostgreSQL Research QueriesMedium

Explain how you diagnosed and optimized a slow PostgreSQL query using execution plans, indexing, and query rewrites.

JoinsData WranglingAggregationsPNY
Choosing Visualization Tools for SQL InsightsEasy

Explain which visualization tools you use after SQL analysis and why, based on audience, speed, and dashboard needs.

ToolsData WranglingAggregationsPNY
Handling Missing and Dirty SQL DataMedium

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

Data WranglingCase WhenQualityPNY
SQL Topics: Joins, CTE, DDL, DAXHard

Tests breadth of core SQL and BI skills used to build and model analytics.

JoinssqlPNY
Cleaning a Messy DatasetMedium

Assesses your data cleaning process and how you ensure analysis quality.

data cleaningPNY
SQL Window Functions ExperienceMedium
Practice
Practice drill

Use SQL window functions to rank regions by average 2024 yield within each country.

Window FunctionsJoinsData ManipulationKBRMaximus TechQinetiq
Data Visualization TechniquesMedium
Practice
Practice drill

Create monthly, region-level metrics suitable for data visualization using SQL joins, date handling, and aggregation.

analytics toolspresentationdata visualizationExperian HealthFIRSTNET GLOBALVizient
SQL Self Joins and ExplodeMedium
Practice
Practice drill

Transform comma-separated employee tags, join employees to managers, and aggregate active direct reports by manager and tag.

pysparkaggregationJoinsTredence
More SQL & Data Manipulation questions with a free account

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 & Leadership14 questions · ~112 min
Explaining Data Issues to StakeholdersMedium

Tests whether you can translate complex trends or data quality issues into clear business language and drive stakeholder alignment.

Data QualityStakeholder ManagementCommunicationPNY
Handling Critical Feedback on AnalysisEasy

Tests how you receive and act on feedback about your analysis, including communication, stakeholder management, and self-awareness.

CommunicationOwnershipDealing With AmbiguityPNY
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 26 questions plus 3 hands-on drills to finish this plan.