Financial Analyst

SBHU

Stony Brook (NY)

On-site

USD 75,000 - 87,000

Full time

4 days ago

Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Location pay

Job summary

Stony Brook University seeks a Financial Analyst to support the Provost’s Academic Budget and Finance team. The role combines financial analysis, forecasting, and reporting to inform university-wide decisions.

Responsibilities include maintaining models, driving variance analyses, and creating dashboards with Power BI, Tableau, and Excel. A Bachelor’s degree plus several years of experience in finance or accounting is required.

Qualifications

Bachelor's degree in a related analytical field.
3 years of professional experience in financial analysis, accounting, or related functions.
Advanced Excel skills including formulas, lookups, pivots, macros, and financial modeling.
Experience analyzing large data sets and preparing management reports.

Responsibilities

Support monthly, quarterly, and rolling forecast updates.
Perform variance analyses and explain material discrepancies.
Maintain financial models and data linkages across multiple feeds.
Develop driver-based models and scenario analyses for initiatives.
Design dashboards and reporting templates (Power BI, Tableau, Excel).
Monitor spending trends to flag overruns and opportunities.
Prepare executive briefing materials and reports for leadership.
Provide ad-hoc financial reporting across academic units.

Skills

Financial analysis

Financial modeling

Data analysis

Verbal & written communication

Data visualization

Education

Bachelor's degree in Accounting, Finance, Business Administration, Economics, Information Systems, Public Administration, or related analytical field

Tools

Power BI

Tableau

SQL

ERP systems (Oracle, PeopleSoft, Banner, Workday)

Job description

Financial Analyst

Who We Are

The Office of the Provost Academic Budget and Finance Team is a collaborative, high-performing group dedicated to supporting the university’s academic mission through strategic financial management, planning and analysis. We foster a positive, fast-paced work environment where innovation, teamwork, and continuous learning are encouraged. Team members benefit from meaningful project ownership, exposure to university leadership and strategic initiatives, and a strong commitment to professional development. This is an excellent opportunity for individuals seeking to expand their expertise, build cross-campus relationships, and grow their careers while contributing to impactful institutional decisions.

Required Qualifications (as evidenced by an attached resume):

Bachelor’s degree (foreign equivalent or higher) in Accounting, Finance, Business Administration, Economics, Information Systems, Public Administration, or a related analytical field. Three (3) years of full-time professional experience in financial analysis, accounting, financial operations, data analysis, or related administrative functions. Experience working with financial systems, relational databases, and enterprise reporting tools. Advanced proficiency in Microsoft Excel, including complex formulas, lookup functions, pivot tables, macros, data validation, and financial modeling. Demonstrated experience analyzing large, complex data sets and compiling summary reports for management. Strong written and verbal communication skills, with the ability to convey financial concepts to non-financial stakeholders.

Preferred Qualifications:

Four (4) or more years of full time experience in higher education finance, fund accounting, or a large, complex public institution. Experience utilizing enterprise resource planning (ERP) systems (e.g., Oracle, PeopleSoft, Banner, Workday). Familiarity with SUNY financial systems, state finance structures, or Research Foundation processes. Hands-on experience with business intelligence software (e.g., Power BI, Tableau) or querying tools (SQL). Experience with business process analysis, workflow optimization, or financial system implementations.

Brief Description of Duties:

The Financial Analyst provides analytical, operational, and financial reporting support within the Office of the Provost. Reporting to the Senior Analyst on the Academic Budget and Finance team, the incumbent serves as a key liaison for academic unit financial operations, budget tracking, and analytics. The Financial Analyst collects, validates, analyzes, and interprets complex financial and operational data to support data-driven decision-making across Academic Affairs. Working under general supervision, the incumbent assists with budget forecasting, variance analysis, executive reporting, dashboard maintenance, and system testing. Additionally, this position serves as operational continuity support for the Senior Analyst, maintaining reliable reporting workflows while ensuring compliance with University, SUNY, State, Stony Brook and Research Foundation policies and procedures.

This position requires rigorous attention to detail, commitment to data integrity, sound judgment in managing confidential information, and strong interpersonal skills to collaborate effectively across all organizational levels. The incumbent must demonstrate the ability to independently evaluate operational issues, propose strategic solutions, and ensure fiscal accountability.

Financial Planning, Analysis & Executive Reporting

Support monthly, quarterly, and rolling forecast updates by gathering unit inputs, verifying data integrity, and running baseline projections under the direction of the Senior Analyst.
Perform monthly budget-to-actual (BvA) and period-over-period variance analysis; investigate underlying cost drivers and draft explanations for material discrepancies across operating and personnel budgets.
Maintain and update existing financial models, verifying formulas, operational assumptions, and data linkages across multi-departmental feeds.
Assist in developing driver-based financial models and scenario/sensitivity analyses to evaluate proposed unit initiatives, trade-offs, or funding requests.
Design, refine, and maintain operational dashboards and reporting templates (Power BI, Tableau, Excel) to track key performance metrics across Academic Affairs.
Monitor departmental spending trends to identify potential budget overruns or cost-containment opportunities early in the fiscal cycle.
Assist the Senior Analysts in preparing executive presentation decks, briefing materials, and narrative summaries for institutional leadership.
Serve as a primary point of contact for routine ad-hoc financial reporting and analysis requests across academic units.

Financial Systems and Initiative Implementation Support

Assist with Chart of Accounts (COA) governance, account maintenance, and institutional reporting alignment.
Support financial system enhancement initiatives (such as the New Economic Framework and WolfieOne), assisting with system updates that impact academic reporting structures.
Validate COA mapping accuracy and ensure transactional consistency across core reporting platforms.
Participate in user acceptance testing (UAT), data validation, and post-implementation reviews for new reporting tools or ERP upgrades.
Support data governance standards to maintain financial data integrity and consistency across all published reports.

Stakeholder Support & Business Process Improvement

Provide routine financial and analytical support to unit administrators, department managers, and unit finance staff.
Collaborate with academic units to understand operational reporting requirements and translate them into functional dashboards or recurring reports.
Identify and recommend process improvements to streamline data collection, reduce report generation timelines, and strengthen internal controls.
Assist in creating user documentation, job aids, and reference materials related to financial reporting tools and processes.

Other duties or projects as assigned as appropriate to rank and departmental mission

Special Notes:

This is a full-time appointment. FLSA Exempt position, not eligible for the overtime provisions of the FLSA. Minimum salary threshold must be met to maintain FLSA exemption.

This position will report to campus in Stony Brook, NY.

In addition to the employee’s base salary, this position is eligible for $4,150 UUP annual location pay, paid biweekly.

For this position, we are unable to sponsor candidates for work visas.

Stony Brook University is committed to excellence in diversity and the creation of an inclusive learning and working environment. All qualified applicants will receive consideration for employment without regard to race, color, national origin, religion, sex, pregnancy, familial status, sexual orientation, gender identity or expression, age, disability, genetic information, veteran status and all other protected classes under federal or state laws.

If you need a disability-related accommodation, please call the university Office of Equity and Access (OEA) at (631) 632-6280 or visit OEA.

In accordance with the Title II Crime Awareness and Security Act a copy of our crime statistics can be viewedhere.

Visit our WHY WORK HERE page to learn about the total rewards we offer.

Job Number:

2603769
Official Job Title: Senior Staff Assistant

Job Field

: Administrative & Professional (non-Clinical)

Primary Location

: US-NY-Stony Brook
Department/Hiring Area: Office of the Provost

Schedule

: Full-time

Shift