Okay, I've searched for Data Analyst roles in New York, NY that require skills in SQL and SAS, full-time job mode, a master's degree, and at least 3 years of experience in public health or epidemiology-related fields. I have found 42 positions for you.

Sure. Here's the analysis:

Job Analysis:

The Data Analyst role within the Bureau of Epidemiology Services (BES) at the New York City Health Department is fundamentally designed to support public health decision-making by ensuring the accuracy, accessibility, and insightfulness of critical health datasets. This position sits at the nexus of rigorous data management, survey methodology, and epidemiological analysis, requiring both technical proficiency and an understanding of population health dynamics. The successful candidate will address complex challenges including maintaining and modernizing large-scale SQL databases, transitioning legacy data systems (e.g., MS Access to Voxco), and producing high-quality analytic datasets and reports that directly influence city-wide health programs. The role involves substantial cross-unit coordination—particularly with survey teams, data users across bureaus, and external stakeholders—meaning communication skills and collaborative aptitude are vital. Key qualifications like proficiency in SQL, SAS, SUDAAN, and survey data management are not arbitrary; they enable the analyst to handle varied data sources, ensure methodological rigor, and respond rapidly to ad hoc data inquiries that often come under tight deadlines. There is also a relational and strategic dimension, seen in the emphasis on training colleagues and promoting health equity through data use. Decision-making involves balancing precise technical execution with contextual judgment about data relevance and quality, often in ambiguous or evolving public health contexts. Success in the first year looks like establishing reliable, streamlined data workflows, enhancing accessibility of the NYC Health Panel data, and actively contributing to equity-oriented health insights that inform agency policies.

Company Analysis:

The New York City Department of Health and Mental Hygiene is positioned as a historic, mission-driven public sector leader in public health that places strong emphasis on equity, innovation, and community impact. This role is embedded in an organization that operates at the cutting edge of urban health challenges, balancing tradition with innovation—an environment where data is not only a technical asset but a tool of social justice. The department’s culture likely values rigor, collaboration, and inclusivity, with a strong commitment to supporting a diverse workforce as well as the health of a similarly diverse city population. For someone in this role, this environment implies the necessity of aligning technical excellence with a deeper purpose-driven motivation. The role also fits within a complex organizational structure, requiring navigation through multiple stakeholders and leaders, indicating both an opportunity and expectation for visibility and influence within the Bureau of Epidemiology Services and beyond. Strategically, this hire furthers the department’s goal of modernizing data infrastructure and enhancing analytic capabilities, crucial for maintaining NYC’s leadership in public health innovation. The stability and benefits offered by a government position, alongside the unique chance to contribute to equitable health outcomes for millions, make this role attractive to candidates seeking meaningful, impactful work rooted in data science and public health.

Absolutely. Here are some mock interview questions that could come up:

• Behavioral: Tell me about a time when you had to troubleshoot and improve a legacy data system. How did you approach training colleagues on the new system?
• Behavioral: Describe an experience where you collaborated with multiple stakeholders to fulfill a complex data request. What challenges did you face and how did you resolve them?
• Behavioral: Can you share an example of how you ensured accuracy and quality control in a large dataset? What steps did you take?
• Behavioral: Give an example of when you had to incorporate considerations of equity or social justice into your data analysis or reporting.
• Technical: How would you design and maintain a SQL database that supports rapid, high-volume ad hoc analysis requests from different departments?
• Technical: Walk me through your experience with SAS and SUDAAN. How have you used these tools specifically for survey data analysis?
• Technical: Describe your approach to creating analytic datasets, codebooks, and topline reports from large public health surveys like the Community Health Survey or Youth Risk Behavior Survey.
• Technical: What statistical considerations do you keep in mind when weighting survey data to ensure representativeness and validity?
• Situational: Imagine the NYC Health Panel is transitioning to a new data collection platform while still needing uninterrupted data access. How would you manage this migration and train staff effectively?
• Situational: You receive an urgent, incomplete data request from an external bureau that requires a quick turnaround. How do you prioritize and ensure data quality under time pressure?
• Situational: Suppose you find inconsistencies in the health equity indicators within the dataset you manage. How do you address this both methodologically and in communications with stakeholders?
• Company Fit/Motivation: What attracts you to working at the NYC Health Department, especially within the Bureau of Epidemiology Services?
• Company Fit/Motivation: How do your personal and professional values align with the department’s commitment to health equity and racial justice?
• Company Fit/Motivation: How do you see yourself contributing to the modernization and innovation efforts of NYC’s public health data infrastructure?
• Questions to Ask Interviewer: Can you describe how the Data Analyst role collaborates with other bureaus and external partners on a typical project?
• Questions to Ask Interviewer: What are the biggest challenges the SDAU team currently faces in modernizing data systems and how could this role help address them?
• Questions to Ask Interviewer: How does the NYC Health Department support professional development and ongoing learning for data analysts within BES?