Must be permanent in the Staff Analyst civil service title or currently on the recent civil service exam list to apply. If you are currently on the active civil service exam, please include on your coversheet if you are on the selective certification for SAS and/or R Statistical Analysis Software (SAS). The NYC Law Department is seeking a qualified candidate for a full time position in its Affirmative Litigation Division. The qualified candidate will perform essential duties and responsibilities that will include but are not limited to the following tasks: Provide support to the division’s collections practice, which uses outside counsel and in-house attorneys to collect judgments and debt on behalf of the City. Provide support to the division’s tenant protection work, by analyzing, tracking and reporting on data relevant to code violations and civil penalty calculations, among other things; and May be assigned other projects that require data collection, analysis and reporting. Additional skills and responsibilities include: Developing and implementing processes for searching, tracking and analyzing docketed and undocketed violations adjudicated by the City’s Office of Administrative Trials and Hearings; Developing and implementing procedures relating to review of outside law firms’ monthly invoices and data entry into Law Department case management system (Law Manager); Preparation, review, and analysis of reports and projections relating to the collections practice; Monthly transaction reporting and oversight of Criminal Court processes to ensure accurate data entry; Oversight of issues relating to the Law Department’s credit card system (CPRR), including Department of Finance applications and annual Payment Card Industry (PCI) compliance; Preparation, maintenance, and revisions of system and procedure manuals for collection practice; Working with Law Department Divisions, outside law firms and outside agencies including OATH, ECB, Department of Finance and other agencies that participate in the collections project, on data requirements, system interfaces and reporting; Performing other data analysis and reporting work, and Excel work, as needed by the Division, including developing systems to implement Internal Revenue Code requirements for identifying and reporting Law Department’s judgments, orders, and settlements. Familiarity with NYC Open Data required; Proficiency with Excel required; Proficiency with R preferred.