Subject Matter Expert

RIVA Solutions, Inc.; Rockville (MD); On-site; USD 125,000 - 145,000; Full time

Job summary

RIVA Solutions, Inc. in Rockville, MD seeks an Oracle Federal Financials Subject Matter Expert (SME) to translate customer requirements into best-fit Oracle solutions, focusing on RICEW objects and mixed-system integrations.

The SME will use PL/SQL, Oracle Workflow, Reports, and XML Publisher, contributing to SDLC artifacts, testing, and post-deployment stabilization, with familiarity to HHS EPLC a plus. Strong collaboration with DBAs and cross-functional teams is required.

Qualifications

• Experience researching, analyzing, and troubleshooting RICEW objects (Reports, Interfaces, Conversions, Enhancements, and Workflows) in an Oracle Federal Financials or similar environment, and translating customer requirements into best-fit solutions within the application.
• Experience developing processes and documentation that support the systems development life cycle (SDLC), including maintaining required SDLC artifacts.
• Ability to obtain and maintain the required clearance/public trust, as applicable to the contract.

Responsibilities

• Document requirements; perform fit-gap analysis; and maintain requirements traceability from intake through design, build, test, and release.
• Design and develop complex solutions in Oracle Federal Financials, including RICEW components (Reports, Interfaces, Conversions, Enhancements, Workflows), interfaces, and mixed-system integrations.
• Perform rigorous testing and defect resolution, including unit testing, code review/validation for release, and support for system integration testing (SIT), user acceptance testing (UAT), and regression testing (RT).
• Develop, document, and execute unit test cases; log, track, and resolve defects, and verify fixes through re-test and regression as appropriate.
• Coordinate with DBAs and other technical/functional experts to migrate changes to test instances and environments; troubleshoot and resolve test defects to support timely delivery.
• Support the full end-to-end change management process by producing technical and functional documentation, documenting business justification, performing impact analysis, and supporting change requests on calls and in meetings.
• Assess the effectiveness of changes in the production environment and provide post-deployment stabilization support for releases to the Oracle Federal Financials production instance.
• Troubleshoot and assess critical systemic issues, interface failures, and complex defects; recommend and implement fixes to restore service and prevent recurrence.
• Comply with approved SDLC processes and produce/maintain all required SDLC artifacts (e.g., requirements, design, test evidence, release documentation); familiarity with HHS EPLC is a plus.
• Use Oracle development tools (PL/SQL, Oracle Workflow, Oracle Reports, XML Publisher) to build and maintain solutions, and demonstrate progressive learning of new tools and applications.
• Provide implementation and operational support for Oracle Federal Financials modules (as applicable), including General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Purchasing (PO), Federal Administrator for Budget Execution (BE), and Fixed Assets (FA).
• Support integrations and planning/performance management solutions as applicable, including Oracle Hyperion Planning/Enterprise Planning Suite and related interfaces and data transfers.
• Provide support across Oracle EPM components as applicable (e.g., client tools, Hyperion application services, Essbase, performance management services, financial reporting, Oracle Data Integrator, RDBMS integration, interfacing, and data interfaces/transfers).
• Support solutions related to e-invoicing and g-invoicing; robotic process automation (RPA) experience is a plus.

Skills

Oracle PL/SQL

Oracle Workflow

Oracle Reports

XML Publisher

RICEW

SDLC artifacts

Troubleshooting

Regression testing

Education

Bachelor’s degree in Computer Science or related field

Tools

Oracle Hyperion Planning

Enterprise Planning Suite

Essbase

Oracle Data Integrator

RPA tools

Job description

RESULTS. INNOVATION. VALUES. ACCOUNTABILITY.

That’s RIVA.

We’re a mission-driven IT services company and systems integrator supporting digital transformation and modernization for federal government agencies. Since 2009, we’ve partnered with our customers to solve complex challenges through smart, practical innovation to deliver real outcomes where they matter most. Our teams are made up of industry-leading experts who are passionate about doing great work and making a difference. We don’t just develop solutions, we support efforts that strengthen communities and serve the public good.

RIVA’s culture is built on four core values: Results, Innovation, Values, and Accountability. They guide how we work, how we collaborate, and how we measure success. Our employee-first approach is rooted in trust, ownership, and meaningful work. By investing in our people and fostering a flexible, supportive environment, employees have the opportunity to grow their skills, contribute ideas, and make an impact from day one. all while supporting missions that matter.

Position Overview

RIVA is seeking an Oracle Federal Financials Subject Matter Expert (SME) to provide advanced expertise translating customer requirements into best-fit application solutions, with a strong focus on researching, analyzing, and troubleshooting RICEW objects (Reports, Interfaces, Conversions, Enhancements, and Workflows) and supporting mixed-system integrations.

The SME is highly skilled with Oracle development tools (e.g., PL/SQL, Oracle Workflow, Oracle Reports, XML Publisher) and develops processes and documentation that support the systems development life cycle (SDLC), including required artifacts and rigorous testing practices. The position supports end-to-end change management through technical and functional documentation, impact analysis, and post-deployment stabilization, and brings familiarity with HHS EPLC (Enterprise Performance Life Cycle) practices as a plus.

