Business/Reporting Analyst, Office of Data Management

New York City Department of Education . - New York, NY4.0

This title is in a civil service competitive class that is subject to examination. Position is only open to applicants with permanent NYC civil service status as Education Officer or candidates who have taken the most recent Education Officer civil service examination.

(Those who previously applied need not re-apply)

Position Summary: The New York City school system is the largest in the country, composed of approximately 1.1 million students and 75,000+ teachers in over 1,700 schools. The Office of Data Management (ODM) is part of the Office of Policy and Evaluation (OPE), within the Division of Teaching and Learning (DT&L). OPE is the primary source of data analysis, research, and academic policy for the DOE. ODM is the business intelligence unit of the DOE. Team members process assessment data, support a growing SQL repository of DOE data systems, build data tools that support instruction, fulfill data requests from across Central offices, serve as data consultants and thought partners, project manage the reporting of data to the state’s longitudinal data system, and produce documentation to support data users throughout the organization.

With guidance from ODM leadership, the Business/Reporting Analyst plays a critical role in driving operational efficiency to ensure excellence in academic data collection and reporting as required by state and federal partners. The Analyst conducts research and analysis on DOE academic and person data reported to New York State Education Department (NYSED); prepares reports to communicate areas of improved efficiency in data collection and reporting to NYSED; creates and provides resources to support staff and partnership development; and works with ODM colleagues, DOE program offices, and technical partners to develop and improve data collection and reporting processes. Additionally, the Analyst may provide guidance to junior analysts on internal processes, including the fulfilment of data requests. Performs related work.

Reports to: Deputy Director, Information Management and Support, Office of Data Management

Direct Reports: N/A

Key Relationships: Senior Director, Office of Data Management; Director, Information Management Support; Team Lead – Reporting Support; Senior Analyst – School Performance; Programmer / Analyst; Technical Writer / Analyst; Works closely with the Office of Assessment, the Division of Instructional and Information Technology, and the Office of Academic Policy & Systems.


Review and evaluate local, state and federal education policies and prepare analyses on impact of these policies on DOE data collection and reporting processes, systems, and personnel.
Research education policies in comparable school districts to inform recommendations to improve efficiencies in data collection and reporting processes, systems, and personnel.
Develop quantitative analyses and programming routines using structured query language (SQL) and analytical tools to effectively analyze DOE academic and personnel data used to inform organizational policy development.
Based on quantitative analyses and research on educational policies, develop theories about organizational data trends.
Prepare reports evaluating, summarizing and interpreting the potential accountability and financial impact of reported Student Information Repository System (SIRS) and Basic Educational Data System (BEDS) data on required and supported education services or the DOE cost efficiencies.
Design and develop reports that will be used to measure data quality and ultimately inform users of recommendations for improved efficiency in data collection and reporting processes.
Prepare comprehensive reports of findings with recommendations for improved efficiency in the reporting of BEDS and SIRS data, as well as for responding to internal and external requests for academic and person data.
Utilize research techniques to design and develop surveys for the collection of institutional and personnel reporting requests from NYSED.
Manage communications between IMS and technical partners in other DOE program offices to identify areas of improvement and alignment in data collection and reporting protocols.
Plan and coordinate staff development opportunities for IMS and partner offices to ensure understanding of documented processes and programs.
Conduct research on organizational documentation practices and document standard operating procedures of IMS (g. identify stakeholders, processes, and outcomes) to institutionalize knowledge.
Research and gather resources that support improvements in the organization’s reporting and analytics management practices, to improve NYC DOE programs and policies.
Organize internal resources to respond to data escalations and ensure resolution.
Identify and escalate issues to leadership team as necessary; provide suggestions for resolution.
Quickly assess and resolve complex issues using sound judgment and problem solving skills. Issues range from data management to customer service.
Assist in researching and planning professional development and team-building activities that deepen understanding of education practice and policy as well as build analytical skills.
Assist in the development of a shared project management system to streamline team work planning and project schedules and improve planning processes.
Support team staffing, hiring, and performance management and assist in implementation of related improvements.
Provide regular project status reports as required to the team leader and other ODM leadership; represent the data management team by working cross-functionally with ODM colleagues and program offices.

Qualification Requirements:

A master’s degree from an accredited college in education, guidance, educational administration and supervision, or a related field; or
A baccalaureate degree from an accredited college and one of the following:

(A) one year of full-time satisfactory professional experience in educational program administration, career or occupational program administration; or

(B) one year of full-time satisfactory professional experience as a state certified or licensed teacher; or

A four-year high school diploma or its educational equivalent and five years of full-time satisfactory professional experience in educational program administration, career or occupational program administration; or
A combination of education and/or experience which is equivalent to the requirements in "1," "2," and "3" above. However, all candidates must have at least an approved four-year high school diploma or its educational equivalent.


Knowledge of public sector and/or public education.
Interest in developing or already demonstrated subject matter expertise in student attendance data, English Language Learner (ELL) data, and/or student enrollment data.
Experience as an analytical, process-oriented thinker and problem solver.
Experience in data analytics and reporting.
Experience gathering business requirements from business owners, program offices, and/or subject matter experts (SME's).
Experience designing and executing quality assurance tests.
Ability to perform independent research, data collection, and analysis.
Excellent written and verbal communication skills.
Experience writing technical and user documentation, business requirements documents, standard operating procedures.
Strong strategic thinking and project management skills, attention to detail, and ability to proactively identify key issues and risks.
Ability to provide leadership and guidance to junior staff, as needed.
Highly proficient in Microsoft Office applications including Excel, Word, Access, Visio.
Ability to work independently, adapt quickly to changing priorities.
Prior experience working in a fast-paced, complex working environment.
Excellent command of SQL and understanding of relational databases.
Knowledge of Business Intelligence Reporting tools.
Experience using project management tools.
Experience working with data integrity and improving processes for increased data quality.
Knowledge of best practices in data governance, analysis and reporting.
Excellent interpersonal skills in working with technical and non-technical personnel.
Internal candidates preferred.

Salary: $70,370+

(Internal candidates who are selected for this position and who currently hold comparable or less senior positions within the DOE will not make less than their current salary.)

Please submit a resume an cover letter with your application.

Applications will be accepted through December 26, 2019 until 3:00 p.m.

NOTE: The filling of all positions is subject to budget availability.

This position is open to qualified persons with a disability who are eligible for the 55-a program. Please indicate in your cover letter that you would like to be considered for the position under the 55-a program.


It is the policy of the Department of Education of the City of New York to provide equal employment opportunities without regard to actual or perceived race, color, religion, creed, ethnicity, national origin, alienage, citizenship status, age, marital status, partnership status, disability, sexual orientation, gender (sex), military status, unemployment status, caregiver status, consumer credit history, prior record of arrest or conviction (except as permitted by law), predisposing genetic characteristics, or status as a victim of domestic violence, sexual offenses and stalking, and to maintain an environment free of harassment on any of the above-noted grounds, including sexual harassment or retaliation. For more information, please refer to the DOE Non-Discrimination Policy.

Required Skills

Required Experience