Data and Systems Analyst, OAG - New York City Department of Education

Position Type:

Administrative and Central Office

Office Title/Functional Title:

Data and Systems Analyst, OAG - 26807

Civil Service Title:

City Research Scientist

Level:

L2

Division/Office:

Office of Auditor General

Borough:

Brooklyn

Posting End Date:

08/10/2026

Description:

Position Summary: Under the direction of the Chief of Data and Operations, the Data and Systems Analyst will develop an understanding of New York City Public Schools (NYCPS) data systems, and conduct data analysis research and analytic work that will assist in the Office of Auditor General (OAG)’s identification of areas for audit or collaboration with NYCPS offices and/or divisions.

The Data and Systems Analyst will provide support in enhancing procedures that allow internal NYCPS offices to self-audit their programs, automate audit processes, and design reports that summarize the work of each audit. The position will require collaboration with managers and staff across OAG. This role also supports OAG’s strategic transition toward more predictive and preventive auditing by leveraging data analytics, automation, and emerging technologies to proactively identify risks and strengthen internal controls across the NYCPS. Performs related work.

Reports to: Chief of Data and Operations

Direct Reports: N/A

Key Relationships: OAG Directors, OAG Managers and DIIT.

Responsibilities

• Assist OAG Audit Directors to define audit procedures that target appropriate risks and controls, as well as outline appropriate audit objectives.
• Work with OAG colleagues to improve and enhance NYCPS’s control environments.
• Identify strategies and system controls for stakeholders to consider and implement that promote accuracy and appropriateness of records and data within NYCPS systems.
• Collaborate with database developers and programmers to evaluate existing systems, and propose system or process improvements.
• Identify database requirements through detailed analysis of existing applications and operations.
• Design stored procedures, triggers, and complex analytic queries on large data sets; retrieve data using Cognos and other reporting tools.
• Support the management of OAG databases; coordinate and support updates to databases; manage permissions and other related tasks associated with database administration.
• Support the development of training and provide information to OAG staff on databases on an as-needed basis.
• Maintain professional and technical knowledge by attending educational workshops, reviewing professional publications, and establishing personal networks throughout the Department.
• Maintain records and prepare written analyses, documentation, and presentations summarizing trends and research.