Prepare for and practice interview questions from Public health solutions.

Public health solutions Interview Questions

Public health solutions Interview Guides

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

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 you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Public health solutions Salaries by Position

<h3>Job Description</h3><div>Job Description<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.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 the work will be supervised by DOHMH. This is a grant-funded position scheduled to end in November 2027. Program and Job DescriptionThis position is within the Office of Strategic Operations and Performance Management (SOPM) in the Office of the Chief Operating Officer (COO). This office supports the overarching strategies of DOHMH, to foster organizational alignment with those strategies, and to supplement divisional capacity as needed. This office also coordinates strategic data projects related to agency operations and analyses for priority Agency initiatives. The Strategic Data Initiatives (SDI) Unit — made up of 7 staff [1 Senior Director, 1 Director, 2 Data Scientists, 1 Salesforce Developer & 2 Senior Salesforce Business Analysts] — is focused on leveraging technology and data products to meet the Agency’s goals more efficiently.Under the direction of the Director of Informatics, the Senior Business Analyst (Salesforce) will support the COO’s Salesforce org which houses several agency priority applications. The system’s primary application is the agency’s partner management system (Partners Connect) which stores the Agency’s partner facing outreach and engagement data. The other application(s) involve performance management systems to facilitate real-time and ad-hoc reporting for the agency’s operational indicators.This role will coordinate with agency stakeholders to better understand public health programs and map those processes to the current Salesforce environment. Additionally, the Senior Business Analyst (Salesforce) will serve as liaison between internal programmatic staff to build out new use cases and provide technical assistance as needed. These systems often involve rapid development, deployment, and support for new high priority initiatives. This person will need to collaborate with developers, analysts, and users to maintain the system and build additional modules as needed. At least 4 years of experience as a Salesforce administrator or analyst is required.Duties will include but not limited to: <ul><li>Coordinate across the Agency to help support the implementation of Salesforce for external engagement or performance management systems.</li><li>Work with program stakeholders to develop specific and measurable programmatic data indicators for their new use-cases.</li><li>Configure Salesforce in the sandbox including but not limited to flows, objects, fields, layouts, and community sites. </li><li>Serve as one of the Salesforce administrators. </li><li>Conduct research to identify and recommend improvements to streamline processes and enhance system functionality.</li><li>Provide technical assistance to business units including developing reports, dashboards, and appropriately identify requirements for new technology builds.</li><li>Quickly learn the current Salesforce environment and work with new business units to adapt Salesforce usage in their current workflows.</li><li>Lead discussions and meetings with stakeholders providing guidance, sharing best practices, and influencing process decision-making when necessary.</li><li>Collaborate with cross-functional teams to integrate Salesforce with other program processes and/or systems, ensuring seamless data flow and process automation.</li><li>Contribute to the processing, cleaning, and preparing of data for analysis and reporting.</li><li>Develop data management procedures and protocol (e.g., data dictionaries, business rules) for monitor data quality, identify issues, and work with program staff to resolve.</li><li>As needed, create and present reports for internal and external audiences. </li><li>Conduct a systems analysis for new programs and map the results of those analysis to the existing infrastructure.</li><li>Work with public health experts, documenting workflows and translating those workflows in training materials and/or system documentation.</li><li>Communicate with complex business workflows and requirements into a project plan.</li><li>Communicates complex technical and data information to both technical and non-technical stakeholders. </li></ul>Preferred Skills / Qualifications <ul><li>At least 4 years of experience as a Salesforce administrator or analyst is required.</li><li>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.</li><li>Excellent communication (verbal & written) and interpersonal skills.</li><li>Strong analytical skills and ability to manage and report complex information.</li><li>Experience with data collection, analysis and interpretation.</li><li>Desire to grow professionally, develop new skills and willingness to work outside of comfort zone.</li><li>Experience working with the public health sector and coordinating projects involving multiple stakeholders.</li><li>Ability to prioritize and work in fast-paced environment with hard deadlines.</li><li>Fluency in Microsoft Word, Excel, Outlook, and PowerPoint.</li><li>Ability to understand the concepts of institutional and structural racism and bias and their impact on underserved and underrepresented communities, along with a demonstrated commitment to supporting communities who have experienced systemic oppression and bias (e.g. people of color, LGBTQ+ people, immigrants, justice involved persons, etc.).</li><li>Have a demonstrated commitment to supporting communities who have experienced systemic oppression and bias (e.g. people of color, LGBTQ+ people, immigrants, justice involved persons, etc.).</li><li>Salary: 103,000 - $103,000</li></ul>Benefits:<ul><li>Hybrid Work Schedule.</li><li>Generous Paid Time Off and Holidays.</li><li>An attractive and comprehensive benefits package including Medical, Dental and Vision.</li><li>Flexible Spending Accounts and Commuter Benefits.</li><li>Company Paid Life Insurance and Disability Coverage.</li><li>403 (b) + employer matching and discretionary company contributions.</li><li>College Savings Plan.</li><li>Ongoing trainings and continuous opportunities for professional growth and development.</li></ul>Additional Information: <ul><li>This is a temporary grant-funded position ending in November 2027.</li><li>This individual must reside in the tri-state area (NY, NJ, CT) by their confirmed start date. </li><li>Preference may be given to individuals residing in New York City (5 boroughs) or surrounding New York State counties. </li><li>This individual will be expected to work non-business hours during emergencies.</li></ul>PHS is proud to be an equal opportunity employer and encourages applications from women, people of color, persons with disabilities, LGBTQIA+ individuals, and veterans. </div></div> Monday-Friday Hybrid 35 Hours per week</div></div>

