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:
- Bachelor’s degree required along with 5+ years of relevant experience. Relevant experience includes systems analysis and design and closely related functions (e.g. analytics, information system quality assurance, documentation, programming, etc.)
- 5 plus years of programming experience developing on a relational database platform.
- 5 plus years of experience programming Standard Query Language (SQL), including development of stored procedures.
- 5 plus 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 plus.
- Knowledge of Agiloft CLM is a plus.
- Must be highly organized, detail-oriented, able to work independently, flexible, and attention to details.
- Team player who relates well to constituents in many roles.
- Salary: $100000.00-$100000.00
Benefits:
- Hybrid Work Schedule.
- Generous Paid Time Off and Holidays.
- An attractive and comprehensive benefits package including Medical, Dental and Vision.
- Flexible Spending Accounts and Commuter Benefits.
- Company Paid Life Insurance and Disability Coverage.
- 403 (b) + employer matching and discretionary company contributions.
- College Savings Plan.
- Ongoing training and continuous opportunities for professional growth and development.
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