Data Analytics Auditor - NYC Office of School Health

The Office of School Health (OSH) is a joint Program of the NYC Public Schools (NYCPS) and the Department of Health and Mental Hygiene (DOHMH) responsible for promoting the health of the 1 million school children enrolled in approximately 1,800 public and non‑public schools in the New York City. OSH has health records on all these students and collects vital health and wellness information in the Automated Student Health Record System.

The Office of School Health has a Bureau of 2,000 employees. The OSH consists of several programs:
Nursing, Vision, Medical, Mental Health, Adolescent Health, Oral Health, Operations and The Management Information System (MIS) program.

The MIS (Management Information Systems) program is responsible for all program’s IT applications used by the Bureau. Applications are developed and maintained by our internal development team and data is stored using Microsoft SQL server. Current production applications are under constant improvement and new applications are developed based on business needs. Data quality, data integrity and evolution of process controls require improvement, oversight, and adherence.

The nursing program tracker logs vendor nurse coverages in schools when there are vacancies and call outs.

The MIS program is seeking a Data Analytics Auditor (DAA) to focus resolving $12M of payments data for Agency Nurse coverage application. The analyst will learn the current system, evaluate, and make recommendations for improvement. The analyst will participate in collection efforts for over payments based on data evidence.

Under the direction of the MIS Development director and in collaboration with agency nurse tracking coordinator, the Data Analytics Auditor will reconcile pervasive systemic issues compounded over the years of relaxed restriction of processing rules. Using data analytical tools such as SQL, tableau, and program scripting, the DAA will identify process flaws by researching 18 years of data to identify data integrity issues.

The DAA will have freedom of latitude to access SQL server databases, conduct investigative research, discuss issues with stakeholders on invoicing data from 2008 to present and recommend changes to processes and new RFPs.

The DAA will conduct necessary research to create database views, data models, and program scripting language in SQL using SQL stored procedures and SQL job scheduling to generate reports. Various reports are needed to present data models on expense trends and forecasts, data violations and improper job set ups, vendor errors, agency staff usage and erroneous billing. The DAA is expected to manage data systems for processing of 100M in agency nurse expenses.

The DAA will reconcile billing issues over the past several years by analyzing invoices paid database against approved records for payments and timesheets. The analyst will reconcile data inconsistencies such as jobs billed more than once, correcting nurse names where nurses are listed working two different jobs on the same day. The DAA will need to research timesheets, review discrepancies and conduct data audit to determine whether coverage should be approved for payment.

The Data Analytics Auditor is empowered to develop and code new processes and solutions to improve payment reconciliation and work directly with the development unit to co‑author technology on process changes.

The DAA position is an IT centric position and requires strong analytical skills, data manipulation, math skills and proficient in data analytical tools. The DAA Preferred candidates should have a strong background in data analysis, is comfortable working with record sets with over a million records, experienced with data modeling and data architecture, and proficient using analytical tool such as SQL, SAS, Python or other data scientist tools for analyzing large data sets.

The DAA is required to understand relational database systems, database normalization concepts, and experience with building data models and improving existing data architecture.

The DAA will supervise the IT analyst to review asset data and operations data to ensure every school medical room has a…