Top 13
Prep plan
Updated weekly · Last refresh Sep 26
N

New York City Department of Health and Mental Hygiene Data Analyst Interview Questions

The questions to prepare for a New York City Department of Health and Mental Hygiene Data Analyst interview. Questions from real interview reports rank first. Updated daily.

13questions
~2htotal time
Track your progressSign up free to work through all 13 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 3 drills · ~78 min
Data Quality Checks and DocumentationMedium

Assesses your rigor in validating data quality and documenting assumptions for downstream users.

Data Qualitydata managementdocumentationNNew York City Department of Health and Mental Hygiene
SQL Design and MaintenanceMedium

Assesses your ability to design, maintain, and query databases reliably for analytical use cases.

data managementsqldatabase designNNew York City Department of Health and Mental Hygiene
Using SAS, R, or SQLMedium

Assesses your practical experience with analytical tooling for data manipulation and transformation.

sqlNNew York City Department of Health and Mental Hygiene
Cleaning Raw Survey DataMedium

Tests your data cleaning workflow and readiness checks for survey datasets.

data preparationdata cleaningNNew York City Department of Health and Mental Hygiene
Leading a Data Management ProjectMedium

Evaluates your leadership, problem solving, and execution on complex data management work.

experiencedata managementProject ManagementNNew York City Department of Health and Mental Hygiene
Maintaining Dataset IntegrityMedium

Evaluates your methods for preventing data corruption, leakage, and unintended transformations.

data cleaningprocessdata integrityNNew York City Department of Health and Mental Hygiene
SQL Deduplication for Longitudinal DataHard
Practice
Practice drill

Identify duplicate patient records, migrate study visits, and delete duplicates while preserving longitudinal data integrity.

deduplicationdata cleaningdata managementPra Health Sciences
SQL, Modeling, and Streaming DesignMedium
Practice
Practice drill

Design a relational streaming-event model and return each actor's latest processed event using a CTE and window function.

data managementsqldatabase designRoblox
Integration Methods You’ve UsedHard
Practice
Practice drill

Summarize documented integration methods, usage counts, selection contexts, and latest decision dates with a PostgreSQL query.

experienceJoinsdata managementSalesforce
2
Behavioral & Leadership6 questions · ~48 min
Explaining Analysis to Non-Technical StakeholdersEasy

Tests communication of complex data to non-technical stakeholders, including clarity, stakeholder management, and actionable storytelling.

Influence Without AuthorityStakeholder ManagementCommunicationNNew York City Department of Health and Mental Hygiene
More Behavioral & Leadership questions with a free account
3
More topics1 question · ~8 min
The finish line: interview-readyComplete all 13 questions plus 3 hands-on drills to finish this plan.