Job Description
We work to build the capacity of schools to use information and technology, maintain network infrastructure, security standards, and support other departments to meet district goals. We provide innovative technology solutions that improve students' education quality, reduce the administrative burden on educators, facilitate parent interaction, increase community engagement, and support mission of transparency by focusing on the ease and equity of access to information.
The SIS Data Analyst is responsible for the extraction, analysis, and validation of data within the student information suite. This role focuses on ensuring the integrity and accuracy of data within the Aspen SIS ecosystem. You will lead efforts to translate complex student data into actionable insights, providing critical support for state reporting, district compliance, and school- level decision-making. This position requires an expert-level understanding of data structures and SQL to support the evolving informational needs of the district.
The SIS Data Analyst will be held accountable for the following responsibilities:
-
Data Analysis & Validation: Perform deep-dive analysis of student data within SIS systems to identify trends, anomalies, and areas for data quality improvement.
-
SQL Query Development: Design and execute complex SQL queries to extract data from the SIS for various stakeholders and federal/state reporting requirements.
-
Requirements Gathering: Partner with SIS business analysts, departmental data analysts, and school administrators to define data needs and perform requirements analysis to satisfy informational requests.
-
Data Integrity Oversight: Research and design procedures and data validation checks that improve the overall data health of the SIS environment.
-
Documentation: Clearly document data definitions, extraction logic, and analysis methodologies to ensure consistency across the ITS department.
-
Collaboration: Meet with Data Managers and ITS leadership to discuss the scope of data projects and ensure alignment with organizational goals.
-
Translate technical findings into plain-language reports and presentations for non- technical stakeholders, such as school principals, board members, and parent organizations.
-
Lead state and federal reporting efforts, ensuring that district data submitted for funding and accountability (e.g., Title I, Special Education) meets strict accuracy and formatting standards.
-
Audit data entry workflows within the SIS to identify root causes of data errors and recommend training or system validations to improve data quality at the source.
-
Uphold FERPA and local privacy standards by ensuring that all reports and data exports follow "least privilege" principles and de-identification protocols.
-
Perform longitudinal studies to evaluate the effectiveness of district-wide initiatives
-
Conduct ad-hoc analysis to respond to urgent district needs, such as analyzing the impact of school boundary changes or shifts in student demographics.
-
Document and communicate about data lineage and the transformations that can and do occur between data systems, across time periods, and with changing business processes..
-
Develop software testing and quality assurance plans, and execute quality assurance tests in collaboration with internal and external stakeholders.
-
Provide data-related support for users and user groups, proactively identifying data challenges and resolving application data and configuration issues.
-
Produce historical and predictive analyses of the effects on data quality and usage based on changing business policies and practices.
Knowledge, Skills, and Abilities:
-
Advanced proficiency in SQL database programming and data manipulation is required. XML, JSON, proficiency preferred.
-
Experience with data visualization and reporting toolkits such as PowerBI, iReport/JasperReports or similar platforms.
-
Familiarity with SQL technology stacks and understanding of relational and dimensional database structures.
-
Deep understanding of data lifecycles and Agile methodologies, focusing on accuracy and timely delivery, and with a keen understanding of the monitoring, maintenance, stewardship, accessibility, protections, guardrails, and business processes needed to ensure high quality data.
-
Ability to work with, combine, and compare data in multiple data formats
-
Curiosity and "Detective" Thinking - in a distributed system of applications, the "why" behind a problem is rarely on the surface.
-
Soft Skills: Excellent verbal and written communication, particularly in translating technical data findings into non-technical language; strong problem-solving skills under pressure.
Education & Experience:
-
College Bachelor's Degree with an IT, Statistics, or Data Analytics concentration.
-
Minimum of five (5) years of experience in data analysis or application support.
-
Minimum of three (3) years of experience performing systems or data analysis within a large-scale enterprise environment.
-
Minimum of 2 yrs experience with Agile management tools like Jira or Azure DevOps
Never miss an opportunity! Create an alert based on the job you applied for.
