Collections Data Analyst

Department-of-Finance; New York (NY); Hybrid; USD 70,000 - 100,000; Full time

Job summary

NYC Department of Finance is seeking an Administrative Staff Analyst to support the Data Analytics & Debt Segmentation Unit in Collections. The role focuses on developing dashboards, monitoring collections performance, and delivering data-driven insights to improve agent performance and collections outcomes.

The candidate will work under the Unit Head of Collections, collaborating with System Modernization and IT teams, and may be eligible for remote work up to 2 days per week.

Qualifications

• Master's degree in economics, finance, accounting, business or public administration, public health, 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 JD from an accredited law school with two years of professional experience.
• Bachelor's degree with four years of professional experience in budget/financial administration, accounting, economic research or related fields including 18 months in supervisory capacity.
• Associate degree and six years of professional experience with similar scope, including 18 months in supervisory capacity.
• High school diploma and eight years of professional experience per above.
• Combination of education and/or experience substituting for the above with at least two years in related work and high school diploma.

Responsibilities

• Develop reports and dashboards to identify opportunities and provide insights.
• Use statistical tools to produce ad hoc reports to monitor collections performance and identify risks and opportunities.
• Leverage multiple databases to create reports offering actionable insights to improve agents’ performance, including performance, KPI, and debt-type reporting.
• Collaborate with System Modernization and FIT teams using data extraction and summarization to support decision making and identify debt-treatment improvements.
• Monitor operational KPIs to ensure execution consistency and advise management on improvements to profitability.
• Create reporting to assess performance and quantify benefits of collections initiatives and root-cause analysis for inventory fluctuations.

Skills

Analytical skills

Organizational skills

Project management

Statistics

Data analytics

SQL

SAS

Machine learning

Education

Master's degree (econ/finance/accounting/business/public admin/related)

Bachelor's degree (relevant field)

Associate degree / 60 credits

High school diploma + 8 years experience

Education/experience combination with two years in eligible roles

Job description

IMPORTANT NOTE: CANDIDATES MUST HAVE A PERMANENT ADMINISTRATIVE STAFF ANALYST CIVIL SERVICE TITLE OR ARE PERMANENT IN A COMPARABLE CIVIL SERVICE TITLE ELIGIBLE FOR A 6.1.9 TITLE CHANGE. PLEASE INCLUDE YOUR EMPLOYEE IDENTIFICATION NUMBER (EIN) WHEN APPLYING AND INDICATE IN YOUR COVER LETTER YOUR PERMANENT CIVIL SERVICE TITLE.

NYC Department of Finance (DOF) is responsible for administering the tax revenue laws of the city fairly, efficiently, and transparently to instill public confidence and encourage compliance while providing exceptional customer service.

DOF’s Customer Operations Division has oversight of the Department of Finance business centers, City Register’s Office, and the Land Records, Adjudication, and Collections divisions. Customer Operations is charged with the processing of tax payments, parking violations payments, and all other charges collected by DOF. The division is also responsible for recording property transfers, adjudicating parking and camera violations, and managing the full life cycle of the department’s enforcement activities related to unpaid business and excise taxes, parking fines, and Environmental Control Board summonses.

The Collections Division is responsible for managing the full life cycle of the Department of Finance’s enforcement activities related to unpaid business and excise taxes, parking fines, and Environmental Control Board summonses. The debt collection process involves specialized professional collectors, experienced in the art of negotiation, who provide debtors with options and encourage full payment. The division utilizes several collection tools to enforce compliance, including notices, telephone dunning, outside collection agencies, and special projects aimed at locating and taking enforcement actions against assets.

The Data Analytics & Debt Segmentation Unit is responsible for the extracting, measuring, and monitoring performance for the Collections Division. The unit is seeking a Collections Data Analyst to proactively contribute to collections strategy by delivering comprehensive analytics strategy and reporting that measures collections strategies and Collection Agents performance across multiple dimensions. The ideal candidate will also serve as Data Analyst on projects related to operational and organizational change, reporting and analytics.

Reporting to the Unit Head of Collections, the selected candidate’s duties and responsibilities will include, but not be limited to the following:

• Develop reports & dashboards to identify areas of opportunity and provide insights.
• Use statistical tools to produce and develop ad hoc reporting tools to monitor and analyze collections performance to identify risks and opportunities within the operation & Collections inventory
• Leverage multiple databases containing collections information to create a set of reports to provide actionable insights to improve collections & agents' performance. Reports will encompass agents’ performance, operational dashboards, debt-type reporting, originating agency reporting, and ad-hoc reports.
• Support Collections' objectives, working with our System Modernization and FIT teams, using data extraction, data manipulation and summarization techniques to provide ad hoc analysis, deep dive assessments, and root cause analysis to support decision making including recommended changes to treatment of debtors.
• Closely monitor operational KPI's to ensure consistency in execution & trends, making recommendations to direct supervisor and Management team on potential improvement to better address collections situations with focus on increasing profitability.
• Develop reporting to assess performance & quantify benefits of collections initiatives & strategies, analyze and identify root cause for inventory fluctuations, review existing documents, procedures and systems.

In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.

This position may be eligible for remote work up to 2 days per week, pursuant to the Remote Work Pilot Program agreed between the City and the Collective Bargaining Unit representing employees serving in the civil service title.

ADMINISTRATIVE STAFF ANALYST ( - 1002D

Minimum Qualifications

1. A master's degree from an accredited college in economics, finance, accounting, business or public administration, public health, 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, and two years of satisfactory full-time professional experience in one or a combination of the following: working with the budget of a large public or private concern in budget administration, accounting, economic or financial administration, or fiscal or economic research; or in management or methods analysis, operations research, organizational research or program evaluation; or 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. Eighteen (18) months of this experience must have been in an executive, managerial, administrative, or supervisory capacity. Supervision must have included supervising staff performing professional work in the areas described above; or
2. A baccalaureate degree from an accredited college and four years of professional experience in the areas described in “1” above, including the 18 months of executive, managerial, administrative, or supervisory experience, as described in “1” above; or
3. An associate degree or completion of 60 semester credits from an accredited college and six years of full-time satisfactory full-time professional experience as described in “1” above, including the 18 months of executive, managerial, administrative, or supervisory experience, as described in “1” above; or
4. A four-year high school diploma or its educational equivalent approved by a state’s department of education or a recognized accrediting organization and eight years of full-time satisfactory full-time professional experience as described in “1” above, including the 18 months of executive, managerial, administrative, or supervisory experience, as described in “1” above; or
5. 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 and at least two years of experience as described in “1” above, including the 18 months of executive, managerial, administrative, or supervisory experience, as described in “1” above.

Preferred Skills

• Superior analytical and organizational skills.
• Strong written, verbal and interpersonal communication skills.
• Strong Project Management skills.
• Extensive knowledge of applied statistics, analytics, machine learning/AI, data science or big data tools (Microsoft SQL and SAS).
• Familiarity with Outlook, and Microsoft Office Suite.
• Interested in taking initiative and helping the team discover problems and troubleshoot solutions.
• Ability to think creatively, embrace new approaches and pioneer innovative solutions to intricate problems.
• Ability to write reports, and work on multiple tasks and assignments while maintaining attention to detail.

55a Program

This 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 Forgiveness

As 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 https://studentaid.gov/pslf/.

Residency Requirement

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

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.