Academic Budget & Analytics Analyst

Stony Brook; Stony Brook (NY); On-site; USD 60,000 - 80,000; Full time

Benefits offered by this job

Location pay

Job summary

Stony Brook University’s Office of the Provost seeks a Senior Staff Assistant to provide analytical, operational, and financial reporting support. You will work with the Academic Budget and Finance team to manage budget tracking, forecasting, and analytics.

The role involves dashboards, data validation, and collaboration with academic units to ensure fiscal accountability. The position requires a Bachelor's degree and 3+ years of finance-related experience, strong Excel skills, and the ability

Qualifications

• Bachelor's degree in Accounting, Finance, Business Administration, Economics, Information Systems, Public Administration, or related analytical field.
• Three (3) years of full-time professional experience in financial analysis, accounting, financial operations, data analysis, or related admin functions.
• Advanced proficiency in Microsoft Excel incl. complex formulas, lookup, pivot, macros, data validation, and financial modeling.
• Experience analyzing large data sets and compiling summary reports for management.
• Strong written and verbal communication skills to convey financial concepts to non-financial stakeholders.

Responsibilities

• Support monthly, quarterly, and rolling forecast updates by gathering unit inputs and verifying data integrity.
• Perform monthly budget-to-actual and variance analysis; identify cost drivers and draft explanations for material discrepancies.
• Maintain and update financial models; verify formulas and data linkages across multi-department feeds.
• Assist in developing driver-based financial models and scenario analyses for unit initiatives.
• Design and maintain dashboards and templates (Power BI, Tableau, Excel) to track KPIs across Academic Affairs.
• Monitor spending trends to flag potential overruns and cost-containment opportunities.
• Assist in preparing executive briefing decks and narrative summaries for leadership.
• Serve as a primary contact for routine ad-hoc financial reporting requests.

Skills

Advanced Excel

Financial analysis

Budgeting

Data visualization

Stakeholder communication

Education

Bachelor's degree in accounting/finance/business

Tools

Power BI

Tableau

SQL

Job description

Stony Brook University’s Office of the Provost seeks a Senior Staff Assistant to provide analytical, operational, and financial reporting support. You will work with the Academic Budget and Finance team to manage budget tracking, forecasting, and analytics.

The role involves dashboards, data validation, and collaboration with academic units to ensure fiscal accountability. The position requires a Bachelor's degree and 3+ years of finance-related experience, strong Excel skills, and the ability