<h3>Job Description</h3><div>Job Description<div><div>Company Overview:Public Health Solutions (PHS) is a 501(c)3 non-profit community-based organization (CBO) that has existed for 70 years to improve health equity and address health-related social needs (HRSN) for historically underserved marginalized communities. As the largest public health nonprofit serving New York City, we improve health outcomes and help communities thrive by providing services directly to vulnerable families, supporting community-based organizations through our long-standing public-private partnerships, and bridging the gap between healthcare and community services. We focus on a wide range of public health issues including food and nutrition, health insurance, maternal and child health, sexual and reproductive health, tobacco control, and HIV/AIDS. Learn more about our work at healthsolutions.org. PHS administers WholeYouNYC (WYNYC), a coordinated community resource network that builds trustworthy and reliable pathways between healthcare providers, health plans and CBOs providing critical resources in the community that address the social drivers of health. WYNYC brings together over 100 organizations offering various programs – such as food, housing, employment, health insurance, and sexual health services – across all five boroughs. These services and programs make it possible for New Yorkers to live their healthiest lives and ultimately reduce health disparities and advance health equity. To date, our network has already impacted thousands of lives through community partnerships and referrals, generating millions in estimated healthcare savings. New York State (NYS) recently announced the availability of $500M statewide to support Social Care Network (SCN) lead entities responsible for coordinating social care delivery in various regions across the state. Public Health Solutions (PHS) and our WYNYC network were awarded the role of regional SCN for Brooklyn, Manhattan, and Queens. This is a grant-funded position ending March 31, 2027. Position Summary:PHS seeks to be a data-driven organization, able to inform our activities and priorities based on what we are learning about the communities we serve and the impact of our services on those communities. The Data Analysts’ role will be primarily to support reporting and data management for the Social Care Networks. We seek an experienced Data Analyst, who will report to the Senior Manager, Data Analyst within the Quality and Evaluation team.The ideal candidate will: <ul><li>Be a compelling data storyteller.</li><li>Be comfortable presenting to and engaging with various stakeholders (i.e., both written and verbal).</li><li>Be adept at helping others, at varying levels of data literacy, to optimize data tracking methods and understand data to support decision-making and fulfill program needs and objectives.</li><li>Have experience building reports and/or dashboards in Microsoft Excel and Power BI.</li><li>Be familiar with social care coordination and/or working with Managed Care Organization (MCO) datasets.</li><li>Have experience with survey design and various data collection methods. </li><li>Be comfortable analyzing and interpreting results from datasets with varying structures and levels of cleanliness in Microsoft Excel, R, STATA, or Python.</li><li>Be comfortable supporting continuous quality improvement projects through planning, implementation, and monitoring.</li></ul>Specifically, the Data Analyst will:<ul><li>Work with teams to ensure quality of metrics and alignment with program objectives, New York State requirements, and organizational needs and objectives.</li><li>Use and visualize data to proactively identify program and/or data quality issues, develop programmatic solutions, and implement those solutions.</li><li>Maintain (i.e., export, clean, analyze and update) monitoring reports for PHS’ Social Care Networks </li><li>Generate quarterly status reports using key performance indicators to guide Social Care Network leadership in making timely, actionable decisions.</li><li>Support teams with data management, data cleaning, data analysis, and data visualization in order to carry out day-to-day monitoring and quality improvement.</li><li>Support training and capacity building efforts both internally and to Social Care Network partners</li><li>Support evaluation efforts particularly with developing data analysis plans, conducting analysis, providing interpretation and contextualizing analysis with community-level data and/or literature</li><li>Support development, administration, and data entry from surveys, as needed</li><li>Participate in team and stakeholder meetings, as needed.</li><li>Other duties as assigned by Senior Manager, Data Analysis and Senior Director of Quality and Evaluation, and in support of the Social Care Network Teams.</li></ul> Qualifications and Experience:<ul><li>Bachelor’s degree; 2-5 years’ experience or equivalent.</li><li>Experience visualizing and communicating data so that it is easily understood by a variety of stakeholders.</li><li>Experience telling stories with data, in written and/or oral communication.</li><li>Experience using data to identify issues and develop recommendations.</li><li>Experience effectively collaborating with people of different backgrounds.</li><li>Salary; $70,000-$70,000.</li></ul>Desired Skills:<ul><li>Fluency with Microsoft Excel (specifically, data models, LOOKUP functions and PivotTables)</li><li>Fluency conducting data analysis using Microsoft Excel, R, STATA, or Python</li><li>Familiarity with Power BI and ArcGIS</li></ul> Benefits: • Hybrid Work Schedule. • Generous Paid Time Off and Holidays. • An attractive and comprehensive benefits package including Medical, Dental and Vision. • Flexible Spending Accounts and Commuter Benefits. • Company Paid Life Insurance and Disability Coverage. • 403(b) + employer matching and discretionary company contributions. • College Savings Plan. • Ongoing trainings and continuous opportunities for professional growth and development. At PHS, we place immense value on diversity within our teams, understanding that varied backgrounds and experiences significantly enhance our community and propel us toward our goals. If you find you don’t have experience in all the areas listed above, we still encourage you to apply and share your background and experiences in your application. We are eager to discover how your unique perspective can bring positive transformations to our team and help advance our mission of creating healthier, more equitable communities. We look forward to learning more about you! PHS is proud to be an equal opportunity employer and encourages applications from women, people of color, persons with disabilities, LGBTQIA+ individuals, and veterans.</div> Monday – Friday 9:00am to 5:00pm 35 Hours per week</div></div>

