Report Writer

City of New York•New York City, NY

19h

About The Position

The Report Writer will work in the Litigation Support Division’s Practice Management group, which oversees the agency’s matter management system, Litify ELM (LegalStratus) on the Salesforce platform, associated reporting, and the agency’s iManage/Filesite document management system. The role designs and develops reports and interfaces to and from the matter management system, including validation and testing. The position also supports data quality, system configuration and testing, interface development, and Practice Management projects. Candidates must meet the Computer Associate (Software) qualifications and be reachable on the Computer Associate (Software) Civil Service List (List #1133). Only permanent employees in the title who are reachable on that list are eligible to apply.

Requirements

Meet the Computer Associate (Software) qualification through one of the stated pathways: a bachelor’s degree 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; a high school diploma or equivalent and five years of such experience; or equivalent education and/or experience.
Have at least a four-year high school diploma or equivalent and at least one year of satisfactory full-time computer software experience, regardless of substitutions.
Eligible applicants must be permanent employees in the title and reachable on the Computer Associate (Software) Civil Service List (List #1133).

Responsibilities

Design, develop, maintain, validate, and test reports using front-end queries, CRM Analytics, Crystal Reports, SQL, and SOQL.
Run quality assurance on reports, identify and resolve issues, and distribute reports to end users.
Draft and update report, system, and operations specifications, diagrams, logic flowcharts, and documentation in technical and non-technical terms.
Identify data-entry issues and help develop processes to clean up and correct them to ensure data accuracy and reliability.
Perform data entry in the matter management system through the front-end application as needed.
Work with IT DBA staff and consultants to create and test configuration changes and database scripts.
Test database scripts and matter management application interfaces, coordinating with other agencies or entities and working with consultants and IT DBA staff to create or update interface code and packages.
Vet data in lower environments using front-end queries, SOQL, and SQL before approving imports into the matter management system through interfaces.
Draft and update interface specifications in technical and non-technical terms.
Identify matter management system issues, defects, and potential enhancements.
Collaborate on test plans and test fixes or upgrades in lower environments before they are applied.
Assist with special projects as needed.