Public Health Solutions
Overview
Public Health Solutions (PHS) is the largest public health nonprofit serving New York City. We aim to reduce health disparities by providing services to low-income families, supporting community-based organizations, and bridging healthcare and community services. We focus on food and nutrition, health insurance, maternal and child health, sexual and reproductive health, tobacco control, and HIV/AIDS. Contracting and Management Services (CAMS) division facilitates contracting, fiscal management, and capacity building for diverse human service organizations to help them deliver on their commitments to the public health of New Yorkers. Summary Of Position
The CAMS division seeks a Database Programmer with experience in database development and application support. The role involves developing and maintaining reports using MS SQL Server Reporting Services (SSRS) and SSIS packages, and writing/managing T-SQL stored procedures, functions, and database objects. The position requires querying databases to identify and troubleshoot client-level data issues and communicating findings to contract management staff and information system developers. The Database Programmer will support the Agiloft Contract Management System and other PHS systems as needed. Responsibilities
Develop and maintain reports using MS SQL Server Reporting Services (SSRS). Develop and maintain SSIS packages. Develop and maintain SQL stored procedures, tables, etc. using T-SQL. Query databases to identify problems with client-level data submitted for payment. Investigate data discrepancies and report results to contract management staff and information system developers. Develop and maintain an object-oriented web application using ASP.Net, C#, HTML and JavaScript. Support Agiloft CLM and other PHS systems as needed. Qualifications And Requirements
Bachelor’s degree required with 5+ years of relevant experience (systems analysis and design, analytics, information system quality assurance, documentation, programming, etc.). 5+ years of programming experience on a relational database platform. 5+ years of experience programming SQL, including development of stored procedures. 5+ years of experience programming Microsoft SQL Server Integration Services and Reporting Services. Knowledge of Web Services is a plus. Knowledge of ASP.Net and C# is a plus. Knowledge of Agiloft CLM is a plus. Highly organized, detail-oriented, able to work independently, flexible, and a team player who can relate to constituents in many roles. Salary: $100000.00-$100000.00 Benefits
Hybrid Work Schedule. Generous Paid Time Off and Holidays. Medical, Dental and Vision coverage with a comprehensive benefits package. Flexible Spending Accounts and Commuter Benefits. Company Paid Life Insurance and Disability Coverage. 403(b) with employer matching and discretionary company contributions. College Savings Plan. Ongoing training and opportunities for professional growth and development. PHS is an equal opportunity employer and encourages applications from women, people of color, persons with disabilities, LGBTQIA+ individuals, and veterans. Hours: Monday - Friday 9:00am to 5:00pm; 35 hours per week.
#J-18808-Ljbffr
Public Health Solutions (PHS) is the largest public health nonprofit serving New York City. We aim to reduce health disparities by providing services to low-income families, supporting community-based organizations, and bridging healthcare and community services. We focus on food and nutrition, health insurance, maternal and child health, sexual and reproductive health, tobacco control, and HIV/AIDS. Contracting and Management Services (CAMS) division facilitates contracting, fiscal management, and capacity building for diverse human service organizations to help them deliver on their commitments to the public health of New Yorkers. Summary Of Position
The CAMS division seeks a Database Programmer with experience in database development and application support. The role involves developing and maintaining reports using MS SQL Server Reporting Services (SSRS) and SSIS packages, and writing/managing T-SQL stored procedures, functions, and database objects. The position requires querying databases to identify and troubleshoot client-level data issues and communicating findings to contract management staff and information system developers. The Database Programmer will support the Agiloft Contract Management System and other PHS systems as needed. Responsibilities
Develop and maintain reports using MS SQL Server Reporting Services (SSRS). Develop and maintain SSIS packages. Develop and maintain SQL stored procedures, tables, etc. using T-SQL. Query databases to identify problems with client-level data submitted for payment. Investigate data discrepancies and report results to contract management staff and information system developers. Develop and maintain an object-oriented web application using ASP.Net, C#, HTML and JavaScript. Support Agiloft CLM and other PHS systems as needed. Qualifications And Requirements
Bachelor’s degree required with 5+ years of relevant experience (systems analysis and design, analytics, information system quality assurance, documentation, programming, etc.). 5+ years of programming experience on a relational database platform. 5+ years of experience programming SQL, including development of stored procedures. 5+ years of experience programming Microsoft SQL Server Integration Services and Reporting Services. Knowledge of Web Services is a plus. Knowledge of ASP.Net and C# is a plus. Knowledge of Agiloft CLM is a plus. Highly organized, detail-oriented, able to work independently, flexible, and a team player who can relate to constituents in many roles. Salary: $100000.00-$100000.00 Benefits
Hybrid Work Schedule. Generous Paid Time Off and Holidays. Medical, Dental and Vision coverage with a comprehensive benefits package. Flexible Spending Accounts and Commuter Benefits. Company Paid Life Insurance and Disability Coverage. 403(b) with employer matching and discretionary company contributions. College Savings Plan. Ongoing training and opportunities for professional growth and development. PHS is an equal opportunity employer and encourages applications from women, people of color, persons with disabilities, LGBTQIA+ individuals, and veterans. Hours: Monday - Friday 9:00am to 5:00pm; 35 hours per week.
#J-18808-Ljbffr