<h3>Job Description</h3><div>Job Description<div><div><div></div></div><div><div></div></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, LGBTQIA+ individuals, and veterans. Monday-Friday Hybrid 35 Hours Per Week</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 Data Modernization Initiative that will meet critical infrastructure needs and make 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.The recently created Center for Population Health Data Science (CPHDS) is leading the agency's data modernization. We are building capacity within our team to design and implement a central, interoperable data infrastructure in collaboration with the Division of Information Technology to connect data across our programs and streamline how data is shared with the agency. This infrastructure will power an integrated public health surveillance platform and drive our program effectiveness through integration of real-time data insights. The innovation focused Bureau of Epidemiology Services (BES) supports the agency in its systematic data collection and monitoring, rigorous analysis, and effective data communication. BES seeks to support the agency's provisions of accurate and timely public health data and optimize data use to inform public health decisions and promote equitable health outcomes.Job description:DOHMH is seeking a Product Manager to spearhead the development of data products within our Integrated Public Health Data Infrastructure portfolio. The Product Manager will determine and oversee delivery of the strategy and roadmap for their products to achieve equitable public health outcomes including the goals set by NYC DOHMH's Healthy NYC initiative. Their responsibilities include coordinating with colleagues in the Division of Information Technology, as well as stakeholders across key public health programs to set priorities, manage new development and operations, and provide direction and oversight to product teams and other technical support teams supporting the Data Modernization Initiative.Duties:* Develop a deep understanding of business goals and processes to inform data product priorities and improvement recommendations.* Develop strong relationships and regularly communicate with program stakeholders to shape the product strategy and surface and prioritize needs.* Monitor the public health ecosystem and emerging technology trends to inform product strategy and proactively propose new solutions.* Establish product roadmaps and release plans that satisfy requirements and achieve agency goals and public health outcomes.* Contribute to translating business requirements into actionable product and technical requirements.* Continuously monitor and evaluate product performance and proactively champion product improvements.* Guide the cross-functional development team (including colleagues from IT, data engineering, data science) to scope, plan and deliver work, applying established delivery methodologies (e.g., agile methods) and best practices (e.g., reusability).* Proactively identify and resolve blockers to achieve business objectives for the product, including technical and resourcing challenges.* Ensure alignment and adherence to City/Agency, financial and IT standards (e.g., architecture, compliance, security).* Increase adoption and consumption of product capabilities.* Manage investment decision making and finances for the products, taking a return-on-investment approach to increasing the value while minimizing product costs.* Serve as product manager for multiple, related products.* Define, track, and communicate relevant KPIs for the product to measure performance and contribution to business goals and strategy.Qualifications:REQUIRED* 3+ years of product management or related experience.* Master's degree in public health, data science, health informatics, computer science, or a related field.* Understanding of public health and population health data, including concepts like HL7, interoperability and others.* Understanding of data systems, data governance, data analytics* Ability to lead cross-functional teams and work collaboratively across diverse and matrixed stakeholders.* Ability to surface, prioritize, and balance multiple stakeholder priorities.* Strong project management skills to manage multiple projects and deadlines simultaneously.* Demonstrated success in defining and building data and technology products.* Excellent problem solving and analytical skills, including experience analyzing and leveraging data to inform decision making.* Demonstrated ability to communicate complex technical information effectively to various stakeholders verbally and in writing.* Ability to adapt and respond to changes due to emerging public health needs and priorities.* Salary - $120,000 - $120,000ADDITIONAL DESIRED QUALITIES* Background in public health is preferred* Preferred technological proficiency: R, Python, SQL, HTML, JavaScript, DataWrapper, GitHub, SAS, bash* Preferred experience: Interpreting, analyzing, and drawing conclusions from epidemiological and other public health or publicly sourced dataWhy Join Us:* Directly contribute to advancing public health in New York City and setting best practices globally through innovative data products.* Lead the transformative integration of modern data practices with epidemiology and health informatics to define the next era of timely and effective public health strategies.* Be part of a mission-focused organization that is one of the largest public health agencies in the world, serving 8.5 million New Yorkers from diverse ethnic and cultural backgrounds and dedicated to improving their health and wellbeing.* Enjoy a supportive work environment that values diversity, innovation, learning, and professional growth.Additional Information:* This is a temporary grant-funded position ending November 2027, with the possibility of continuation as a DOHMH employee.* Preference may be given to individuals residing in New York City (5 boroughs) or surrounding New York State counties.* This individual will be required to reside in the Tri-State Area (New York, New Jersey, and/or Connecticut)* This individual will be expected to work non-business hours during emergencies.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-Fridaypossibility of hybrid work35 Hours Per week

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