DATA ANALYST

*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. Required skills and responsibilities include: the ability to analyze, track and report on data available on the NYCs Open Data and other publicly available datasets; manage inquiries requiring data analysis; develop reports and reporting tools, including from Law Manager and Excel; develop more detailed reports using Structured Query Language (SQL) tools; generate spreadsheets and reports, often for litigation; and translate concepts into Excel formulae and analysis to generate usable work product.STAFF ANALYST - Minimum QualificationsA master's degree from an accredited college in economics, finance, accounting, business or public administration, human resources management, management science, operations research, organizational behavior, industrial psychology, statistics, personnel administration, labor relations, psychology, sociology, human resources development, political science, urban studies or a Juris Doctor degree from an accredited law school; orA baccalaureate degree from an accredited college and two years of satisfactory full- time professional experience working in one or a combination of the following areas: working with the budget of a large public or private concern in budget administration, accounting, economic or financial administration, or fiscal or economic research; in management or methods analysis, operations research, organizational research or program evaluation; in personnel or public administration, recruitment, position classification, personnel relations, labor relations, employee benefits, staff development, employment program planning/administration, labor market research, economic planning, social services program planning/evaluation, or fiscal management; or in a related area.An associate degree or completion of 60 semester credits from an accredited college and four years of satisfactory full-time professional experience as described in "2" above.A four-year high school diploma or its educational equivalent approved by a State's department of education or a recognized accrediting organization and six years of satisfactory full-time professional experience as described in "2" above.A combination of education and/or experience equivalent to “1”, “2”, “3”, or “4” above. College education may be substituted for professional experience at the rate of 30 semester credits from an accredited college for one year of experience. However, all candidates must have a high school diploma.55a ProgramThis position is also open to qualified persons with a disability who are eligible for the 55-a Program. Please indicate at the top of your resume and cover letter that you would like to be considered for the position through the 55-a Program.Public Service Loan ForgivenessAs a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at class="jobad-residencyRequirement">Residency RequirementNew York City residency is generally required within 90 days of appointment. However, City Employees in certain titles who have worked for the City for 2 continuous years may also be eligible to reside in Nassau, Suffolk, Putnam, Westchester, Rockland, or Orange County. To determine if the residency requirement applies to you, please discuss with the agency representative at the time of interview.