Apply on Employer Site

NYC Department of Social Services · 4 hours ago

DATABASE APPLICATION DEVELOPER/REPORT DESIGNER

Manhattan, NY

Full-time

Onsite

Entry, Mid Level

1+ years exp

NYC Department of Social Services is seeking a Database Application Developer/Report Designer to enhance and support program-specific software for the HIV/AIDS Services Administration. The role involves designing reports, coordinating database applications, and providing technical support to users.

ConsultingGovernmentNon ProfitSocial

No H1B

Responsibilities

Design and deploy reports using Microsoft SQL Server Reporting Services

Creates reports for case management, eligibility operations, finance, personnel, housing, and contracts units connecting to database applications in Oracle and MS SQL Server

Coordinate design, development and implementation of HASA database Applications and maintains existing Databases applications, designs, develops and implementing new programs using SQL Server 2016 and above utilizing tables, views, stored procedure, and SSIS packages in SQL Server 2016

Analyze and enhance existing quality assurance and other statistical and periodic reports and create new reports based on analysis and recommendations using all available resources such as Oracle, Electronic Data warehouse (EDW), in house SQL Server Applications and flat files received through file transfer protocol (sftp) from outside HASA

Coordinate the design and planning stages of electronic forms (E-Forms) with Policy and Procedures unit

Maintains and update the design of all web-based E-forms

Communicate with operational staff to know their requirements and feedback and ensuring that these are fully conveyed to programming and web development team, recommending changes to web application and database design

Provide technical support to users and program vendors in the use of web-based application HASAWeb by resolving issues, maintaining security module, adding removing users, codes, roles and coordinating with other HASA staff and/or HRA-ITS

Create ad-hoc reports based on management requests using all available data sources such as Oracle, SQL Server 2016 databases, flat text files

Coordinate the Single Room Occupancy (SRO) billing process, acting as single point source by creating necessary exception reports for contract, creating, uploading, and downloading files to and from HRA ftp servers, requesting updates to central database application

Qualification

Microsoft SQL ServerOracleSQL Server Reporting ServicesSSIS packagesDatabase administrationWeb developmentData analysisTechnical support

Required

A baccalaureate 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 computer systems development and analysis, applications programming, database administration, maintenance and support, systems programming, data communications, mainframe development, mobile development, web development and design

A four-year high school diploma or its educational equivalent and five years of satisfactory full-time computer software experience as described in '1' above

Education and or/or experience equivalent to '1' or '2' above. College education may be substituted for up to two years of the required experience in '2' above on the basis that 60 semester credits from an accredited college is equated to one year of experience

In addition, 24 semester credits from an accredited college or graduate school in computer science or a related field, or a certificate of at least 625 hours in computer programming from an accredited technical school (post high school), may be substituted for one year of experience

However, all candidates must have at least a four-year high school diploma or its educational equivalent and at least one year of satisfactory full-time experience as described in '1' above

Benefits

Public Service Loan Forgiveness

Company

NYC Department of Social Services

The Department of Social Services (DSS) is comprised of the administrative units of the NYC Human Resources Administration (HRA) and the Department of Homeless Services (DHS).

Founded in 1966

New York, New York, USA

10001+ employees