HBITS-08-15016-Software Developer-Expert

About the role

The position supports the Special Supplemental Nutrition Program for Women, Infants, and Children (WIC) within the NYWIC (New York Women, Infants, and Children) system. The NYWIC MIS‑EBT project provides a .NET/Oracle‑based platform for efficient program operations and ongoing enhancements. The DataMart team designs, develops, and maintains the enterprise data warehouse and reporting layer for the NYWIC application, delivering accurate, reliable, and timely reporting for business users, program administrators, and regulatory stakeholders.

Responsibilities

• Develop, test, and execute Oracle SQL queries against the Production NYWIC database schema for program validation and data analysis.
• Develop and maintain a library of reusable SQL queries that can be executed on a recurring basis with different parameters.
• Assist Department of Health (DOH) program staff in understanding NYWIC data structures within the NYWIC modules to develop new report requirements.
• Assist DOH program staff in creating ad‑hoc queries within the NYWIC Datamart OBIEE system, following user guidelines and guidance from the NYWIC Datamart team.
• Collaborate with NYWIC Datamart team members, program staff, and the NYWIC application vendor to develop a knowledge base of system data mappings between the NYWIC application and the Datamart.
• Participate in the review and documentation of regression test scripts for user acceptance testing.
• Provide general support for user acceptance testing efforts.
• Work closely with ITS and program managers to ensure adherence to standard policies and procedures.

Mandatory Qualifications

• Software Developer role encompassing research, design, programming, testing, and implementation of computer software.
• Expert‑level experience (84+ months) with the ability to provide guidance to large teams and recognized as a top professional in the field.

Requested Qualifications

• 84 months of experience creating SQL queries and stored procedures using Oracle PL/SQL.
• 84 months of experience meeting business staff to elicit business requirements.
• 84 months of experience working with business staff or end users to analyze or troubleshoot Oracle reports.
• 84 months of experience creating software documentation, including functional and technical specifications.
• 48 months of experience analyzing and optimizing Oracle SQL queries to improve database performance.
• 48 months of experience preparing or facilitating the creation of testing scenarios and test scripts.
• 36 months of experience creating user documentation such as user guides or training presentations.
• 36 months of experience using OBIEE (Oracle Business Intelligence Enterprise Edition), including end‑user experience.

Education

Bachelor’s degree in an Information Technology‑related field from an accredited institution.