Database & Information Specialist

Background on Southbridge Public Schools:

Southbridge Public Schools serve approximately 2,200 students in six schools. The district is presently undergoing extensive turnaround at all levels, with the assistance of the Massachusetts Department of Elementary and Secondary Education. This creates unique opportunities for teachers and students. One example is a recently announced, long-term partnership with the University of Connecticut to develop Southbridge Schools to be a national demonstration site for successful implementation of PBIS strategies. Additionally, our district is the recipient of a number of significant grants that are allowing us to creatively redesign Secondary School, curriculum enhancements, improved culture and climate and afterschool opportunities for students. If you feel strongly about improving the educational experience for students and have a commitment to social justice, Southbridge Public Schools welcomes you.

Job description

The Southbridge Public Schools data department is looking for a candidate to help contribute to development of clean, automated, and sustainable data systems. This role will be responsible for maintaining the data quality housed in our student information system. This will include cleaning current data, reforming data input processes to ensure clean data entry, as well as creating data validations within the database to ensure the sustainability of clean data. This role will also be responsible for rostering and managing our various online data sources (ex: McGraw Hill, HMH, Clever, etc). The candidate will be expected to work with a team to troubleshoot the day-to-day SIS data errors, errors in integrations with data sources, rostering issues, etc.

Responsibilities

Data Management

• Clean current SIS data
• Reform current data input systems for cleaner data entry
• Create data validations to ensure the sustainability of clean data
• Support master scheduling at all school levels (Elementary and Secondary)

Managing Rostering Data/Data Integrations

• Regularly update data sources with rostering data
• Clean up other data sources in preparations for integrations (ex: iReady, Naviance, OneCall, etc.)
• If capable, create integrations between data sources
• Ensure all relevant student data from Aspen student information system is maintained in external sources (iReady, McGraw Hill, HMH, ect.)

Ad Hoc/ Day-to-Day Requests

• Troubleshoot day to day rostering data issues including student and teacher access, data quality, and updated rosters
• Assist with the day-to-day requests for access to SIS and other data sources for staff, partners, students, and family

Expected Knowledge & Skills

• Bachelor's Degree
• Beginner to intermdediate level of background in Student Information Systems (Aspen preferred) or other databases
• Knowledge of data quality best practices
• Intermediate level of background in Excel, Google Sheets, Access or something similar (including writing formulas and utilizing pivot tables)
• An understanding of Clever or other educational technology data integration services
• Strong fluency in Google Suite
• Ability to work independently and provide technical leadership on data quality issues
• Solid organizational skills and ability to manage multiple tasks and assignments
• Ability to assess quantitative and qualitative data

Preferred Knowledge & Skills

• Follett/Aspen SIS
• Ability to develop code to integrate data sources
• An understanding of Massachusetts data expectations for state reporting
• Beginner level of SQL

Equal Opportunity Employer

Southbridge Public Schools is committed to maintaining a work and learning environment free from discrimination on the basis of race, color, creed, national origin, sex, gender identity, disability, religion, age, or sexual orientation.