← Back to jobsJob ID col-cmwf6bx7d08cc89hql9d4j7ub

NYC Department of Health and Mental HygienePosted 20 days ago

Report Writer

Full-time
On-site
1+ years
$77K – $107K/yr
Posted 20 days ago

Responsibilities Design, develop and maintain reports including programming/coding and validating/testing reports using front end queries, CRM Analytics, Crystal Reports and SQL and SOQL Run and conduct Quality Assurance (QA) of reports and distribute to end users; QA includes identifying and resolving issues, if any Draft and update report and system and operations specifications and diagrams, logic flowcharts and d

Posted
20 days ago
Source
cityjobs.nyc.gov
Sector
Education and Training

Opens the employer's application page in a new tab

Responsibilities

  • Design, develop and maintain reports including programming/coding and validating/testing reports using front end queries, CRM Analytics, Crystal Reports and SQL and SOQL
  • Run and conduct Quality Assurance (QA) of reports and distribute to end users; QA includes identifying and resolving issues, if any
  • Draft and update report and system and operations specifications and diagrams, logic flowcharts and documentation in both technical and non-technical terms
  • Identify data entry issues and assist to develop processes to clean-up and correct such issues to ensure the accuracy and reliability of our data
  • Perform data entry in matter management system usually using front end application as needed
  • Work with the IT DBA staff and consultants in the creation and testing of configuration changes and scripts against the databases
  • Test database scripts and the matter management application interfaces which may include coordinating with other agencies/entities and working with consultants and/or the IT DBA staff to create/update interface code/packages
  • Vet data in lower environments using front end queries, SOQL and SQL before approving import of new data into matter management system via interfaces
  • Draft and update interface specifications in both technical and non-technical terms
  • Identify issues, defects and/or enhancements to be addressed in the matter management system
  • Collaborating to develop test plans and test same in the lower environments before fixes/upgrades may be applied
  • Assist in special projects as needed

Qualifications

  • ONLY PERMANENT EMPLOYEES IN THE TITLE AND THOSE THAT ARE REACHABLE ON THE COMPUTER ASSOCIATE (SOFTWARE) CIVIL SERVICE LIST (LIST# 1133) ARE ELIGIBLE TO APPLY
  • 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
  • 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
  • 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

Preferred

  • Ability to work with a team on multiple projects simultaneously and to re-prioritize tasks as needed
  • Substantial experience with CRM Analytics and/or Crystal Reports
  • Substantial experience with SQL-based databases and ability to write and execute SQL code
  • Working knowledge of SOQL (Salesforce Object Query Language) preferred
  • Working knowledge of Informatica Intelligent Cloud Services (IICS) preferred
  • Experience with Windows Server 2012, 2019 or above
  • Excellent oral and written communication skills including with non-technical users
  • Attentive to detail and persistent in follow up

Required skills

Application ProgrammingCRM AnalyticsCrystal ReportsSOQLSQLSoftware DevelopmentWindows Server

Full job description

Responsibilities

  • Design, develop and maintain reports including programming/coding and validating/testing reports using front end queries, CRM Analytics, Crystal Reports and SQL and SOQL
  • Run and conduct Quality Assurance (QA) of reports and distribute to end users; QA includes identifying and resolving issues, if any
  • Draft and update report and system and operations specifications and diagrams, logic flowcharts and documentation in both technical and non-technical terms
  • Identify data entry issues and assist to develop processes to clean-up and correct such issues to ensure the accuracy and reliability of our data
  • Perform data entry in matter management system usually using front end application as needed
  • Work with the IT DBA staff and consultants in the creation and testing of configuration changes and scripts against the databases
  • Test database scripts and the matter management application interfaces which may include coordinating with other agencies/entities and working with consultants and/or the IT DBA staff to create/update interface code/packages
  • Vet data in lower environments using front end queries, SOQL and SQL before approving import of new data into matter management system via interfaces
  • Draft and update interface specifications in both technical and non-technical terms
  • Identify issues, defects and/or enhancements to be addressed in the matter management system
  • Collaborating to develop test plans and test same in the lower environments before fixes/upgrades may be applied
  • Assist in special projects as needed

Preferred

  • Ability to work with a team on multiple projects simultaneously and to re-prioritize tasks as needed
  • Substantial experience with CRM Analytics and/or Crystal Reports
  • Substantial experience with SQL-based databases and ability to write and execute SQL code
  • Working knowledge of SOQL (Salesforce Object Query Language) preferred
  • Working knowledge of Informatica Intelligent Cloud Services (IICS) preferred
  • Experience with Windows Server 2012, 2019 or above
  • Excellent oral and written communication skills including with non-technical users
  • Attentive to detail and persistent in follow up

Benefits

  • As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs.

Qualifications

  • ONLY PERMANENT EMPLOYEES IN THE TITLE AND THOSE THAT ARE REACHABLE ON THE COMPUTER ASSOCIATE (SOFTWARE) CIVIL SERVICE LIST (LIST# 1133) ARE ELIGIBLE TO APPLY
  • 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
  • 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
  • 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
  • Ability to work with a team on multiple projects simultaneously and to re-prioritize tasks as needed
  • Substantial experience with CRM Analytics and/or Crystal Reports
  • Substantial experience with SQL-based databases and ability to write and execute SQL code
  • Working knowledge of SOQL (Salesforce Object Query Language) preferred
  • Working knowledge of Informatica Intelligent Cloud Services (IICS) preferred
  • Experience with Windows Server 2012, 2019 or above
  • Excellent oral and written communication skills including with non-technical users
  • Attentive to detail and persistent in follow up
  • 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.

Required skills

  • Application Programming, CRM Analytics, Crystal Reports, Informatica Intelligent Cloud Services (IICS), SOQL, SQL, Software Development, Windows Server

Preferred skills

  • Attentive to detail and persistent in follow up, Experience with Windows Server 2012, 2019 or above

Experience

  • 1+ years

Company

  • New York City public health agency.
  • Queens, New York, USA
  • https://www.nyc.gov/site/doh/index.page

Job details

Employment type

Full-time

Seniority level

1+ years

Date posted

Oct 31, 2026

Work mode

On-site

Job source

cityjobs.nyc.gov

Company

NYC Department of Health and Mental Hygiene

Education and Training

New York City public health agency.

See all 29 jobs from NYC Department of Health and Mental Hygiene →
  • Queens, New York, USA
  • Education and Training
  • nyc.gov

Similar jobs

Matched on role, skills and location · live jobs only

See more Educational Administration jobs in New York

NYC Health + Hospitals

2d ago

New

Training and Development Rep

Full-timeOn-siteNew York, NYCompetitive

NYC Health + Hospitals is the largest public health care system in the United States, providing outpatient, inpatient, and home-based services across New York City.

Why similarSame roleNew York

Research Foundation of The City University of New York

1d ago

New

Instructional Designer

Full-timeHybridNew York, NY$70K – $90K/yr

The Research Foundation of The City University of New York (RFCUNY) is seeking an Instructional Designer to enhance workforce development and technical training programs.

Why similarSame roleNew York

L&d programs

1d ago

New

Jr Project Coordinator

Full-timeOn-siteBronx, NYCompetitive

Essen Health Care is hiring a Junior Project Coordinator for Essen Academics. The role supports healthcare training, certification, and recruitment programs by coordinating participant progress, annual programs, IMG activities, and department communications.

Why similarSame roleBronx

Get new Educational Administration jobs in New York by email

Create job alert

Report Writer

NYC Department of Health and Mental Hygiene · $77K – $107K/yr

Apply on company site