The Bureau of Revenue Optimization and Automation (ROA) develops and automates complex revenue generating and risk avoidance projects, provides financial analysis and technical support and conducts data research. Most of its projects require proficiency in Enterprise Data Warehouse (EDW), Structured Query Language (SQL) and Microsoft Access. ROA is responsible for implementing revenue enhancing initiatives and projects using complex SQL algorithms and EDW data, analyzing data to identify claims that can be reclaimed for higher federal and state reimbursement rates, preparing claim adjustments to maximize federal and state funding, providing technical support, financial analysis, data retrieval and financial claims support to DSS and other City agencies, responsible for the semi-annual SNAP Certification process for DSS/HRA staff and the 1099 issuances for rental payments

The Finance Office is recruiting for one Administrative Staff Analyst NM II to function as a Director of Revenue Optimization and Automation, who will:


- Supervise the Deputy Director of ROA and 5 analytical staff that is responsible for submitting over $50 million in claims for federal and state reimbursement.

- Ensure all participant and invoice data for claims are analyzed, reviewed and compiled accurately.

- Be responsible for ensuring the accurate and timely submissions of Homebase, Anti-Eviction and Medicaid claims.

- Supervise the semi-annual SNAP Certification process for over 1,500 DSS/HRA staff.

- Manage the data and correction reports within a proprietary database of rental issuances used to generate over 13,000 landlord 1099s for the agency within the prescribed deadlines.

- Oversee the landlord inquiry process to handle questions from landlords after the 1099s are mailed.
- Develop, write and run SQL for new projects and update and modify existing queries as needed

1. A 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 closely related field, 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; in management or methods analysis, operations research, organizational research or program evaluation; in personnel or public administration, recruitment, position classification, personnel 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. 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.

- Proficiency of Enterprise Data Warehouse (EDW) and Structured Query Language (SQL). - Microsoft Office Suite and Access for data analytic purposes. - Excellent writing skills. - Knowledge of Cash Assistance and Eligibility requirements.

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.

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.

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.