The Educational Specialist is responsible for the maintenance and validation of the school's System-wide data related to student information in order to ensure compliance. This includes maintaining and verifying student information in multiple software applications such as the school's system’s student information software, SIS program (PowerSchool), and any additional software applications required to ensure accurate student information. This will include working with data types such as, as identified by the Data and Reporting Center. The Data Specialist will attend required training, train other staff members and will run district queries, coordinate programming needs and will work to resolve issues as well as creating reports and queries in Access.
ESSENTIAL DUTIES AND RESPONSIBILITIES:
- Attends IT training to represent the department and bring back information
- Assists with or does training for Office Staff, campus data teams, Special Education teachers and others as needed
- Takes the Lead on any data entry issues and audits the data prior to distributing it to staff
- Works with the programmer to create queries and reports that make data entry more efficient
- Runs reports for the entire system that monitor student data in the student information software
- Monitors Validation reports for the entire system from the student information software ensures that data errors are corrected in a timely manner.
- Validates student needs data system-wide in all software applications required to maintain and process such information.
- Confirms all student testing results for all campuses are entered into software solution (TBD) and runs queries to validate that those scores have been entered into the student information software.
- Runs system-wide Data reports and compares them to Synergy, breaks queries apart for individual schools
- Isolates errors and provides solutions related to student needs in the Student Information software
- Performs error checking processes on all related student data and assists school campuses with validation reports and corrections. Location of specific assignments will be made based on the dynamically changing state of the system-wide student data.
- Works with all persons responsible for data collection (Data contact and data teams at each campus)
- Assists with system-wide and campus-based Assessments as needed
- Execute all regular transaction processes necessary to maintain operations, records and databases.
- Perform extracting, importing and exporting of data in various database applications.
- Assist in the implementation, testing and validation of data and software systems.
- Perform data analysis of key problem areas to assist in root cause analysis.
- Audit data on a regular basis to ensure data integrity and quality.
- Assist with ongoing data architecture processes and governance.
- Research and collect data to assist with product development and analysis.
- Train staff and business as necessary for data operational activities.
- Perform data reconciliations to identify data anomalies.
- Escalate data issues needing process re-engineering.
- Perform data quantitative and qualitative analysis.
- Assist in preparation of data reports, training materials, business presentations, publications, marketing collaterals and other educational materials.
- Assist in the maintenance, back up and security of business data.
MINIMUM EDUCATION AND/OR EXPERIENCE:
- BA
- Microsoft Access and Advanced Excel experience
- Microsoft SQL Queries
- ORACLE PL-SQL Queries
- Experience dealing with educational data
- Ability to work under strict deadlines
- Experience and knowledge in working with Student
- Records reporting.
PREFERRED EDUCATION AND/OR EXPERIENCE:
- 5 years’ experience working in a Microsoft applications environment preferred. (Ex: Word, Excel, and Access)
- 5 years’ experience working with Student Management Software
- 2 years’ experience working with BI tool and Cubes
- 2 years’ experience working with Database queries
PACKAGE: