Back to jobs

Database Application Developer/Report Designer

New York, NY, United States

Live, first seen by us 19 days ago
Pay
Pay not listedSimilar roles state $95K–$145K
Work setting
On-site — work setting source
Work setup in the employer’s posting: On-site
From the employer’s posting
Employment
Full-time — employment source
Employment type in the employer’s posting: Full-time
From the employer’s posting

What you’ll work on

Full posting
  • Design and deploy reports in Microsoft SQL Server Reporting Services

  • Build and maintain SQL Server 2016 databases using tables, views, stored procedures and SSIS packages

  • Analyze and enhance quality assurance and statistical reports

  • Maintain web-based E-Forms and the HASAWeb application and its user security

  • Coordinate the Single Room Occupancy (SRO) billing process and related file transfers

From the employer’s posting
Design and deploy reports using Microsoft SQL Server Reporting Services
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
Maintains and update the design of all web-based E-forms.
Coordinate the Single Room Occupancy (SRO) billing process
Apply at City of New York

Posting record

Report an error
Status in our records
Live
First seen by us
Oct 28, 202619 days ago
Recorded sightings
31
Last seen by us
Nov 16, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$95K–$145K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,248 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 19

Similar jobs usually come down between day 5 and day 43.

At City of New York, jobs usually come down by about day 12.

From 14,933 similar postings that came down, and 347 of City of New York’s. Coming down is not always a hire.

City of New York is hiring

37 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Analyst hiring is picking up
  • Takes jobs down quickly
  • 35% of open jobs were reposted
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Oracle
  • SQL Server
  • SSIS
Where the posting names them
Under the general supervision of the Applications Development Manager, with considerable latitude for independent initiative and judgment for deriving solutions to all issues and concerns within Information Technology, database developer/ report designer will be responsible for the development, design and enhancement of info-structures, implementation, and support of program specific software. - 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.
- 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 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.
- 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.

Your next step

Complete your application on jobs.smartrecruiters.com. The employer’s form will show what is required.

Applying through SmartRecruiters

  • Uploading your resume fills in the application form for you, so check what it filled before you send.

Already applied? Track this application

Demand for Analyst roles

New Analyst postings at the employers we follow are up 23% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 2. The fewest in a week was 990, the most 1,515, and the latest week had 1,515.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Job description

View original posting ↗

Job Description

APPLICANTS MUST BE PERMANENT IN THE COMPUTER ASSOCIATE SOFTWARE CIVIL SERVICE TITLE

The HIV/AIDS Services Administration (HASA) is the most comprehensive program of its kind in the country, helping New Yorkers living with HIV or AIDS live healthier and more independent lives. We assist with an individualized service plan that targets the support and necessary benefits that are specific to a client’s medical situation that will enhance his or her well-being. In addition, this Agency has a legal mandate, based on Local Law 49 and the Henrietta D. versus Giuliani Federal court case, to ensure that HASA clients are serviced promptly.

HASA provides intensive case management, rental assistance, emergency and non-emergency housing, and assistance with applying for public benefits and services including Medicaid, food stamps and cash assistance. HASA also provides vocational services that prepare clients for work. With counselors to help identify barriers to employment, clients can select vocational goals and receive support. Other HASA services include home care and homemaking services, mental health and substance use screening and treatment referrals, transportation assistance,
referrals to community-based organizations, and SSI or SSD application and appeal.

The HIV/AIDS Services Administration (HASA) is recruiting for one (1) Computer Associate (Software) II to function as a Database Application Developer/Report Designer, who will:

Under the general supervision of the Applications Development Manager, with considerable latitude for independent initiative and judgment for deriving solutions to all issues and concerns within Information Technology, database developer/ report designer will be responsible for the development, design and enhancement of info-structures, implementation, and support of program specific software.

- 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.

Hours/Schedule: 9:00a- 5:00p

COMPUTER ASSOC (SOFTWARE) - 13631

Qualifications

1. 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; or

2. 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; or

3. 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.

Additional Information

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

New York, NY, United States

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.