Prepare for and practice interview questions from Public health solutions.

Public health solutions Interview Questions

Public health solutions Interview Guides

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Write a query to randomly sample a row from a big table.

Random SQL Sample

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Public health solutions Salaries by Position

Company overview: With an annual budget of $2.3 billion and more than 7,000 employees throughout the five boroughs, the New York City Department of Health and Mental Hygiene (NYC DOHMH) is one of the largest public health agencies in the world, serving 8 million New Yorkers from diverse ethnic and cultural backgrounds. We're tackling a broad range of public health issues with innovative policies and programs and getting exceptional results, but our work is never finished. The breadth of our innovative programs provides the widest range of choices for every member of our team. With grant funds from the Centers for Disease Control and Prevention (CDC), DOHMH is undertaking a new initiative that will meet critical infrastructure needs and make possible strategic investments that will have lasting effects on public health. Investments and improvements through this initiative will help modernize DOHMHs foundational capabilities and data infrastructure, enabling it to partner in complex health and health care environments and, in turn, support better public health outcomes, including COVID-19. This initiative supports larger efforts to rebalance investments in public health and more equitably serve communities and populations. The selected candidate will be an employee of Public Health Solutions, a nonprofit organization which is the fiscal and administrative manager of the grant but will work be supervised by DOHMH. This is a grant-funded position ending in November 2027. Program description: The New York City Department of Health and Mental Hygiene (DOHMH)s Office of Emergency Preparedness and Response (OEPR) was created to promote DOHMHs and NYCs ability to prevent, prepare for, respond to, and recover from health emergencies. OEPR is responsible for coordinating agency-wide emergency preparedness planning, exercises and training, evaluation of incident response and exercise performance as well as coordinating with community stakeholders and city, state, and federal partners on public health emergency planning and response. Summary of position: DOHMH has an opening for a Public Health Data Analyst. Reporting to the Director of Data & Analytics, this position is in the Bureau of Emergency Field Response (BEFO). The selected candidate will assist with ongoing analyses and the development of the technological infrastructure for future public health emergencies using lessons learned in the COVID-19 response. Duties: Key responsibilities include: Assist with and conducts research and analysis using a variety of quantitative methods across the Bureau including working with the Planning and Training, Operations, Logistics, and Exercises, and Medical Reserve Corps-Emergency Staffing Units. Collaborate with internal and external stakeholders to develop, document and maintain policies, procedures, systems, and applications to support citywide health emergency field operations Assist teams from across the Health Department and City on ways to best leverage, utilize, and even establish standards on the use and application of data, data formats, and data analytical tools across projects. Manage large datasets within SQL Server Database across multiple servers. Assist in the development of planning documents and targeted reports, dashboards, and data visualization models that surface key information about citywide health emergency field operations data. Assist with the conduct of trainings, including facilitating training modules and reviewing training curriculum. Participate in the development and implementation of exercises and drills. Serve as a key member of the NYC DOHMH Incident Command System (ICS) during emergency responses. Qualifications: A baccalaureate degree from an accredited college or university with a specialization in an appropriate field of physical, biological, environmental or social science or in public health. Previous experience working in one or more of the following areas: data analytics, emergency preparedness planning/management, public health, geographic information systems (GIS), or related specialized area for at least one year. Capacity and willingness to learn Microsoft SQL Server Management Studio, Esri/ArcGIS Online software, and data visualization software. The ideal candidate for this position must be a pro-active and self-motivated individual with the ability to work in teams and in a highly dynamic environment with multiple stakeholders and timelines. Salary - $72,000 -$72,000 Additional Desired Qualities: Experience with data collection, analysis and visualization. Experience with writing and maintaining technical documentation, including procedure guides and data dictionaries. Excellent communication (verbal & written) and interpersonal skills. Strong analytical skills and ability to manage and report complex information. Experience working with the public health sector and coordinating projects involving multiple stakeholders. Ability to prioritize and work in fast-paced environment with hard deadlines. Additional Information: This is a temporary grant-funded position ending in November 2027. This individual must reside in the tri-state area (NY, NJ, CT) by their confirmed start date. Preference may be given to individuals residing in New York City (5 boroughs) or surrounding New York State counties. PHS is proud to be an equal opportunity employer and encourages applications from women, people of color, persons with disabilities, LGBTQIA+ individuals, and veterans. Monday-Friday Hybrid 35 Hours Per Week

