Tableau Team SQL Programmer -Temp
Job Details
Undisclosed
LIC - Central DOHMH - Long Island City, NY
Undisclosed
Undisclosed
Undisclosed
Undisclosed
Undisclosed
Undisclosed
Integrated Data Team SQL Programmer Temp

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.

Qualifications
  • 5+ years of experience with SQL programming 
  • 2+ years of experience in database management, view creation, automation and/or ETL
  • Solid communication skills to communicate technical concepts to non-technical staff
  • Preferred background in healthcare or public health environment
  • Experience producing analytic deliverables in high-pressure contexts 
  • Masters’ degree preferred, but 3 years of related work experience may be substituted

 

SALARY AND BENEFITS

The salary for this position is $46 - $84 hourly and is commensurate with experience.

 

TO APPLY

To apply, send Resume, with Cover Letter, including how your experience relates to this position here. We ask that you do not contact our staff directly and no phone inquiries please. Applicants who best match the position needs will be contacted.

 

The Fund for Public Health in New York City is an Equal Opportunity Employer and encourages a diverse pool of candidates to apply.

Apply