Position Type:
Technology

Date Posted:
12/7/2022

Location:
Central Office Administration Building

Closing Date:
01/01/2023

JOB DESCRIPTION TRENTON BOARD OF EDUCATION
BUSINESS AND TECHNICAL

Database Analyst

JOB TITLE: Database Analyst

REPORTS TO: Executive Director of Technology and Innovation

SUPERVISES: N/A

NATURE AND SCOPE OF JOB:
Assist in the development, maintenance and management of all district databases, including the analyses and reporting of requested data to inform instructional and operational decision-making.

QUALIFICATIONS:
The Database Analyst shall:

1. Hold a Bachelor's Degree in Computer Science, Education (with a concentration in technology), Information Systems or Management Information Systems, or similar field of study. A Master's Degree is preferred.
2. Have a minimum of three years' relevant work experience in computer support services and application development. Experience supporting the district's student information system such as PowerSchool, Genesis, Infinite Campus or other student information system is preferred.
3. Experience working with Application for State School Aid (ASSA).
4. Experience in the use of student information systems to ensure accurate enrollment and demographic data to produce enrollment books monthly and reports.
5. Demonstrate experience with relational database management, database programming and business systems.
6. Demonstrate knowledge of data warehousing and the completion/submission of federal and New Jersey state reports.
7. Demonstrate ability at an intermediate level with Microsoft Office Suite, especially Excel, including lookup and pivot tables, as well as the ability to work with large data sets.
8. Demonstrate ability to analyze and communicate qualitative and quantitative data sets.
9. Demonstrate excellent organization skills.
10. Demonstrate ability to work independently.
11. Have excellent integrity and demonstrate good moral character and initiative.
12. Exhibit a personality that demonstrates enthusiasm and interpersonal skills to relate well with staff and administration.
13. Meet such alternatives to the above qualifications as the Superintendent may find appropriate and acceptable.

JOB FUNCTIONS AND RESPONSIBILITIES
The Database Analyst shall:

1. Log and troubleshoot malfunctions of information systems for the purpose of resolving operational issues and restoring services relating to district databases.
2. Assist with access to online forms, portals and communication vehicles throughout the year.
3. Assist with training on software packages/information systems and various databases.
4. Assist with auditing student database information for the purpose of student accuracy and validation of student enrollment for funding purposes.
5. Assist with district-wide student admissions and enrollment processes.
6. Assist with the development, implementation and maintenance of a school-level database for

collection, organizing, analyzing and reporting disaggregated student testing and other data required by local, state and federal programs.

1. Assist in maintaining and controlling proper staffing ratios in accordance with district guidelines and state and federal laws.
2. Assist with the placement of students in schools and grade levels to maintain appropriate class sizes and grade level configurations.
3. Assist with complex data information projects with independence.
4. Develop user roles in the student information system and ensure security settings align with the user's job description.
5. Extract data from the student information system for reporting and analysis.
6. Develop reports for end users, providing accurate, timely, and accessible data and assisting personnel to derive insights from the data.
7. Train personnel to input, access and utilize the district's student information system (such as PowerSchool, Genesis, Infinite Campus or other student information systems), according to user roles.
8. Complete and submit federal, state and local reports.
9. Code, test and install customizations as requested by various departments in the development/test environment. Perform application testing prior to deployment ensuring users receive a working product.
10. Create and update online training information for the district's student information system on the District website.
11. Import student test results into the student information system as required by the immediate supervisor.
12. Modify graduation requirements definition in student information system to incorporate changing requirements as required by immediate supervisor.
13. Validate and load student picture files.
14. Maintain student information system home school catchment area mappings. Debug problems with home school catchment area mappings.
15. Reconcile periodically interfaces among the various data sources in the District including transportation, food services, special education, assessment, curriculum and instruction with the student information system and resolves any issues.
16. Conduct imports and exports of data from NJSMART and student information system, including updating SIDs and SMID while resolving errors.
17. Maintain security for all databases.
18. Monitor student information system performance.
19. Monitor source data for accuracy, completeness and integrity. Suggest changes to ensure and enhance data quality.
20. Develop and maintain knowledge through a range of professional development activities, including relevant webinars and training.
21. Perform other related duties as assigned by the immediate supervisor.

EMPLOYMENT TERMS:
The Data and Student Information Analyst/Programmer shall be employed under the following terms:

1. Work year of twelve months.
2. Salary, benefits and leave time as specified in the TB&T Collective Bargaining Agreement.
3. Conditions established by laws and codes of the State and policies, rules and regulations established by the Board of Education (N.J.S.A 18A:27-4 et seq.).

EVALUATION:
The Database Analyst shall be evaluated in accordance with Board of Education Policy.

Board Approval Date - August 22, 2022 BUSINESS AND TECHNICAL Amended - November 14, 2022

For more information on this position, please read the full description document.

• Database Analyst.pdf