Stony Brook University
Senior Analyst
Stony Brook University, Stony Brook, New York, United States, 11790
Required Qualifications (as evidenced by an attached resume): Bachelor's degree (foreign equivalent or higher) in Accounting, Financial Analysis, Finance, or a related financial/analytical discipline. Three (3) years of full-time, professional experience in financial analysis, budgeting, or related roles. Functional knowledge of and related work experience with databases. Experience with Microsoft Office Suite, particularly Microsoft Excel.
Preferred Qualifications: Advanced degree (foreign equivalent or higher) in Accounting, Financial Analysis, Finance, or a related financial/analytical discipline. Experience with Oracle. Experience using macros and other automation tools. Experience with data mining (querying, reporting, etc.) in or comparable business intelligence software.
Brief Description of Duties: The Analyst is responsible for performing specialized analytical duties in the Budget, Financial Planning & Analysis Office using multiple reporting tools including SUNY BI, Tableau, OBIEE, and Microsoft Excel and Access. This is a dynamic role that will provide the candidate the opportunity to gain an understanding of all facets of higher education and state university finances and budgeting. It is a critical role supporting the reporting and strategic planning efforts at Stony Brook and provides university leadership with crucial decision support. The successful candidate must be a highly motivated, detail-oriented, investigative thinker with a strong commitment to customer service. The incumbent will possess superior communication skills, work well in a team environment, and have the ability to quickly adapt to changing priorities all while maintaining confidentiality and discretion. The Analyst will provide financial insights, reporting, and analysis of financial data and performance measures, monitor key financial and operating metrics, and assist in long-range strategic planning. The incumbent will be responsible for performing specialized analytical duties in the Budget, Financial Planning, & Analysis Office and will include generating and executing reports as well as partnering with programmers to create canned reports and dashboards for the campus' financial leaders. The incumbent will be expected to collect, analyze, and develop data relative to the BFP&A Office and the University, make informed recommendations, and assist in the implementation of financial projects and systems. For success, the Analyst must have excellent analytical skills that will assist in the identification of key issues and use of inductive reasoning in complex situations. The selected candidate should possess excellent communication skills with the ability to present financial information clearly to diverse audiences. They should also have strong attention to detail and accuracy in data analysis and reporting as well as the ability to work independently and collaboratively in a fast-paced environment.
Duties For All Positions: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.Accurately analyze and collect data to produce budget metrics and key performance indicators (KPI) for senior leadership.Understand implications of the financial data and offer well-informed recommendations based on data analytics performed.Effectively evaluate and understand the financial reporting requirements produced for SUNY and subsequently translate the data into internal management reporting needs.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.Collaborate with other members of the BFP&A team and other university departments to gather relevant data and provide financial insights.
Back up for
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 prepayments.
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.Create and maintain the campus' yearly and semester financial plans and revenue to be used for historical and out-year planning.
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 to guarantee data integrity and validation.Build reporting systems for one-off or long-term use.
Additional Duties & Responsibilities as Assigned:
Other duties or projects as assigned as appropriate to rank and departmental mission.
In addition to the Above Duties:Senior Business Systems Analyst Duties
: This position is multi-faceted and responsible for validating quarterly forecasts, consolidating capital financial reporting and updating existing business processes/rules to align to the campus' financial strategy. The position will also support the EDM (Enterprise Data Management) application, driving the alignment of COA (Chart of Accounts) and reporting across the various functional platforms as it relates to budgeting & multi-year financial planning. Support data governance applicable to EDM for financial planning. This position will support the university in its goal to have its own standardized financial reporting (including cash basis operating reporting) and still be able to communicate financial information to and from other business units in various systems.
Senior Resource Planning Analyst Duties
: This analyst is needed to financially calibrate the economic model, overhead and strategic initiatives pool. They will manage the cash flow discrepancies resulting from the campus economic model and the model used by our partnering entities. They will also assist in the yearly evaluation of the economic model to assess its efficacy.
Senior Resource Systems Analyst Duties
: Once the new economic model is systematized this position is responsible for maintaining that system infrastructure. They are also responsible for partnering with IT, IRPE & Finance to maintain the data aggregation models in the source systems and all data validation. Contribute to the reconciliation of the university area's budget submission to the internal budget planning model and its strategic goals Assist and support the financial administration for specific units and create reports within Oracle to support university resource planning Assist and provide training for economic framework budget model managers across campus.
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.
In addition to the employee's base salary, this position is eligible for $3,400 UUP annual location pay, paid biweekly.
For this position, we are unable to sponsor candidates for work visas.
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 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.Job Number: 2403214 Official Job Title: Assistant for University Financial Analysis Job Field: Administrative & Professional (non-Clinical) Primary Location: US-NY-Stony Brook Department/Hiring Area: Budget, Financial Planning and Analysis Schedule: Full-time Shift :Day Shift Shift Hours: 8:30 a.m. - 5:00 p.m. Posting Start Date: Nov 15, 2024 Posting End Date: Nov 30, 2024, 4:59:00 AM Salary:Commensurate with experience. Appointment Type: Term Salary Grade:SL4 SBU Area:Stony Brook University
Preferred Qualifications: Advanced degree (foreign equivalent or higher) in Accounting, Financial Analysis, Finance, or a related financial/analytical discipline. Experience with Oracle. Experience using macros and other automation tools. Experience with data mining (querying, reporting, etc.) in or comparable business intelligence software.
Brief Description of Duties: The Analyst is responsible for performing specialized analytical duties in the Budget, Financial Planning & Analysis Office using multiple reporting tools including SUNY BI, Tableau, OBIEE, and Microsoft Excel and Access. This is a dynamic role that will provide the candidate the opportunity to gain an understanding of all facets of higher education and state university finances and budgeting. It is a critical role supporting the reporting and strategic planning efforts at Stony Brook and provides university leadership with crucial decision support. The successful candidate must be a highly motivated, detail-oriented, investigative thinker with a strong commitment to customer service. The incumbent will possess superior communication skills, work well in a team environment, and have the ability to quickly adapt to changing priorities all while maintaining confidentiality and discretion. The Analyst will provide financial insights, reporting, and analysis of financial data and performance measures, monitor key financial and operating metrics, and assist in long-range strategic planning. The incumbent will be responsible for performing specialized analytical duties in the Budget, Financial Planning, & Analysis Office and will include generating and executing reports as well as partnering with programmers to create canned reports and dashboards for the campus' financial leaders. The incumbent will be expected to collect, analyze, and develop data relative to the BFP&A Office and the University, make informed recommendations, and assist in the implementation of financial projects and systems. For success, the Analyst must have excellent analytical skills that will assist in the identification of key issues and use of inductive reasoning in complex situations. The selected candidate should possess excellent communication skills with the ability to present financial information clearly to diverse audiences. They should also have strong attention to detail and accuracy in data analysis and reporting as well as the ability to work independently and collaboratively in a fast-paced environment.
Duties For All Positions: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.Accurately analyze and collect data to produce budget metrics and key performance indicators (KPI) for senior leadership.Understand implications of the financial data and offer well-informed recommendations based on data analytics performed.Effectively evaluate and understand the financial reporting requirements produced for SUNY and subsequently translate the data into internal management reporting needs.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.Collaborate with other members of the BFP&A team and other university departments to gather relevant data and provide financial insights.
Back up for
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 prepayments.
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.Create and maintain the campus' yearly and semester financial plans and revenue to be used for historical and out-year planning.
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 to guarantee data integrity and validation.Build reporting systems for one-off or long-term use.
Additional Duties & Responsibilities as Assigned:
Other duties or projects as assigned as appropriate to rank and departmental mission.
In addition to the Above Duties:Senior Business Systems Analyst Duties
: This position is multi-faceted and responsible for validating quarterly forecasts, consolidating capital financial reporting and updating existing business processes/rules to align to the campus' financial strategy. The position will also support the EDM (Enterprise Data Management) application, driving the alignment of COA (Chart of Accounts) and reporting across the various functional platforms as it relates to budgeting & multi-year financial planning. Support data governance applicable to EDM for financial planning. This position will support the university in its goal to have its own standardized financial reporting (including cash basis operating reporting) and still be able to communicate financial information to and from other business units in various systems.
Senior Resource Planning Analyst Duties
: This analyst is needed to financially calibrate the economic model, overhead and strategic initiatives pool. They will manage the cash flow discrepancies resulting from the campus economic model and the model used by our partnering entities. They will also assist in the yearly evaluation of the economic model to assess its efficacy.
Senior Resource Systems Analyst Duties
: Once the new economic model is systematized this position is responsible for maintaining that system infrastructure. They are also responsible for partnering with IT, IRPE & Finance to maintain the data aggregation models in the source systems and all data validation. Contribute to the reconciliation of the university area's budget submission to the internal budget planning model and its strategic goals Assist and support the financial administration for specific units and create reports within Oracle to support university resource planning Assist and provide training for economic framework budget model managers across campus.
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.
In addition to the employee's base salary, this position is eligible for $3,400 UUP annual location pay, paid biweekly.
For this position, we are unable to sponsor candidates for work visas.
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 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.Job Number: 2403214 Official Job Title: Assistant for University Financial Analysis Job Field: Administrative & Professional (non-Clinical) Primary Location: US-NY-Stony Brook Department/Hiring Area: Budget, Financial Planning and Analysis Schedule: Full-time Shift :Day Shift Shift Hours: 8:30 a.m. - 5:00 p.m. Posting Start Date: Nov 15, 2024 Posting End Date: Nov 30, 2024, 4:59:00 AM Salary:Commensurate with experience. Appointment Type: Term Salary Grade:SL4 SBU Area:Stony Brook University