Director, Data Analytic, reporting - Manhattan, United States - New York City, NY

Description

PLEASE NOTE CANDIDATES MUST BE PERMANENT IN THE ADMINISTRATIVE STAFF ANALYST CIVIL SERVICE TITLE*THE CORRECT SALARY RANGE FOR THIS POSITION IS $94,715 to $123,322 YEARLY.

The Department of Social Services Accountability Office (DSS-AO) is responsible for supporting the integrity of social services programs administered by the New York City Human Resources Administration (HRA), Department of Social Services (DSS) and Department of Homeless Services (DHS).

Data Analytics Reporting & Triage (DART) analyzes operational data and revises processes to improve DSS-AO/IREA efficiency and effectiveness.

It also manages the process by which all undercare fraud referrals are identified, triaged and assigned to the Bureau of Fraud Investigation (BFI).

DART maintains the data analysis, reporting and performance measurement systems of IREA, utilizing advanced analytics to identify new investigative initiatives, refer cases with the highest probabilities of fraud, and ensure data quality and reporting consistency.

The DART is recruiting for (1) Administrative Staff Analyst NM II to function as a Director, who will:

• Oversee all the data reporting and analytic activities and capabilities provided by DART. Design, develop and implement algorithms and analytics code/scripts to support AO's analytic and reporting needs. Identify programs, systems and algorithmic processes requiring enhancements, develop strategy, design and deliverables to ensure enhancement initiatives are executed in a timely manner and taking advantage of newer, lower cost technologies. Review queries for accuracy and to improve efficiency.
• Provide database and data match administration services which are used by DSS investigative and compliance operations in support of the agency's mission to detect and deter fraud, waste and abuse. Allocate technological resources to provide for efficient processing of Big Data; leverage application-based functionality, such as pivot tables, v-lookups geospatial extensions, visual basic, etc. within internal, program specific applications to organize, understand and summarize voluminous datasets. Identify and oversee the acquisition of internal and external data matches.
• Develop and oversee the ongoing data analytics, data mining, data matching, data quality, and data sharing components, using software such as SQL and Oracle, that are used by internal and external partners including OPA, FIA, MICSA, HASA, ACS, and DHS. Develop QA/QC of SQL code and coordinate the automation of algorithms within associated application.
• Identify, recommend and implement standards to increase AO's ability to efficiently detect and investigate fraud using analytic tools. Analyze program requirements and proposes automation alternatives based on internally developed algorithms that result in collections, cost savings, and lower error rates for the Agency. Evaluate agency processes in connection with relevant program rules and regulations and identify weaknesses to be remedied and opportunities for new projects.
• Perform complex and time-sensitive ad hoc data analytic requests from AO and DSS management. Evaluate issues related to fraud and eligibility through a comprehensive review of available agency and external data sources, client documentation, and program rules and regulations. Produce reports and provide recommendations for management.
• Coordinate multiple ongoing projects of significant complexity, related to a broad scope of AO, Agency and City-wide initiatives. Design and implement project plans, prepare written status reports, and provide status updates regarding assigned projects at executive staff meetings. Develop metrics and measurement methodologies for DART initiatives and works closely with AO Support operations to coordinate internal and external data exchanges and system enhancements.
• Provide operational and reporting guidance to other program areas across DSS who develop systems that will impact or be used by AO.
• Oversee data modeling, predictive analytics, geospatial analytics, and other investigative techniques employed by DART.
• Plan and direct data quality and control measures while overseeing the data quality aspects of the Triage unit. Ensure that the IRS system contains properly coded and classified data. This is critical when developing datasets used in DART's daily operations.
• Oversee and train staff who systematically review agency data and perform complex analyses using systems such as EDW, MDW, SFARS, and ACRIS and use tools such as R, SQL, Excel, ARCGIS, and GBAT.

Minimum Qualifications

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

Preferred Skills

• Extensive experience supporting HRA programs including Medicaid, HPA, FIA/SNAP, Accountability, and Fair Fares. - Extensive experience working with HRA and NYS data systems including EDW, MDW, WMS, SFARS, Cognos, IRIS, and OneViewer. - Extensive experience with bid date and tools such as Excel, SQL, ArcGIS, R, and Python - Experience with commercial data systems such as Accurint, Talx, USPS Address Forwarding is a plus - Background in project management or fraud investigations is a plus

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

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.