Education Data Analyst II

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.

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.

Primary Responsibilities:

• Collaborate with assessment vendors to support all data-related components of assessment administration.
• 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.
• Prepare and validate assessment data files for public and field reporting, including disaggregation by student group, school, and assessment program.
• 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.
• 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.

Ideal Candidate Qualifications:

• Proficiency in data management, analysis, and reporting of assessment and accountability data, including support for ad hoc requests such as public records requests.
• Strong working knowledge of data manipulation tools and environments (e.g., SQL Server; notebook-based development environments such as JupyterLab/Python or Databricks).
• Experience using statistical analysis tools (e.g., SSMS, R) for data processing and reporting.
• Demonstrated experience handling sensitive data responsibly and applying privacy protection techniques (e.g., suppression, blurring, anonymization).
• Familiarity with educational assessment data and its uses.

This position is required to work in office a minimum of three days per week.

This position, Education Data Analyst II (Job Requisition #53972), is open to all State employees and external applicants.
If you would like more information about this position, please contact Danielle Dupuis at danielle.dupuis@vermont.gov.
Resumes will not be accepted via e-mail. You must apply online to be considered.

Normal office working conditions generally prevail, with remote work conditions a possibility for this role if approved by the Division Director. Incumbent must be able to interact, work, and deal with Agency staff, educators, state, federal, and local officials, and the general public. Evening and weekend work may be required.

Bachelor's degree or higher in social science, mathematics, statistics, data science, or related field AND one (1) year or more at a professional level in quantitative research, statistics, data analysis, data science, or program evaluation.
OR
Three (3) years or more of at a professional level in quantitative research, statistics, data analysis, data science, or program evaluation.

As a State employee you are offered a great career opportunity, but it's more than a paycheck. The State's total compensation package features an outstanding set of employee benefits that are worth about 30% of your total compensation, including:

• 80% State paid medical premium and a dental plan at no cost for employees and their families
• Work/Life balance: 11 paid holidays each year and a generous leave plan
• State Paid Family and Medical Leave Insurance (FMLI)
• Two ways to save for your retirement: A State defined benefit pension plan and a deferred compensation 457(b) plan
• Tuition Reimbursement
• Flexible spending healthcare and childcare reimbursement accounts
• Low cost group life insurance
• Incentive-based Wellness Program
• Qualified Employer for Public Service Student Loan Forgiveness Program

Want the specifics? Explore the Benefits of State Employment on our website.

The State of Vermont celebrates diversity, and is committed to providing an environment of mutual respect and meaningful inclusion that represents a variety of backgrounds, perspectives, and skills. The State does not discriminate in employment on the basis of race, color, religion or belief, national, social or ethnic origin, sex (including pregnancy), age, physical, mental or sensory disability, HIV Status, sexual orientation, gender identity and/or expression, marital, civil union or domestic partnership status, past or present military service, membership in an employee organization, family medical history or genetic information, or family or parental status. The State's employment decisions are merit-based. Retaliatory adverse employment actions by the State are forbidden.