Data Analyst

Data Analyst

Job Description

Remote

Description:


The Data Analyst is responsible for the extraction, analysis, and validation of data within the client information suite. This role focuses on ensuring the integrity and accuracy of data within the Aspen 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 client.
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.
Other Duties: Perform additional data-related duties as assigned to support the SIS ecosystem.

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

Education: College Bachelor’s Degree with an IT, Statistics, or Data Analytics concentration.
Experience: 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

Notes:
Remote

VIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status