Rutgers, The State University of New Jersey, is seeking a Systems Analyst, Business Intelligence (BI) for the Office of the University Controller. Reporting to the Senior Manager of Financial Information Systems Reporting and Analytics, the Systems Analyst, BI is responsible for developing reports (e.g., formatted reports, queries, analysis, dashboards, etc.) to support various strategic projects and day-to-day operational activities. This involves developing and maintaining reports using various systems/modules, such as Oracle Cloud ERP Financials, Project Portfolio Management, Accounts Payable, Accounts Receivable, Procurement, etc., that house financial information currently and in the future. This position is also responsible for production support, data analysis, troubleshooting, supporting system patches, report design, development, testing, implementation, technical/functional documentation, and other related activities to support the financial reporting and analytics platform/environment.
Among the key duties of this position are the following:
Design, develop, and implement reporting solutions within Oracle Cloud ERP Financial systems and modules.
Primarily utilize Oracle SQL and BI Publisher tool to develop reporting solutions. Other tools utilized include: Oracle transactional BI (OTBI), Financial reporting studio (FRS), Oracle Smart View (using Excel plug-in)
Work closely with business partners, technical and functional teams, end-users and other stakeholders to identify, recommend and develop reporting solutions for complex business problems
Perform analysis and troubleshoot in order to determine root cause for production issues.
Log identified issues within the issue tracking system (e.g., JIRA) for documentation and tracking purposes.
Develop new code or modify existing code as necessary to create new reports or modify/enhance existing reports based on business requirements.
Perform unit testing on existing and new reports as needed prior to integration and user acceptance testing (UAT)
Support functional and business teams during integration and user acceptance testing
Prepare necessary functional/technical documentation associated with the reporting solutions.
Develop/modify necessary documentation to propagate code/reports from development and test environments into production environment as part of the deployment process.
Minimum Education and Experience:
Bachelor's degree in Computer Science, Information Systems or related technology field or an equivalent combination of education and/ or experience.
A minimum of four (4) years progressive experience in developing reporting solutions in Finance (or equivalent business) systems using Oracle SQL.
Required Knowledge, Skills, and Abilities:
Report development experience in Oracle Cloud ERP Financials (R12 or Cloud) using Oracle SQL, Oracle BI Publisher, other BI tools and databases
Knowledge in Oracle Transactional Business Intelligence (OTBI), Financial Reporting Studio (FRS) reports, Oracle Smart View (using Excel plug-in) and related reporting tools
Good functional understanding of Oracle Cloud ERP Financials systems and modules; Strong technical knowledge of Oracle General Ledger, Projects (PPM), Accounts Payable, Account Receivable, Purchasing/Procurement, Fixed Assets, and Inventory
Strong knowledge of software development life cycle (SDLC) principles and methodologies.
Excellent verbal and written communication skills
Proficient in MS Office including Excel, Word, Power Point, etc.
Deep understanding of financial systems and reporting tools
Strong expertise in other data analytics and reporting/visualization tools, such as Tableau.
Proficiency in Accounting and related business processes; good understanding of financial reporting and related areas.
Oracle HCM and Payroll system knowledge would be a plus.
Working knowledge of Oracle Analytics Cloud (OAC) would be plus
Knowledge of Oracle EPM Cloud suite of applications would be a plus, including:
Enterprise Data Management Cloud Service (EDMCS)
Account Reconciliation Cloud Service (ARCS)
Financial Consolidation and Close Cloud Service (FCCCS)
Knowledge of PL/SQL, Oracle ADF, web services would be desirable
Posting Number: 21ST2513
Location: Off Campus
Internal Number: 140080
About Rutgers University
Rutgers, The State University of New Jersey, is a leading national public research university and the state's preeminent, comprehensive public institution of higher education. Rutgers is dedicated to teaching that meets the highest standards of excellence; to conducting research that breaks new ground; and to turning knowledge into solutions for local, national, and global communities. As it was at our founding in 1766, the heart of our mission is preparing students to become productive members of society and good citizens of the world. Rutgers teaches across the full educational spectrum: preschool to precollege; undergraduate to graduate and postdoctoral; and continuing education for professional and personal advancement. Rutgers is New Jersey's land-grant institution and one of the nation's foremost research universities, and as such, we educate, make discoveries, serve as an engine of economic growth, and generate ideas for improving people's lives.