New York City Department of Health and Mental Hygiene Data Analyst interview questions & guide 2026

The following questions are representative of those reported in recent interview experiences. While the process can vary by bureau and team, you should focus on demonstrating both your technical proficiency and your commitment to the agency’s mission.

Behavioral and Culture Fit

These questions assess your communication style, your ability to work within a large public agency, and your alignment with the values of the NYC DOHMH.

• Why do you want to work for the NYC DOHMH specifically?
• Describe a time you had to explain complex data to a non-technical stakeholder.

Preparation for the NYC DOHMH requires a blend of technical readiness and a deep understanding of public health data challenges. You should be prepared to discuss your past projects in detail, focusing on the "how" and "why" behind your technical choices.

Role-related knowledge – You must be proficient in the tools essential to the role, specifically SAS, SQL, and R. Interviewers will look for your ability to manage the full data lifecycle, from raw data ingestion and cleaning to the creation of final analytic datasets and codebooks.

Problem-solving ability – The agency deals with complex, real-world data that is rarely "clean." Demonstrate your analytical process by discussing how you troubleshoot data discrepancies, manage large survey datasets, and maintain rigorous documentation protocols.

Collaboration and Communication – As a Data Analyst, you will work with multiple bureaus and stakeholders. You must show that you can interact professionally with people from diverse backgrounds and that you are comfortable having your work checked by others, as well as checking the work of your peers.

Commitment to Public Health – The NYC DOHMH values a demonstrated commitment to health equity. Be ready to articulate how your data work can contribute to reducing health disparities and protecting the well-being of New Yorkers.

The interview process at the NYC DOHMH is generally structured to assess your technical fit for specific bureau needs and your ability to function within a public health agency. Most candidates participate in a panel-style interview, which allows multiple team members to evaluate your skills and collaborative nature simultaneously.

Expect a process that prioritizes practical application over abstract theory. You may be asked about your specific experience with tools like SAS or SQL and how you have applied them to past research or data management projects. The pace is professional and mission-focused, reflecting the agency's responsibility to the public.

The timeline above illustrates a standard progression from initial application to panel interviews. Use this to structure your preparation; ensure your resume clearly maps to the technical requirements listed in the job description, as the initial screening often focuses heavily on these specific skill sets.

Technical Proficiency

The agency relies on specific statistical and database tools to maintain their data infrastructure. You will be evaluated on your mastery of these tools and your ability to apply them to survey data.

Be ready to go over:

• SQL – Focus on your ability to design, maintain, and query databases.
• Statistical Packages – Highlight your fluency in SAS, R, or SUDAAN.
• Data Management – Explain your process for creating datasets, including merging, cleaning, recoding, and labeling variables.

Advanced concepts (less common):

• Geocoding and spatial data management.
• Protocol development for data-related processes.
• Experience with Microsoft Access for front-end database interaction.

Example questions:

• "How do you ensure the integrity of your datasets during the cleaning process?"
• "Describe a challenging data management project you led."

As a Data Analyst, your daily work revolves around the entire data lifecycle of public health surveys. You will be responsible for creating, merging, and cleaning datasets, ensuring that all variables are properly coded and documented. This includes maintaining codebooks and supporting documentation that allow other team members to use the data effectively.

Collaboration is a core component of the role. You will frequently assist with data analysis requests and provide support to other bureaus, necessitating clear communication and a willingness to engage in peer review. You may also be involved in managing enrolled panelists, processing withdrawals, and handling invitation distribution lists, which requires extreme attention to detail and adherence to strict data security protocols.

A competitive candidate for the Data Analyst role at the NYC DOHMH typically possesses a strong academic background combined with practical, hands-on experience in research or data management.

• Must-have skills:

  • A Master’s degree in a relevant field.
  • At least two years of full-time research or data management experience.
  • At least one year of experience creating and maintaining SQL databases.
  • Proficiency in R, SAS, and/or SQL.

• Nice-to-have skills:

  • Fluency in SUDAAN or Microsoft Access.
  • Prior experience with health survey development or administration.
  • Familiarity with developing protocols for data-related processes.

Q: How difficult are the interviews? A: Experiences vary, but the interviews are typically straightforward and focus on your past work and technical skills. Focus on being clear, professional, and prepared to discuss your specific contributions to projects.

Q: What is the best way to prepare for the technical portion? A: Review your past projects involving SQL and statistical programming. Be ready to explain the "why" behind your data cleaning choices and how you documented your workflow.

Q: Is the team environment collaborative? A: Yes. The NYC DOHMH emphasizes teamwork and peer review. Demonstrating that you are comfortable with collaborative analysis and stakeholder management is essential.

Q: How long is the hiring process? A: The process can take several weeks or months. It typically involves an application review, a screening call, and one or more panel interviews.

• Highlight your impact: When discussing past projects, emphasize how your data work led to better outcomes or improved processes.
• Be ready for behavioral questions: The NYC DOHMH values professionals who can navigate diverse stakeholder environments. Use the STAR method (Situation, Task, Action, Result) to structure your answers.
• Showcase your attention to detail: In a public health agency, data accuracy is paramount. Provide examples of how you have implemented quality control measures in your work.
• Professionalism is key: Always treat every interaction with respect. Regardless of the interviewer's role, maintain a polite and professional demeanor at all times.

The Data Analyst position at the NYC DOHMH offers a unique opportunity to apply your technical skills to improve the health and well-being of millions of New Yorkers. By focusing your preparation on your proficiency with SAS, SQL, and R, and by demonstrating your ability to collaborate across diverse teams, you will be well-positioned for success.

Candidates can explore additional interview insights, practice questions, and preparation resources on Dataford. Remember that your ability to communicate the impact of your data work is just as important as the code you write. Prepare your stories, refine your technical explanations, and approach the process with confidence.

The provided salary data reflects the specific compensation for this role, which is generally set based on the bureau and grant funding. Use this information to understand the expected range for the position and to ensure your expectations align with the public sector pay structure.