The Fund for Public Health in New York City (FPHNYC) is a 501(c)3 non-profit organization that is dedicated to the advancement of the health and well-being of all New Yorkers. To this end, in partnership with the New York City Department of Health and Mental Hygiene (DOHMH), FPHNYC incubates innovative public health initiatives implemented by DOHMH to advance community health throughout the city. It facilitates partnerships, often new and unconventional, between government and the private sector to develop, test, and launch new initiatives. These collaborations speed the execution of demonstration projects, effect expansion of successful pilot programs, and support rapid implementation to meet the public health needs of individuals, families, and communities across New York City.
PROGRAM OVERVIEW: Integrated Data Team
Program Mission, Scope and Tasks
The Integrated Data Team (IDT) applies analytical skills to leadership, policy, program management and public health communication challenges. The mission of the Integrated Data Team (IDT) is to identify, synthesize and integrate public health data to inform emergency response and promote health equity. Using data from multiple stakeholders, we coordinate with data owners, community organizations and City leadership to solve complex problems, build consensus and improve pandemic response. We make sure decision makers, community organizations and the public have access to meaningful, timely data.
In a typical 7 day week, the IDT team will:
- Coordinate data sharing with other agencies and external partners
- Respond promptly to City Hall, Commissioner of Health and other leadership under the direction of the Incident Commander to inform data driven decision making
- Communicate data and public health information in accessible ways for diverse audiences
- Lead strategic integrated data initiatives by cultivating data sources and leveraging data visualization, GIS, statistics and epidemiology skills from IDT and other agency analysts
- Curate scientific literature with the Principal Scientific Advisor (PSA) and develop background briefings for the Incident Commander
POSITION OVERVIEW
As part of the larger Integrated Data Team structure, we are seeking a SQL Programmer to create and maintain a COVID-19 visualization database that will fuel reporting for the Viz Team. The SQL Programmer will design database schema and tables; create views which can process data quickly and efficiently; set up automated extract refreshes from SQL to Tableau Server; create code for partner programs to push data and results to the SQL server from SAS, R or similar analysis software; ingest CSV and other finicky file formats through both manual and SFTP/scheduled job/ETL processes; and analyze big data to create clean measures which can be used to direct pandemic action in New York City. Supported by the Tableau Manager, the SQL Programmer will also liaise with IT and flag issues for swift and collaborative resolution. The successful candidate will have experience with health or healthcare data, enjoy working in a fast paced and team-based environment, and bring data curiosity with them to work.
RESPONSIBILITIES
- Work with data owners to ingest data, design scheme and measures, and create measure definition tables which are up-to-date and complete
- Adjust ETL processes to incorporate quick changes to underlying pandemic data
- Identify breaks or quality issues in ETL processes and work to remediate them with data owners
- Design database schema and tables as needed
- Create views which can process data and join different data tables to create a uniform set of variable names and formats for analysts and visualizations/dashboards
- Set up automated extract refreshes from SQL to Tableau Server
- Write SQL or similar code for partner programs to push data and results to the SQL server from SAS, R or similar analysis software
- Ingest CSV and other finicky file formats through both manual and scheduled jobs
- If interested, analyze big data to create clean measures which can be used to direct pandemic action in New York City
Please note: analysts on the Viz team will work to cover weekend or evening hours as needed, to contribute to IDT’s mission of providing decision makers with the pandemic insights to drive impact. We anticipate an average 43 hour workweek.
