Senior Analytics Manager

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.

 

The Office of School Health (OSH) is a joint Program of the Department of Education and the Department of Health and Mental Hygiene responsible for promoting the health of the 1.3 million school children enrolled in approximately 1,800 public and non-public schools in the New York City. The OSH Adolescent Health Program manages, among other programs, in-school reproductive health programs at the high school level. These programs include 1) School-Based Health Centers, which offer comprehensive primary care services that include mental health and reproductive health as critical components of adolescent health care services; 2) Connecting Adolescents to Comprehensive Healthcare (CATCH) Program which offers in-school pregnancy tests, emergency contraception, hormonal contraception and referrals for reproductive health care by OSH staff in the school medical rooms; 3) Chancellor’s Initiative which is a $80 million project to develop and build over 50 SBHC’s over the course of 3 years; and 4) School Based Mental Health Roadmap training initiative that offers over 60 workshops/trainings per year to over 300 mental health professionals working in NYC public schools.

 

The OSH is the recipient of several grants to develop, implement and evaluate Adolescent Pregnancy Prevention initiatives in the schools. These grant-funded initiatives include offering expanded direct reproductive health services in School-Based Health Centers; and providing technical assistance, training, and monitoring to over 70 high school SBHC’s participating in the Reproductive Health project. The Senior Analytics Manager will work under the direction of the Director of Adolescent Health or her designee at the NYC Department of Health and Mental Hygiene’s Office of School Health. They will work closely with all programmatic staff including the Director of IT for OSH.

 

The Senior Analytics Manager will be responsible for maintaining the unit’s SQL Server databases, establishing, and maintaining additional feeds and connections to new data sources, and developing reporting and analytics to support decision-making, analysis and interpretation of programmatic data. These databases support externally facing applications that support onsite data collection at school-based health clinics, CATCH sites, and other New York City school-based health facilities. This work will include, but will not be limited to, developing dynamic and static reporting data using SSRS and other tools; developing stored procedures and scheduling jobs for routine data updates using SSIS; maintaining and enhancing the structure and function of the database, maintaining database schema and integrity, creating data views; integrating external and public data sources as appropriate; and maintaining geocoding and geo-linkage on any site-specific data. 

 

·        Maintaining and implementing routine update procedures and processes of SQL Server databases.

·        Creating and maintaining SQL Stored procedures and SSIS packages as required.

·        Trouble shooting data issues, and data inconsistencies on all aspects of the program’s data.

·        Manage code base supporting database, including fixing bugs, repairing existing code as necessary and developing new code.

·        Database maintenance and enhancement, as necessary.

·        Identifying infrastructure needs and implementing enhancement.

·        Maintaining documentation for the SQL Server database, including any dependencies, and documentation of procedures.

 

·        Constructing new or maintaining current reports (including dashboards) using SSRS, and/or PowerBI.

·        Perform both regular and ad hoc analyses around key program questions that pertain to the efficacy of school-based health services.

·        Participate in planning meetings and development meetings as required with internal business members, and furthermore will interface with clinic users based on program’s discretion on an as needed basis.

·        Interfacing with development team members for programming instruction, best practices, data structure evaluation and code review.

·        Developing code for new reporting projects as needed.

·        Providing analytic support for a wide range of grant-funded initiatives.

 

·        Bachelor’s degree or Master’s degree in quantitative field (computer science, data science, statistics, mathematics or related field).

·        3+ years experience in Business Intelligence with a focus on writing and executing complex SQL queries and using BI visualization tools to inform stakeholders.

·        Advanced proficiency and extensive demonstrated professional experience in MS SQL Server, SSRS, SSIS required.

·        Demonstrated advanced programming experience in SQL and proficiency in Python and MS Access required (VBA). Experience with R helpful.

·        Experience working with health system data strongly preferred.

·        Previous experience in creating and documenting design specifications preferred.

FPHNYC offers a comprehensive benefits package. The salary range for this position is $95 - $105,000 commensurate with experience and education.

 

There is potential for this position to transition to DOHMH and therefore candidates must meet DOHMH eligibility requirements including NYC residency.

 

To apply, send Resume, with Cover Letter, including salary requested and how your experience relates to this position here, indicating “Senior Analytics Manager_your name” in subject line.      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.