Student Records System Specialist - Data & SIS Expert

Information Management Services; Grandview (MO); On-site; USD 61,000 - 88,000; Full time

Job summary

Information Management Services in Grandview, Missouri is seeking an IT Services Student Records System Specialist to manage and support the district’s student records system. You will coordinate configuration, data quality, user support, reporting, training, and process improvement to ensure consistent records across the lifecycle.

The role requires an associate degree with experience in Focus School Software or similar SIS, strong SQL skills, and the ability to collaborate with educators and

Qualifications

• Associate degree in information technology, business information systems, education technology, data management, or a related field; bachelor's degree preferred.
• Three years of relevant experience supporting a student information system, enterprise application, database, or comparable environment; equivalent combinations of education and experience may be considered.
• Working knowledge of relational databases and SQL, including the ability to query, validate, analyze, and safely update data.
• Experience with data imports, exports, scheduled jobs, APIs, SFTP transfers, and third‑party system integrations is preferred.
• Demonstrated ability to analyze data, troubleshoot software issues, document procedures, train users, and communicate effectively with technical and non‑technical staff.

Responsibilities

• Maintains up-to-date knowledge and documentation regarding the District student records system, related modules, interfaces, workflows, data standards, procedures, training materials, data dictionaries, logs, and audit records.
• Database and reporting-Develops, maintains, tests, and documents SQL queries, district reports, extracts, validation reports, and authorized data‑correction processes.
• Focus configuration-Configures and maintains Focus modules, system preferences, schools, calendars, marking periods, grading scales, enrollment settings, permissions, profiles, custom fields, scheduled jobs, and district‑defined workflows.
• Integrations-Administers and monitors integrations between Focus and systems used for identity management, learning management, assessment, transportation, food service, library services, communications, state reporting, and other District operations.
• Data‑quality monitoring-Establishes repeatable validation processes to identify missing, duplicate, inconsistent, or invalid records and coordinates corrections with the appropriate data owners.
• Change control and testing-Tests system updates, configuration changes, reports, integrations, and data corrections in an appropriate test environment before production implementation; maintains change documentation and rollback procedures when applicable.
• Security administration-Maintains role‑based access, user profiles, school assignments, and permissions using the principle of least privilege; periodically reviews access and promptly addresses inappropriate or outdated permissions.
• State and federal reporting-Supports the preparation, validation, correction, and submission of required state and federal student‑data reports in collaboration with the departments responsible for reported data.
• Vendor coordination-Serves as the primary technical liaison with Focus School Software and other vendors; submits and tracks support requests, evaluates vendor recommendations, and coordinates issue resolution.
• Operational monitoring-Monitors scheduled reports, automated updates, integrations, imports, exports, and other recurring processes; investigates failures and verifies successful completion.
• Documentation-Maintains configuration records, data dictionaries, integration specifications, SQL documentation, annual processing checklists, troubleshooting guides, and administrative procedures.
• Business continuity-Develops procedures that allow critical SIS operations to continue during staff absences, outages, system changes, or other interruptions.
• Availability expectations - Provides limited after‑hours support for critical upgrades, annual rollover, system outages, and time‑sensitive reporting deadlines.
• Provides telephone, digital, and in‑person assistance to school and district personnel; investigates service requests, identifies root causes, recommends solutions, and coordinates resolution with internal staff and vendors.
• Monitors the accuracy, completeness, consistency, and timeliness of student data and works with schools and departments to correct errors and strengthen data‑entry practices.
• Supports student records processes including enrollment, registration, demographic updates, attendance, scheduling, grades, transcripts, withdrawals, promotions, and graduation records, as assigned.
• Maintains system security and confidentiality by applying appropriate access controls, protecting personally identifiable information, and supporting compliance with Board policy and applicable student privacy requirements.
• Coordinates imports, exports, integrations, data exchanges, and interfaces between the student records system and other District applications.
• Plans and performs system updates, testing, annual rollover activities, school‑year setup, and other scheduled maintenance in collaboration with Information Technology Services and District departments.
• Supports the delivery of training, written instructions, notices, reminders, and reference materials for new and existing users; participates in meetings, workshops, and professional learning to communicate system changes and support consistent District practices.
• Prepares reports, extracts, and data files for authorized staff while ensuring appropriate review and protection of student information.
• Collaborates with school administrators, registrars, counselors, attendance staff, special programs, curriculum, assessment, finance, human resources, and other departments whose work depends on student data.
• Identifies opportunities to streamline records‑management processes, improve data quality, reduce duplicate entry, and increase the effective use of the student records system; maintains relevant certifications and stays abreast of current practices and technology developments.
• Performs other duties as assigned by the Information Technology Services Director.

Skills

SQL

Databases

Focus SIS

Data integration

Troubleshooting

User training

Communication

Education

Associate degree

Bachelor’s degree preferred

Job description

Information Management Services in Grandview, Missouri is seeking an IT Services Student Records System Specialist to manage and support the district’s student records system. You will coordinate configuration, data quality, user support, reporting, training, and process improvement to ensure consistent records across the lifecycle.

The role requires an associate degree with experience in Focus School Software or similar SIS, strong SQL skills, and the ability to collaborate with educators and