The Budget Office is seeking qualified applicants for one (1) Senior Reporting Analyst and one (1) Senior Financial Analyst position. Please carefully review the position descriptions for each below.

Required Qualifications (as evidenced by an attached resume):
Detail-oriented investigative thinker with critical problem-solving skills. Bachelor's degree (foreign equivalent or higher). Three (3) years of full-time, professional experience in a financial or analytical environment. Experience gathering, analyzing, and evaluating complex information. Proven experience with databases, functional querying, and/or data mining. Proven proficiency in Microsoft Office Suite, particularly Microsoft Excel to include use of advanced formulas and functions.

Preferred Qualifications (as evidenced by an attached resume):
Bachelor's degree (foreign equivalent or higher) in Accounting, Financial Analysis, Finance, or a related analytical discipline. Six (6) or more years of full-time, professional experience in a financial or analytical environment. Demonstrated experience with improving reporting processes. Higher Education experience.

Brief Description of Duties:
The Senior Reporting Analyst and the Senior Financial Analyst are key members of the Stony Brook Financial Planning & Analysis (FP&A) team. These are dynamic roles that will provide candidates the opportunity to gain an understanding of all facets of higher education and state university finances and budgeting. They are critical roles supporting the financial analysis and strategic planning processes at Stony Brook and provide essential information to university leadership for decision-making support.

The successful candidates must be highly motivated and detail-oriented investigative thinkers with a strong customer service orientation, superior interpersonal and communication skills, and the ability to quickly adapt to changing priorities. The incumbents must have excellent analytical skills that will assist in the identification of key issues and the ability to use inductive reasoning in complex situations.

The Senior Reporting Analyst and the Senior Financial Analyst will provide financial insights, reporting and analysis of financial data and performance measures, monitoring of key financial and operating metrics, and long-range strategic planning. The incumbents will be responsible for performing specialized analytical duties in the Financial Planning & Analysis department using multiple reporting tools including SUNY BI, Tableau, OBIEE, and Microsoft Excel and Access. This will include generating and executing reports as well as partnering with programmers to create canned reports and dashboards for the campus' financial leaders. The incumbents will be expected to collect, analyze, and develop data relative to the Budget Office and University, make informed recommendations, and assist in the implementation of financial projects and systems.

Senior Reporting Analyst Duties:
Financial Reporting & Analysis:

• Organize, analyze, and compile financial data to create reports and dashboards that provide actionable information to campus financial leaders and managers.
• Understand implications of the financial data and offer knowledgeable recommendations based on data analytics performed.
• Partner with programmers to design and institutionalize accurate forecasting and financial planning tools; this includes modeling new algorithms, creating functional specifications, and testing and/or validating new financial planning tools.

Central Funds Campus Financials:

• Reconcile and maintain the campus' monthly "all-funds" financial plan (Central Funds); this includes reconciling each distribution of an initiative or commitment and tracking the out-year liability.
• Reconcile planned resources to the actuals and project the out-year figures in partnership with the related fund manager.
• Reconcile all transactions in the 70+ Central Funds accounts to the distribution schedule.
• Adjust for accounts receivable and pre-payments.

Budget Office Systems Support:

• Provide functional support for the development and implementation of the following new systems: Financial Planning module and Central Funds module; this includes participating with the creation of functional specifications and modeling functionalities as well as testing and troubleshooting.

Additional Duties & Responsibilities as Assigned:

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

Senior Financial Analyst Duties:
Financial Reporting & Analysis:

• Organize, analyze, and compile financial data to create reports and dashboards that provide actionable information to campus financial leaders and managers.
• Understand implications of the financial data and offer knowledgeable recommendations based on data analytics performed.
• Partner with programmers to design and institutionalize accurate forecasting and financial planning tools; this includes modeling new algorithms, creating functional specifications, and testing and/or validating new financial planning tools.

Ad-Hoc Modeling & Reporting:

• Create ad-hoc modeling reports for potential new campus initiatives, strategic investments, or dissolvements within the university.
• Utilize knowledge of state reporting systems and business financial knowledge while using data mining and reporting techniques to deliver actionable reports.
• Utilize strong knowledge of concepts such as data integrity, data relationships (primary key relationships, one-to-one, one-to-many, etc.) to create logical database/reporting designs while paying tremendous attention to details in order to guarantee data integrity and validation.
• Build reporting systems for one-off or long-term use.

Budget Office Systems Support:

• Create and maintain the campus' yearly and semester financial plans and revenue to be used for historical and out-year planning.

Additional Duties & Responsibilities as Assigned:

• 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.

Resume/CV and cover letter should be included with the online application.

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 The 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 viewed here .

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