Database Programmer

Job Description

Job Description

Company Overview :

Health disparities among New Yorkers are large, persistent, and increasing. Public Health Solutions (PHS) exists to change that trajectory and support New Yorkers and their families in achieving optimal health and building pathways to reach their potential. As the largest public health nonprofit serving New York City, we improve health outcomes and help communities thrive by providing services directly to low-income 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.

Program Description :

Contracting and Management Services (CAMS) division facilitates the important work that diverse human service organizations are doing for communities in need. We provide industry-leading contracting, fiscal management, and capacity building services. The full range of contracting and management services CAMS provides enables organizations that are crucial to the public health of New Yorkers to have the funding and administrative expertise needed to seamlessly deliver upon their promises.

Summary of Position :

CAMS division seeks a Database programmer who has experience in database development with application support responsibilities. They would be developing and maintaining reports using MS SQL Server Reporting Services (SSRS) and SSIS packages, as well as writing and managing T-SQL stored procedures, functions, and database objects. The role requires the ability to query databases to identify and troubleshoot client-level data issues, and to communicate findings to contract management staff and information system developers. The Database programmer will support Agiloft Contract Management System and other PHS systems as needed.

Specifically, the Database Programmer will :

• Develops and maintains reports using MS SQL Server Reporting Services.
• Develops and maintains SSIS packages.
• Develops and maintains SQL stored procedures, tables, etc. using T-SQL.
• Query databases to identify problems with client-level data submitted for payment.
• Investigates data discrepancies and reports the results to contract management staff and information system developers.
• Develops and maintains Object-oriented web application using ASP.Net, C#, HTML and JavaScript.
• Supports Agiloft CLM.

Qualification and Requirements :

Benefits :

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.

Monday - Friday 9 : 00am to 5 : 00pm

35 Hours per week