Budget Analyst II
Position Summary :
Reporting to the Director, Budget Operations, the Budget Analyst II works collaboratively within the University's Budget Office to assist with the preparation, tracking, analyzing, projecting, and reporting of the University's annual $1 Billion budget. This position will assist with special projects and analyses in the context of budget planning and monitoring, strategic planning, capital planning, and fundraising initiatives. The Budget Office, reports to the Associate Vice President for Budget & Fiscal Analysis and prepares information for the President, Provost, Executive Vice President of Operations, Finance & Support, the Chief Financial Officer and Board of Trustees as well as other senior leadership. The Budget Office also serves as the resource for university budget managers to understand and plan for their operating budget activity.
Workplace Requirements :
This position is offered as a hybrid role, combing both in-office and remote work to provide flexibility and support collaboration. Two days on campus and three days remote, except during budget season, when increased on-campus presence is required. Per Rice policy 440, work arrangements may be subject to change.
Salary : $63,100 to $82,500 annually
Exempt (salaried positions under FLSA are not eligible to overtime)
Required Qualifications :
- Bachelor's degree
- Two or more (2+) years of experience in budget analysis, budget preparation, forecasting, and reporting
- Advanced knowledge of word processing, spreadsheet (including pivot tables), presentation, and database software
Skills :
Demonstrated ability to develop and create financial and budget management reports using various report writing tools and applications (i.e. Hyperion Financial Reporting, EPM Cloud Narrative Reporting, Oracle Analytics Cloud, Tableau)Ability to monitor and collect data, interpret, analyze, and evaluate results, and to assess accuracy and integrity of dataDemonstrated knowledge of accounting and accounting principlesHigh level of customer service including ability to provide effective functional training to budget planners across the campusGood communication skills, both oral and written with ability to convey complex information in an understandable and professional wayDemonstrated problem solving and critical thinking skillsAbility to work independently and collaborativelyOrganizational skills with the ability to manage multiple and sometimes competing deadlines with high degree of timeliness and accuracyAbility to work with and maintain confidential informationPreferences :
Master's degree in a quantitative areaFive years of experience in budget analysis and planning, budget preparation, forecasting, and reconciliation; ideally in a university or college settingExperience with Oracle Financials and HCM or similar enterprise resource planning systemsExperience with budget planning software (i.e. Hyperion Planning, EPBCS)Essential Functions :
Provides support to the campus community in the budget development process by assisting in the preparation of special studies, reports and analyses, and by providing training on the use of the budget development system Oracle EPBCS (Enterprise Planning and Budgeting Cloud Service)Serves as a primary budget contact for various campus units and establishes effective relationships with those unitsIdentifies budget issues, evaluates alternatives, and recommends effective solutionsCompiles and analyzes data for new initiatives, providing recommendations based on projections of revenues and expenses, the reallocation / use of existing funds, and on any related issues that may impact costsParticipates in budget review meetings, providing necessary data, financial analyses, budget history, and historical trendsAssists in the balancing and consolidation of the annual budget and in the development of the annual budget book presented to the Board of Trustees, providing financial data, tables / charts, and budget narratives to explain revenue and expense componentsUses various software applications, such as MS Excel, Oracle Cloud, and MS PowerPoint to assemble, manipulate and / or format data and reportsDevelops and prepares monthly, quarterly and annual reports used in the development of the multi-year budget, forecasting, trend and results analysis for both management and the Board of TrusteesCollects and analyzes quarterly projections from campus units, and follows up on any discrepancies (i.e. budget vs. actuals, variances from prior year)Maintains the budget guidelines and tracking sheets by campus unit and communicates budget adjustments and related calculations to those unitsAnalyzes, calculates, and allocates budget authority based on internal university revenue sharing agreements and other formulaic allocationsMaintains and updates tracking of central budget commitments, preparing fund balance transfers, journal entries, and budget adjustments to satisfy those commitmentsReconciles budget adjustments and balance transfers within the financial accounting systemInterprets and explains University policies and procedures related to department budgetsAssists with or carries out other budget-related activities as assigned, including preparation or review of external reporting requirements