Core Responsibilities

• Document requirements; perform fit-gap analysis; and maintain requirements traceability from intake through design, build, test, and release.
• Design and develop complex solutions in Oracle Federal Financials, including RICEW components (Reports, Interfaces, Conversions, Enhancements, Workflows), interfaces, and mixed-system integrations.
• Perform rigorous testing and defect resolution, including unit testing, code review/validation for release, and support for system integration testing (SIT), user acceptance testing (UAT), and regression testing (RT).
• Develop, document, and execute unit test cases; log, track, and resolve defects, and verify fixes through re-test and regression as appropriate.
• Coordinate with DBAs and other technical/functional experts to migrate changes to test instances and environments; troubleshoot and resolve test defects to support timely delivery.
• Support the full end-to-end change management process by producing technical and functional documentation, documenting business justification, performing impact analysis, and supporting change requests on calls and in meetings.
• Assess the effectiveness of changes in the production environment and provide post-deployment stabilization support for releases to the Oracle Federal Financials production instance.
• Troubleshoot and assess critical systemic issues, interface failures, and complex defects; recommend and implement fixes to restore service and prevent recurrence.
• Comply with approved SDLC processes and produce/maintain all required SDLC artifacts (e.g., requirements, design, test evidence, release documentation); familiarity with HHS EPLC is a plus.
• Use Oracle development tools (PL/SQL, Oracle Workflow, Oracle Reports, XML Publisher) to build and maintain solutions, and demonstrate progressive learning of new tools and applications.
• Provide implementation and operational support for Oracle Federal Financials modules (as applicable), including General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Purchasing (PO), Federal Administrator for Budget Execution (BE), and Fixed Assets (FA).
• Support integrations and planning/performance management solutions as applicable, including Oracle Hyperion Planning/Enterprise Planning Suite and related interfaces and data transfers.
• Provide support across Oracle EPM components as applicable (e.g., client tools, Hyperion application services, Essbase, performance management services, financial reporting, Oracle Data Integrator, RDBMS integration, interfacing, and data interfaces/transfers).
• Support solutions related to e-invoicing and g-invoicing; robotic process automation (RPA) experience is a plus.

Minimum Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Information Systems Management, Computer Programming, or a related field with extensive coursework in computers.
• Experience researching, analyzing, and troubleshooting RICEW objects (Reports, Interfaces, Conversions, Enhancements, and Workflows) in an Oracle Federal Financials or similar environment, and translating customer requirements into best-fit solutions within the application.
• Experience developing processes and documentation that support the systems development life cycle (SDLC), including maintaining required SDLC artifacts.
• Highly skilled in Oracle development tools such as PL/SQL, Oracle Workflow, Oracle Reports, and XML Publisher, with progressive learning of new tools and applications.
• Ability to obtain and maintain the required clearance/public trust, as applicable to the contract.

Preferred Qualifications

• Preferred experience implementing and providing operational support in Oracle Federal Financials, including General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Purchasing (PO), Federal Administrator for Budget Execution (BE), and Fixed Assets (FA).
• Experience with Oracle Hyperion Planning Management and the Enterprise Planning Suite (11.2.1.1 or higher) in a Federal installation, including design, development, implementation, interfaces, and operational support.
• Expertise with Oracle EPM applications and components such as client applications, Hyperion application services, Essbase, performance management services, financial reporting, Oracle Data Integrator, RDBMS integration, interfacing, and data transfers.
• Past experience with operations, maintenance, and support of Oracle financial and/or planning applications in commercial and Federal implementations; knowledge of HHS EPLC (Enterprise Performance Life Cycle) is a plus.
• Experience with e-invoicing and g-invoicing; robotic process automation (RPA) experience is a plus.

Pay range

$125,000 - $145,000 USD

EQUAL EMPLOYMENT OPPORTUNITY & ACCOMMODATION

We believe great teams are built from different backgrounds, perspectives, and lived experiences, and we mean that beyond the buzzwords.

RIVA is an equal opportunity employer. We welcome applicants of every race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, and any other characteristic protected by law.

If you need an accommodation at any point in our process, send an email to [e-mail], we'll be happy to help.

VETERAN SUPPORT & ACCESSIBILITY

As a federal contractor, RIVA follows the requirements of the Vietnam Era Veterans' Readjustment Assistance Act (VEVRAA) and Section 503 of the Rehabilitation Act, supporting the employment and advancement of protected veterans and individuals with disabilities. If you're a veteran, we encourage you to self-identify during the application process, it helps us track our hiring commitments and, in some cases, may support priority referral for open roles.

RIVA also invites applicants to voluntarily self-identify as having a disability during the application process, not because it affects your chances of being hired, but because it helps us measure how well we're living up to our commitments and identify where we can do better. Your response is confidential and entirely optional.