DATABASE APPLICATION DEVELOPER/REPORT DESIGNER

City of New York • New York, NY

11d • $83,330 - $95,829

About The Position

The HIV/AIDS Services Administration (HASA) is recruiting one Computer Associate (Software) II to develop, design, enhance, implement, and support program-specific software and database information structures. Under the general supervision of the Applications Development Manager, the role has considerable latitude for independent initiative and judgment in resolving Information Technology issues. Applicants must hold permanent status in the Computer Associate (Software) civil service title.

The position designs and deploys reports with Microsoft SQL Server Reporting Services for case management, eligibility operations, finance, personnel, housing, and contracts units, using Oracle and Microsoft SQL Server database applications. It coordinates development and implementation of HASA database applications, maintains existing applications, and develops programs using SQL Server 2016 and later, including tables, views, stored procedures, and SSIS packages.

The role also analyzes and enhances quality-assurance, statistical, and periodic reports; plans and maintains web-based electronic forms; communicates operational needs to programming and web-development teams; and supports users and vendors of HASAWeb. It creates ad-hoc reports from available data sources and coordinates the Single Room Occupancy (SRO) billing process, including exception reporting and file transfers with HRA FTP servers.

Requirements

• Applicants must be permanent in the Computer Associate (Software) civil service title.
• One of the following qualification pathways: a bachelor's degree from an accredited college, including or supplemented by 24 semester credits in computer science or a related computer field, and one year of satisfactory full-time computer software experience in a listed area; or a four-year high school diploma or equivalent and five years of such experience; or equivalent education and/or experience under the stated substitution rules.
• Candidates qualifying through the education/experience equivalency pathway must have at least a four-year high school diploma or equivalent and at least one year of satisfactory full-time computer software experience in a listed area.
• Qualifying computer software experience may include computer systems development and analysis, applications programming, database administration, maintenance and support, systems programming, data communications, mainframe development, mobile development, or web development and design.

Responsibilities

• Design and deploy reports using Microsoft SQL Server Reporting Services for case management, eligibility operations, finance, personnel, housing, and contracts units, drawing on Oracle and Microsoft SQL Server database applications.
• Coordinate the design, development, and implementation of HASA database applications; maintain existing applications and develop new programs using SQL Server 2016 and later, including tables, views, stored procedures, and SSIS packages.
• Analyze and enhance existing quality-assurance, statistical, and periodic reports, and create new reports based on analysis and recommendations using Oracle, the Electronic Data Warehouse (EDW), in-house SQL Server applications, and files received via SFTP.
• Coordinate the design and planning of electronic forms with the Policy and Procedures unit, and maintain and update web-based E-forms.
• Communicate with operational staff to gather requirements and feedback, convey them to programming and web-development teams, and recommend changes to web applications and database design.
• Provide technical support to users and program vendors using HASAWeb; resolve issues, maintain its security module, add or remove users, codes, and roles, and coordinate with HASA staff and/or HRA-ITS.
• Create ad-hoc reports requested by management using available data sources, including Oracle, SQL Server 2016 databases, and flat text files.
• Coordinate the Single Room Occupancy (SRO) billing process as the single point source, create contract exception reports, transfer files to and from HRA FTP servers, and request updates to the central database application.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level