<p>Overview</p> <p>The Assessment Division at the Agency of Education (AOE) is seeking a Data Analyst to support the collection, management, analysis, and reporting of state assessment data in accordance with state and federal requirements. Results from state assessments play an essential role in Vermont's educational system by supporting school accountability, guiding the monitoring of school and district performance, identifying achievement gaps, and enhancing public transparency.</p> <p>Given the high-stakes nature of this work, the successful candidate will demonstrate a strong commitment to data quality, meticulous attention to detail, and excellence in core data science practices. Because the division's methodologies are fully transparent and many data products are publicly accessible, all outputs must be accurate, reliable, and error-free. In addition, the role involves handling sensitive information and therefore requires strict adherence to data privacy and security protocols.</p> <p>Primary Responsibilities:</p> <ul> <li>Collaborate with assessment vendors to support all data-related components of assessment administration. </li><li>Maintain and integrate assessment data into the State Longitudinal Data System (SLDS) using SQL and secure ETL processes. Ensure accurate student matching, historical continuity, and archival storage for analysis and reporting. </li><li>Prepare and validate assessment data files for public and field reporting, including disaggregation by student group, school, and assessment program. </li><li>Conduct User Acceptance Testing on assessment vendor dashboards and internal AOE tools used for reporting. Verify accuracy, accessibility, and alignment with business rules, log issues and track vendor corrections through resolution. </li><li>Perform data stewardship activities by maintaining clear documentation and business rules for assessment and accountability processes, including data dictionaries, calculation methodologies, and crosswalks for both public use and internal audit. </li></ul> <p>Ideal Candidate Qualifications:</p> <ul> <li>Proficiency in data management, analysis, and reporting of assessment and accountability data, including support for ad hoc requests such as public records requests. </li><li>Strong working knowledge of data manipulation tools and environments (e.g., SQL Server; notebook-based development environments such as JupyterLab/Python or Databricks). </li><li>Experience using statistical analysis tools (e.g., SSMS, R) for data processing and reporting. </li><li>Demonstrated experience handling sensitive data responsibly and </li></ul>