Sr. Fiscal Analyst - Massachusetts Department of Elementary and Secondary Education

The Office of District and School Finance (ODSF) administers state aid and reimbursement programs and provides technical support to local districts in the areas of accounting, auditing, budgeting and financial reporting. The person who holds this position is responsible for a number of fiscal oversight, data management, and data analysis functions in the unit.

The Sr. Fiscal Analyst manages the inter-district school choice program. This includes calculating school choice tuitions at the start of each fiscal year, updating these projections in December based on October 1 enrollment data, reviewing school choice claim forms and special education increment forms each spring to finalize tuition payments for the year, and responds to questions from the field. The Sr. Fiscal Analyst will recommend and implement changes to improve the administration of the program.

The selected individual will successfully execute the following duties:

  • Manage the unit’s End of Year Report (EOYR) data, which is the expenditure report that school districts submit each year;
  • Develop EOYR workbooks and reviewing EOYR submissions;
  • Manage the Access database used to maintain and analyze EOYR data, including troubleshooting and writing Visual Basic routines;
  • Play a significant role in ongoing efforts to improve the EOYR collection process, including making changes to the data that we collect, how we collect it, and how we manage it;
  • Recommend and develop new data visualizations using finance, staffing and enrollment data that take advantage of tools such as Tableau or Power BI to help district leaders make more informed resource allocation decisions;
  • Implementation of the recently enacted Student Opportunity Act (SOA), which significantly expands state aid for school districts and requires the Department to implement a number of changes to the Chapter 70 program;
  • Support annual calculation of the Chapter 70 formula;
  • Contribute to developing and implementing a new methodology for counting low income students;
  • Expand the Department’s capacity to respond to a number of other provisions in the law, including supporting the Data Advisory Commission and Rural Policy Advisory Commission and studying the impact of our current method for determining local contribution requirements;
  • Provide direct support to our regional governance program unit, including analyzing expenditure and budget data to respond to questions related to the administration of regional school district agreements; and
  • Review charter school enrollment data in support of calculating annual charter school tuition payments and reimbursements.

Preferred Qualifications:

The successful individual will possess the following qualifications:

  • Strong interest in education and school finance issues;
  • Strong data management and analysis skills, including expert knowledge and skills with Excel and Access, including writing Visual Basic macros;
  • Strong communication skills (both written and verbal);
  • Ability to communicate effectively with a wide variety of audiences, including state policy makers, agency leaders, district leaders, and the general public;
  • Ability to analyze, synthesize, and communicate complex information to a wide range of audiences;
  • Knowledge of finance principles and practices and methods of general report writing;
  • Experience in local or state government budget planning or administration;
  • Experience and ability in interpreting legislative and regulatory language;
  • Ability to read and interpret data, including financial reports, accounts and ledgers, economic indicators, and student enrollment and demographic data, to draw conclusions and made recommendations;
  • Ease in dealing with a wide range of local, state, and federal officials, researchers, and the general public;
  • Ability to prioritize tasks and meet deadlines without sacrificing accuracy;
  • Fluency in basic statistics, measures of central tendency, range and longitudinal comparisons;
  • Experience using data management and visualization tools like Tableau and Power BI;

**Questions regarding this posting or the application process should be referred to Dawn DeRoche at dderoche@doe.mass.edu or 781-338-6101.

Qualifications

MINIMUM ENTRANCE REQUIREMENTS:

Applicants must have at least (A) five (5) years of full-time or, equivalent part-time, professional, professional internship, administrative, supervisory, or managerial experience in financial management work (i.e. budgeting, accounting, auditing, management analysis, program evaluation, financial reporting of program results) or (B) any equivalent combination of the required experience and substitutions below

Substitutions:
I. A certificate in a relevant or related field may be substituted for one (1) year of the required experience.
II. A Bachelor’s degree in a related field may be substituted for two (2) years of the required experience.
III. A Graduate degree in a related field may be substituted for three (3) years of the required experience.
IV. A Doctorate degree in a related field may be substituted for the four (4) years of the required experience.

Click here for more information on how to apply.