Job Title: System Administrator and Functional Analyst
Position Number: 109171
Position Type: Professional Staff
Union: Non-Union Non-Classified Staff
Pay Grade: Level 15
Pay Grade Range: Salary commensurate with education and experience.
Status: Calendar Year, Full-time, Permanent
Department: Budget and Financial Planning
Please note: Job applications must be submitted directly online only at: (https://jobs.uri.edu)
Campus Location: Kingston
Grant Funded: No
Extension Contingency Notes
Job Description Summary
The search will remain open until the position has been filled.
Oversee all aspects of the administration of the University’s budget system, Oracle Planning Budgeting Cloud Service (PBCS) including the responsibilities associated with Identity Domain Administrator and Planning Service Administrator. Responsible for administration and maintenance related to security for all users. Serve as point of contact with the vendor (Oracle).
Duties and Responsibilities
ESSENTIAL DUTIES AND RESPONSIBILITIES:
Assume the role of Oracle PBCS (Planning Budgeting Cloud Service) Identity Domain Administrator and Planning Service Administrator in both the test and production environments.
Responsible for the administration and maintenance of PBCS Security for all users, including user roles and dimension security.
Serve as the point of contact for University PBCS users when production issues are encountered working with the user to clearly define the issue. Perform data analysis and independent research necessary to resolve the issue internally or with the vendor (Oracle) in a timely manner.
Serve as the point of contact for the vendor (Oracle). Monitor and review all Oracle communications and take necessary action. Responsible for logging and managing Oracle Service Requests, taking necessary action to support timely closure of all Service Requests.
Perform testing for PBCS production issues, monthly updates, upgrades, functionality enhancements and new implementation. Conduct user acceptance testing for functionality enhancements as required.
Responsible for meeting with users on a regular basis to understand and assist with any business or system issues within PBCS. Help in developing system enhancements or modifications to meet business needs.
Conduct PBCS training for new users in the Budget and Financial Planning Office and other departmental business offices. Train existing users on new functionality. Assist with developing, updating, and maintaining system documentation and training material for all users.
Responsible for integrations and validations from source system (PeopleSoft).
Perform, monitor, and maintain all data load processes in PBCS. Perform data validations to ensure financial and personnel data loaded in PBCS tie back to PeopleSoft. Monitor and resolve any data load errors.
Perform, monitor, and maintain all PBCS data extract processes. Responsible for the process of extracting budget data from PBCS and the process to load budget data from PBCS to PeopleSoft Financials.
Perform data validation to ensure budget data loaded to PeopleSoft Financials ties back to PBCS.
Perform metadata and tree/hierarchy updates on an on-going basis in PBCS, PeopleSoft Financials and PeopleSoft HCM.
Maintain data mapping tables in PBCS. Perform data validations to ensure data is mapping properly in PBCS.
Prepare PBCS for all budget cycles, monthly actuals, and year end actuals, including setting up scenarios, versions, performing data copies, and updating substitution variables.
Maintain and update existing business rules, calculation scripts, web forms and smart forms in PBCS. Create new PBCS web forms, business rules, calculation scripts and smart forms as needed.
Maintain and update existing financial and position reports in Financial Reporting Studio. Develop and maintain new financial and personnel reports as needed in Financial Reporting Studio.
Monitor the automated daily backup of PBCS and restore the system from a backup if needed.
Assist the Budget and Financial Planning Office with completing all budget cycles, performing ad hoc and routine financial tasks.
Participate on various University committees and provide related technical and analytical support.
OTHER DUTIES AND RESPONSIBILITIES:
Perform additional duties as required, including the duties of other staff positions in the office.
LICENSES, TOOLS AND EQUIPMENT:
Personal computers and printers; mainframes; word processing, database management and spreadsheet software; calculators; Hyperion Planning / Oracle PBCS; Smartview; Enterprise Resource planning systems; Financial Reporting Studio. Excel.
Minimum of two years of Oracle, Hyperion Planning and/or PBCS experience with production support and ongoing maintenance (on premise or Cloud versions).
Demonstrated experience with PeopleSoft Financials and HCM or similar ERP.
Demonstrated experience with Smartview or similar tool.
Demonstrated experience creating and maintaining financial reports in Financial Reporting Studio or similar application tool.
Demonstrated ability to analyze needs and determine appropriate technical solutions to solve business needs while meeting University objectives of Budgeting and Financial management.
Demonstrated ability to work independently and in teams.
Demonstrated strong interpersonal and verbal communication skills.
Demonstrated proficiency in written communication skills.
Demonstrated ability to troubleshoot and resolve issues within database integration/source systems.
Demonstrated ability to be detailed-oriented.
Demonstrated ability to ensure data accuracy while working with large amounts of data.
Demonstrated advanced experience in Excel.
Demonstrated ability to manage multiple projects simultaneously in a fastpaced environment.
Demonstrated ability to work with diverse groups/populations.
Bachelor’s degree in disciplines related to Business Management, Information Technology or Financial Administration.
Demonstrated experience with query or SQL programming.
Demonstrated knowledge of best practices for related business processes.
Demonstrated understanding of fundamental financial concepts, budgeting and planning cycles, and reporting requirements of a higher education institution (or similar entity).
Demonstrated understanding of Business Intelligence concepts.
Demonstrated experience setting up, opening and closing business processes (e.g. setting up a new fiscal year) in Hyperion Planning and/or PBCS.
Demonstrated knowledge and experience with Budget Systems other than PBCS.
Demonstrated participation on an ERP or Cloud Implementation Team .
Demonstrated ability to provide clear and concise reports on a timely basis.
Demonstrated ability to be flexible.
ALL REQUIREMENTS ARE SUBJECT TO POSSIBLE MODIFICATION TO REASONABLY ACCOMMODATE INDIVIDUALS WITH DISABILITIES.
The incumbent is not substantially exposed to adverse environmental conditions.
Posting Date 04/30/2021
Special Instructions to Applicants
Please attach the following 3 (PDF) documents to your online Employment Application:
(#1) Cover letter.
(#3) Other – References – names and contact information of three professional references.
Additional Salary Information: Salary commensurate with education and experience.
Internal Number: SF01048
About University of Rhode Island
The University of Rhode Island is the state's flagship institution of higher education, and its only public university. As such, we are uniquely positioned, ready and able to provide innovative ideas, adaptive intelligence and breakthrough research to enhance the lives of the people in our state, nation, and world.
At URI you'll discover a small, beautiful, student-centered learning environment with the resources, research capabilities, and opportunities of a much larger public institution. In other words, we may be a smaller university, but our thinking is big. At URI, you'll find some of the best and brightest entrepreneurs, innovators, and discoverers on our faculty, in our research enterprise, and in our student body.
Our students come from dozens of countries, and wherever you look, from Argentina to Zimbabwe, URI alumni are making a difference around the world. We are expanding international research and partnerships that will further prepare our graduates to contribute to an increasingly globalized economy and society.
And we are growing a community that embraces equity, diversity, and unity, in which students graduate with the capability to work across cultures, la...nguages, lifestyles and traditions, because they have themselves been valued for both their individuality and the cultures they bring with them.