<h3>Job Description</h3><div>Job Description<div><div><div><div></div></div></div>Company overview: With an annual budget of $2.3 billion and more than 7,000 employees throughout the five boroughs, the New York City Department of Health and Mental Hygiene (NYC DOHMH) is one of the largest public health agencies in the world, serving 8 million New Yorkers from diverse ethnic and cultural backgrounds. We're tackling a broad range of public health issues with innovative policies and programs and getting exceptional results, but our work is never finished. The breadth of our innovative programs provides the widest range of choices for every member of our team. With grant funds from the Centers for Disease Control and Prevention (CDC), DOHMH is undertaking a new initiative that will meet critical infrastructure needs and make possible strategic investments that will have lasting effects on public health. Investments and improvements through this initiative will help modernize DOHMH’s foundational capabilities and data infrastructure, enabling it to partner in complex health and health care environments and, in turn, support better public health outcomes, including COVID-19. This initiative supports larger efforts to rebalance investments in public health and more equitably serve communities and populations. The selected candidate will be an employee of Public Health Solutions, a nonprofit organization which is the fiscal and administrative manager of the grant but will work be supervised by DOHMH. This is a grant-funded position ending in November 2027.Program description:The New York City Department of Health and Mental Hygiene (DOHMH)’s Office of Emergency Preparedness and Response (OEPR) was created to promote DOHMH’s and NYC’s ability to prevent, prepare for, respond to, and recover from health emergencies. OEPR is responsible for coordinating agency-wide emergency preparedness planning, exercises and training, evaluation of incident response and exercise performance as well as coordinating with community stakeholders and city, state, and federal partners on public health emergency planning and response.Summary of position:DOHMH has an opening for a Public Health Data Analyst. Reporting to the Director of Data & Analytics, this position is in the Bureau of Emergency Field Response (BEFO). The selected candidate will assist with ongoing analyses and the development of the technological infrastructure for future public health emergencies using lessons learned in the COVID-19 response.Duties:Key responsibilities include:· Assist with and conducts research and analysis using a variety of quantitative methods across the Bureau including working with the Planning and Training, Operations, Logistics, and Exercises, and Medical Reserve Corps-Emergency Staffing Units.· Collaborate with internal and external stakeholders to develop, document and maintain policies, procedures, systems, and applications to support citywide health emergency field operations· Assist teams from across the Health Department and City on ways to best leverage, utilize, and even establish standards on the use and application of data, data formats, and data analytical tools across projects.· Manage large datasets within SQL Server Database across multiple servers.· Assist in the development of planning documents and targeted reports, dashboards, and data visualization models that surface key information about citywide health emergency field operations data.· Assist with the conduct of trainings, including facilitating training modules and reviewing training curriculum.· Participate in the development and implementation of exercises and drills.· Serve as a key member of the NYC DOHMH Incident Command System (ICS) during emergency responses. Qualifications:· A baccalaureate degree from an accredited college or university with a specialization in an appropriate field of physical, biological, environmental or social science or in public health.· Previous experience working in one or more of the following areas: data analytics, emergency preparedness planning/management, public health, geographic information systems (GIS), or related specialized area for at least one year.· Capacity and willingness to learn Microsoft SQL Server Management Studio, Esri/ArcGIS Online software, and data visualization software.· The ideal candidate for this position must be a pro-active and self-motivated individual with the ability to work in teams and in a highly dynamic environment with multiple stakeholders and timelines.· Salary - $72,000 -$72,000 Additional Desired Qualities:· Experience with data collection, analysis and visualization.· Experience with writing and maintaining technical documentation, including procedure guides and data dictionaries.· Excellent communication (verbal & written) and interpersonal skills.· Strong analytical skills and ability to manage and report complex information.· Experience working with the public health sector and coordinating projects involving multiple stakeholders.· Ability to prioritize and work in fast-paced environment with hard deadlines. Additional Information:· This is a temporary grant-funded position ending in November 2027.· This individual must reside in the tri-state area (NY, NJ, CT) by their confirmed start date.· Preference may be given to individuals residing in New York City (5 boroughs) or surrounding New York State counties. PHS is proud to be an equal opportunity employer and encourages applications from women, people of color, persons with disabilities, lesbian, gay, bisexual and transgender individuals, and veterans Monday-Friday Hybrid 35 Hours Per Week</div></div>

Public health solutions Interview Questions

Public health solutions Interview Guides

Public health solutions Interview Questions

Public health solutions Salaries by Position

Public health solutions Opening Jobs