Education Finance Data Analyst

State of Vermont; Montpelier (VT); On-site; USD 70,000 - 110,000; Full time

Benefits offered by this job

Health benefits

Dental plan

Paid holidays

FMLI

Pension & 457(b)

Tuition reimbursement

Flexible spending accounts

Wellness program

Public Service Loan Forgiveness

Job summary

The Vermont Agency of Education seeks a detail‑oriented finance and data professional to support statewide education finance operations through financial analysis, data management, and reporting.

This role collects, validates, and maintains school district financial and HR data, builds dashboards with Power BI, SQL, and Excel, and prepares datasets and reports for Agency leadership, legislative requests, and public transparency.

Qualifications

• Bachelor's degree or higher in accounting, business administration, finance, economics, statistics, or related field and one or more years of experience in finance, fiscal analysis, budgeting, or related field.
• OR Five or more years of experience in finance, fiscal analysis, budgeting, or related field.
• Experience with project management and coordination.
• Experience in school district or public sector finance.
• Experience with financial or ERP systems (e.g., eFinancePlus, Tyler ERP).
• Experience with data tools such as Power BI, SQL, or Power Query.
• Experience supporting data collection, validation, and reporting processes.

Responsibilities

• Collect, validate, and maintain school district financial and human resources data in accordance with Vermont's Uniform Chart of Accounts (UCOA) standards and established reporting requirements.
• Conduct data quality assurance reviews, identify discrepancies, and work collaboratively with school districts to improve the accuracy, completeness, and consistency of reported information.
• Analyze financial and operational data to identify trends, support education finance reporting, and inform Agency decision-making and policy development.
• Develop, maintain, and improve data systems, queries, and reporting tools using Excel, SQL, Power BI, and similar platforms to support efficient data collection, analysis, and reporting.
• Prepare datasets, financial summaries, and reports to support Agency leadership, legislative requests, state and federal reporting requirements, and public transparency.
• Support the development and maintenance of public-facing financial reports and data tools, with an emphasis on improving data accessibility, usability, and understanding.
• Provide technical assistance and guidance to school district business and human resources personnel on financial reporting requirements, data submissions, and UCOA standards.
• Develop and maintain standard operating procedures, technical guidance, and training resources to promote consistent data collection, validation, and reporting practices.
• Collaborate with Agency staff, school districts, and state partners to strengthen data integrity, streamline reporting processes, and identify opportunities for continuous improvement.
• Support special projects, research, and ad hoc financial analysis to address emerging education finance needs and Agency priorities.

Skills

Power BI

SQL

Power Query

Financial analysis

Budgeting

Data management

ERP systems

Attention to detail

Collaboration

Education

Bachelor's degree or higher in accounting, business administration, finance, economics, statistics, or related field

Tools

Excel

eFinancePlus

Tyler ERP

Power BI

Job description

The Vermont Agency of Education seeks a detail‑oriented finance and data professional to support statewide education finance operations through financial analysis, data management, and reporting.

This role collects, validates, and maintains school district financial and HR data, builds dashboards with Power BI, SQL, and Excel, and prepares datasets and reports for Agency leadership, legislative requests, and public transparency.