Oracle ERP Reporting Analyst

Princeton University
Princeton, New Jersey
Closing date
Sep 15, 2021

View more

Administrative Jobs
Technology, Database Administration

Job Details

Oracle ERP Reporting Analyst


Job ID: 2021-13090
Type: Full-Time
# of Openings: 1
Category: Information Technology

Princeton University


The Princeton Plasma Physics Laboratory (PPPL) has an Oracle Cloud Enterprise Resource Planning (ERP) Reporting Analyst opening within its Information Technology Department in the application development (AppDev) team. Under some supervision, the successful candidate is responsible for the design, development, and support of Oracle Fusion Cloud ERP dashboards, reports, conversions, interfaces, and enhancements with an emphasis on the development of dashboards and reports, The ideal candidate will be working closely with customer departments and responsible for engaging end-users in with reporting needs. Strong verbal and written communication skills are required.

The Princeton Plasma Physics Laboratory is a world-class fusion energy research laboratory managed by Princeton University for the U.S. Department of Energy’s Office of Science. PPPL is dedicated to developing the scientific and technological knowledge base for fusion energy. The Laboratory advances the fields of fusion energy and plasma physics research to develop the scientific understanding and key innovations needed to realize fusion as an energy source for the world.


  • Develop programs for data conversions, interfaces, and enhancements (30%)
  • Develop new reports and enhance Oracle Fusion Cloud ERP reports (40%)
  • Analyze the business procedures and provide AI guides to the lab leadership (10%)
  • Provide trainings and documentations for functional users (10%)
  • Backup support for other applications within AppDev Team (10%)


Education and Experience:

  • Bachelor’s degree in computer science, information system, or business administration
  • Working experience with data conversion and reporting
Knowledge, Skills and Abilities:

  • Required Qualifications:
    • 3+ years hands on experience developing dashboards and reports using Oracle Financial Reporting Studio (FRS), Oracle Transactional Business Intelligence (OTBI), and Business Intelligence Publisher (BIP), including:
      • Ability to create custom formulas, advanced reports, and dashboards within OTBI
      • Strong familiarity with Oracle's Cloud ERP Financials out-of-the-box reports
      • Experience developing BI Publisher data models and using RTF templates
    • Hands on experience with end-to-end report testing cycle
    • Working experience with developing and optimizing stored procedures and functions using SQL
    • Strong knowledge of SQL, Oracle, PL/SQL, and report performance tuning skills
    • Hands on experience in monitoring the effectiveness of reporting products, modifying current reports, or operationalize new reports
    • Experience in effectively managing confidential data, and professional working with colleagues in establishing and adhering to data governance standards
    • Excellent technical problem-solving skills with ability to work independently and in a team-oriented manner
    • Excellent customer service and communication skills, with an ability to understand and communicate complex functional and technical solutions to departments and end users
    • Proactively seeks and provide recommendations to improve usefulness, efficiency, and performance of reports
    • Effective time management skills and ability to work under pressure to meet deadlines, handle multiple tasks and set priorities
    • Provides basic to advanced reporting training and guidance to customers with focus on enabling users self-service reporting solutions
  • Preferred Qualifications:
    • Experience with Government Subcontractors, DOE laboratories and/or higher education
    • 1+ year experience with Cloud native tools like FBDI, ADFdi, Application tool kit (flex fields, lookups, value sets, ESS etc.), Oracle Cloud personalization
    • Experience or knowledge on Oracle Financials and Supply Chain Management modules, such as AP, FA, CM, PO, Budget, and Projects etc. will be an added advantage
    • Experience with Oracle Fusion configuration and administration including roles, permissions, page layouts, custom objects, scripting, workflows, reports, and dashboards
    • Ability to recommend business process or system enhancements to improve reporting capabilities and influence system owners to incorporate changes
Physical Requirements:

  • Occasional lifting of IT equipment less than 20lbs such as a desktop tower computer or computer monitor may be required.
Working Conditions:

  • Remote work may be required on a periodic or as needed basis.
Princeton University is an Equal Opportunity/Affirmative Action Employer and all qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity or expression, national origin, disability status, protected veteran status, or any other characteristic protected by law. EEO IS THE LAW

Please be aware that the Department of Energy (DOE) prohibits DOE employees and contractors from participation in certain foreign government talent recruitment programs. All PPPL employees are required to disclose any participation in a foreign government talent recruitment program and may be required to withdraw from such programs to remain employed under the DOE Contract.



Princeton entrance

Princeton University is a vibrant community of scholarship and learning that stands in the nation's service and the service of humanity. As a world-renowned research university, Princeton seeks to achieve the highest levels of distinction in the discovery and transmission of knowledge and understanding. At the same time, Princeton is distinctive among research universities in its commitment to undergraduate teaching.

Princeton University facultyOpportunity and Impact

At Princeton, every member of our community plays an important role in our mission of teaching and research. That mission provides every faculty and staff member with the opportunity to make an impact bigger than oneself. Learn about working at Princeton and meet some of our wonderful employees.


Services and Resources

When you make a commitment to our teaching and research mission, you will have access to the University’s world-renowned resources to help you succeed at work and in life. Discover the exceptional benefits and unique opportunities we offer as part of our commitment to you.

Work-Life Integration

Life is complicated. At Princeton, we recognize that and are sensitive and responsive to the challenges our employees face. The University offers a broad array of benefits and services that help our staff in a variety of ways.

Explore Our Job OpeningsPrinceton students and prof

Whether you’re already part of our community or just getting to know us for the first time, we invite you to imagine the meaningful difference you can make while working at Princeton. For faculty member and academic professional opportunities, visit the Dean of the Faculty website. For staff member job openings and to join our Talent Network, visit our Careers website.

Connect With Us

Find Us
United States

Get job alerts

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

Create alert