System Administrator and Functional Analyst

Job Details

Posting Number:


Job Title:

System Administrator and Functional Analyst

Position Number:






Position Type:

Professional Staff


Non-Union Non-Classified Staff

Pay Grade Level:


Pay Grade Range:

Salary commensurate with education and experience.

Status :

Calendar Year, Full-time, Permanent


Budget and Financial Planning


Please note: Job applications must be submitted directly online only at: (

Campus Location:


Grant Funded:


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:


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.


Perform additional duties as required, including the duties of other staff positions in the office.


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.

Required Qualifications:


1.Bachelor’s degree.

2.Minimum of two years of Oracle, Hyperion Planning and/or PBCS experience with production support and ongoing maintenance (on premise or Cloud versions).

3.Demonstrated experience with PeopleSoft Financials and HCM or similar ERP.

4.Demonstrated experience with Smartview or similar tool.

5.Demonstrated experience creating and maintaining financial reports in Financial Reporting Studio or similar application tool.

6.Demonstrated ability to analyze needs and determine appropriate technical solutions to solve business needs while meeting University objectives of Budgeting and Financial management.

7.Demonstrated ability to work independently and in teams.

8.Demonstrated strong interpersonal and verbal communication skills.

9.Demonstrated proficiency in written communication skills.

10.Demonstrated ability to troubleshoot and resolve issues within database integration/source systems.

11.Demonstrated ability to be detailed-oriented.

12.Demonstrated ability to ensure data accuracy while working with large amounts of data.

13.Demonstrated advanced experience in Excel.

14.Demonstrated ability to manage multiple projects simultaneously in a fast­paced environment.

15.Demonstrated ability to work with diverse groups/populations.

Preferred Qualifications:


1.Bachelor’s degree in disciplines related to Business Management, Information Technology or Financial Administration.

2.Demonstrated experience with query or SQL programming.

3.Demonstrated knowledge of best practices for related business processes.

4.Demonstrated understanding of fundamental financial concepts, budgeting and planning cycles, and reporting requirements of a higher education institution (or similar entity).

5.Demonstrated understanding of Business Intelligence concepts.

6.Demonstrated experience setting up, opening and closing business processes (e.g. setting up a new fiscal year) in Hyperion Planning and/or PBCS.

7.Demonstrated knowledge and experience with Budget Systems other than PBCS.

8. Demonstrated participation on an ERP or Cloud Implementation Team .

9.Demonstrated ability to provide clear and concise reports on a timely basis.

10.Demonstrated ability to be flexible.


Environmental Conditions:

The incumbent is not substantially exposed to adverse environmental conditions.

Posting Date:


Special Instructions to Applicants:

Please attach the following 3 (PDF) documents to your online Employment Application:

(#1) Cover letter.

(#2) Resume.

(#3) Other – References – names and contact information of three professional references.

Quicklink for Posting:


The University of Rhode IslandURI Picture 1

Founded in 1892, this land and sea grant university is the flagship public research institution in Rhode Island, enrolling more than 14,500 undergraduate students and 2,000 graduate students.

Thinking big
URI is home to some of today’s leading innovators, discoverers, and creative problem solvers and is known regionally and worldwide for its big ideas and pioneering research in such areas as environmental studies, neuroscience, biotechnology and life sciences, engineering, marine sciences, forensic sciences, pharmaceuticals, behavioral sciences, and public health promotion. A strong core of traditional academic disciplines provides the foundation for all specialized, professional, and applied areas of study. The University receives about $60 million annually in federal funding for research across 87 undergraduate and 70 graduate degree programs.

Motivated students, engaged faculty

Nearly 23,000 students applied for fewer than 3,300 openings in the 2017 freshman class, which boasts an average grade point average of 3.54. The 17 to 1 student/faculty ratio allows for personal attention and rewarding teaching experiences. Approximately 87 percent of faculty hold terminal degrees. In 2018 URI produced two Fulbright Scholars, five Boren Scholars, a Truman Scholar, and was named a one of the country’s top Gilman scholar-producing schools. URI’s commitment to diversity is demonstrated through its student body, with 43 states and 65 nations represented and 20 percent of students identifying as persons of color, a 65 percent increase since 2008.

Four campuses, one community

URI’s main campus is located on 1,248 acres in rural Kingston, where the campus core — including a quadrangle surrounded by handsome granite buildings — is listed on the National Register of Historic Places. Six miles from Rhode Island’s beaches, this campus is conveniently situated along the Boston to New York corridor. The University’s renowned Graduate School of Oceanography is located at the 165-acre Narragansett Bay Campus. The Alan Shawn Feinstein College of Education and Professional Studies brings higher education to downtown Providence. Nearby, the 133,000-square-foot Rhode Island Nursing Education Center URI Picture 2includes unparalleled simulation labs. The W. Alton Jones Campus — 2,300 acres of forests, lakes, and farmland in West Greenwich — provides a secluded setting for academic research, environmental education, business meetings and special events.


Investing in the future
Since 2007, the University has invested $607 million in campus capital projects, including: a $150 million engineering complex, due to open in 2019; Brookside, another new apartment-style residence hall, 2019; a Welcome Center, 2018; the Rhode Island Nursing Education Center, 2017; Beaupre Center for Chemical and Forensic Sciences, 2016; and Avedisian Hall, home to the College of Pharmacy, 2012.


Expertise on demand

The University is home to several centers of expertise that tackle some of society’s most vexing challenges. The George & Anne Ryan Institute for Neuroscience brings multi-disciplinary research to bear on devastating brain diseases, such as ALS and Alzheimer’s. The Digital Forensics and Cyber Security Center supports state, national, and international public welfare through education, research, training, and service. The Business Engagement Center is the “front door” through which industry taps into research and training opportunities and assistance with intellectual property or technology issues. The R.I. Food Center brings URI’s agricultural roots to the 21st century as a resource for farmers, consumers, retailers, and others across the food industry

Find Us
80 Lower College Road
North Kingston
Rhode Island
United States

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert