School Finance Data Analyst

Support statewide school finance data collection, validation, audit review, and reporting across Colorado school districts and BOCES.

• Finance December data collection support: review, validation, reconciliation, analysis, and quality assurance of financial information submitted by school districts and BOCES
• Data issue resolution: work with district financial staff to correct data errors, reporting inconsistencies, and reconciliation issues to ensure accurate and complete reporting
• Maintain statewide financial data assets: keep financial datasets, documentation, business rules, edits, and reports aligned with statewide financial data collections
• Audit comparison and discrepancy identification: review district and BOCES annual financial audits and compare audit information with Finance December and other financial data to flag discrepancies, compliance concerns, and unusual financial conditions
• Track and resolve audit findings: assist with identifying, documenting, tracking, and resolving Material Deficiencies, Late Filings, and other audit or reporting findings
• Fiscal monitoring and early warning support: support financial accreditation, fiscal monitoring, and district fiscal health and early warning activities using audit, financial, and other available data
• Recurring reporting: prepare, validate, and support state and federal financial reports, including National Public Education Finance Survey, U.S. Census reporting, financial transparency reporting, and assigned indirect cost calculations
• Reporting to stakeholders: prepare statewide and district-level reports and respond to internal and external requests for school finance and financial data
• Financial analytics: analyze district revenues, expenditures, fund balances, staffing, and other fiscal indicators using historical, comparative, and trend analysis
• Policy and legislative analysis support: assist with analysis of legislative and policy proposals and connect district financial data with enrollment, school finance funding, and operational information
• Build reporting tools: develop reports, analytical tools, and resources to make financial information accessible to districts, CDE leadership, and other stakeholders
• Technical assistance and training: provide direct guidance and training to districts and BOCES on Finance December, Chart of Accounts, financial transparency, audits, and other financial reporting requirements
• Documentation and SOPs: develop and maintain written guidance, training materials, standard operating procedures, and documentation for assigned responsibilities
• Quality assurance and cross-training: participate in cross-training, quality assurance, and peer review for backup coverage and accuracy of critical reports

Requirements

• Bachelor’s degree from an accredited institution in finance, accounting, economics, business administration, public administration, public policy, education, data analysis, or a related field
• Relevant professional experience may substitute for education as permitted by CDE and State of Colorado personnel requirements
• Experience: 1–3 years working with complex data sets
• Experience: 1–3 years working in a financial setting
• Experience: 1–3 years working in governmental accounting, finance, public policy, auditing, or a related field
• Software: intermediate to advanced Microsoft Excel proficiency; experience working with financial or other complex datasets
• Experience performing financial, fiscal, data, and/or policy analysis
• Ability to learn and apply complex financial formulas and statutory requirements
• Ability to work independently and without supervision
• Experience analyzing, interpreting, recommending, or implementing policies and procedures
• Experience or interest in creating, developing, or refining standard operating procedures
• Strong attention to detail; ability to identify inconsistencies in data and calculations
• Ability to perform calculations, reconciliations, projections, and data quality reviews accurately
• Ability to manage multiple projects, recurring processes, and quickly changing priorities
• Strong customer service skills and professional communication with internal and external stakeholders
• Ability to explain complex financial or technical topics to non-financial audiences
• Strong written and verbal communication skills
• Demonstrated problem-solving skills, including independent research and issue resolution
• Must be willing and able to submit to pre-screening and pass a background check
• Ability and willingness to independently determine, obtain means, and complete required travel

Technologies

• Microsoft Excel
• PivotTables
• XLOOKUP

Benefits

• Flexible work schedules and flexible workplace options, which may include flexible working hours, working from home, working in the office, and/or hybrid options
• Premier medical, dental, vision, and dependent life insurance with generous employer contribution
• Employer-paid short-term disability and life insurance
• Up to 160 hours of Paid Family Medical Leave (PFML)
• 11 paid holidays per year
• Competitive vacation and sick leave accruals
• Retirement through PERA (www.copera.org)
• Employer-paid RTD Eco Pass (certain restrictions may apply)
• Paid professional development opportunities

Work Environment

• Full-time position, funded by state funding (funding contingent upon availability)
• Eligible for hybrid work environment
• Extended hours during the evening or weekend may be required by business needs
• 5% travel within Denver Metro/Downtown for meetings/training
• Remote (home) office required
• Required to report to the work location per business needs

Essential Functions (ADAAA)

• Required to sit, view a computer screen, and use a keyboard and mouse for extended periods
• May be required to lift and move up to 10 lbs of force frequently or 20 lbs occasionally
• Required lifting, bending, stooping, pushing, walking, etc.
• Light work usually requires walking or standing to a significant degree
• Required to independently obtain and determine means to complete travel requirements

Preferred Qualifications

• Experience in K–12 school finance, governmental accounting, or public-sector financial reporting
• Experience reviewing financial statements, audits, and identifying financial discrepancies
• Advanced Microsoft Excel skills, including PivotTables, XLOOKUP, and complex formulas
• Experience with SQL, Power BI, Tableau, or similar data analysis tools
• Experience in financial data collection, reconciliation, quality assurance, and regulatory reporting

Application Notes

• Only completed applications received by the deadline will be considered for review
• After the posting closes, applications will be reviewed and selected candidates will be contacted for interviews
• HR does not use AI to scan for MQs
• Complete application must include: Completed Online Application submitted through the ATS
• Complete application must include: Resume attached as a separate document
• Complete application must include: Supplemental Question answered completely; responses such as “See Work History” or “See attached resume” will be disqualified
• College transcripts: If using education to qualify, submit a legible copy of official or unofficial college transcript(s) or a foreign credential evaluation report with the application
• Failure to submit a complete application by the announcement close may remove the application from consideration
• Transcript note: Applicants may redact information identifying age, date of birth, or dates of school attendance or graduation
• Resumes and Cover Letters will not be reviewed for minimum qualification screening
• Include a working email address; status correspondence will be conducted via email