DATABASE APPLICATION DEVELOPER/REPORT DESIGNER
City of New York1 day ago
New York, NY, USAMid Level
Responsibilities
- Design and deploy reports using Microsoft SQL Server Reporting Services for case management, eligibility, finance, personnel, housing, and contracts units.
- Design, develop, implement, maintain, and enhance HASA database applications using SQL Server tables, views, stored procedures, and SSIS packages.
- Analyze and improve quality assurance, statistical, periodic, and ad-hoc reports using Oracle, the Electronic Data Warehouse, SQL Server applications, and flat files.
- Coordinate the design and planning of electronic forms and maintain web-based E-forms.
- Gather operational staff requirements and feedback and communicate them to programming and web development teams.
- Provide technical support for HASAWeb users and program vendors, including maintaining security modules and managing users, codes, and roles.
- Coordinate the SRO billing process, including exception reporting and file transfers with HRA FTP servers.
Requirements
- Permanent status in the Computer Associate (Software) civil service title is required.
- A bachelor's degree including or supplemented by 24 semester credits in computer science or a related computer field, plus one year of satisfactory full-time computer software experience, or an equivalent qualifying education and experience combination.
- Alternatively, a four-year high school diploma or equivalent and five years of satisfactory full-time computer software experience may qualify.
- Computer software experience may include systems development and analysis, applications programming, database administration, maintenance and support, systems programming, data communications, mainframe development, mobile development, web development, and design.
- College education and qualifying computer science coursework or an accredited technical-school programming certificate may substitute for specified experience, but all candidates must have at least a four-year high school diploma or equivalent and one year of satisfactory full-time experience.
About City of New York
The City of New York is the municipal government for the five boroughs, delivering public services such as housing, social assistance, public safety, and digital tools for residents and businesses. It is publicly funded and operates agencies including the Department of Social Services (HRA and DHS) and the New York City Housing Authority. Headquartered in New York, NY, it builds and maintains large-scale systems supporting benefits eligibility, case management, housing, and civic services.