Subject Matter Expert - Intermediate (Oracle Business Intelligence and IDW Support)

Overview

Remote
$120,000+
Full Time
No Travel Required

Skills

OBIEE
Database
Database administration
SSO
System administration
Management

Job Details

CRI Advantage is looking for a Subject Matter Expert. The Subject Matter Expert will support the Department of Energy's Corporate Business Systems (CBS), including the Integrated Data Warehouse (IDW) and iPortal. The role focuses on system operations, maintenance, data integration, and user support for approximately 14,000 active users. The candidate will leverage Oracle tools, streamline business processes, and ensure data integrity and accessibility across platforms.

IDW Operations and Maintenance:

- Monitor and control interface processing and support error handling.

- Manage data reconciliation, quality management, and system processing (daily, weekly, monthly, and annual).

- Maintain standard reports and dashboards (1,000+ reports, 25+ dashboards).

- Provide user training and ad-hoc reporting support.

- Enhance access to financial and resource data for operational efficiency.

- Support configuration changes, coordinate updates, and mitigate system performance issues.

iPortal Operations and Maintenance:

- Manage single sign-on (SSO) and zero sign-on systems.

- Maintain collaboration tools (web conferencing, instant messaging).

- Ensure user access control and role management.

- Develop and modify portlets/functions based on user and governmental requirements.

- Support user training and address Help Desk Tier 2 and Tier 3 issues.

Database Administration:

- Administer Oracle databases across development, sandbox, test, and production environments.

- Perform database installations, patch management, and cloning.

- Monitor and optimize database performance and capacity planning.

- Support system upgrades, vulnerability remediation, and security compliance.

Functional and Technical Expertise:

- Provide Oracle Business Intelligence and Unison PRISM support for procurement-related systems.

- Facilitate user acceptance and training for IDW and federal procurement systems.

- Develop dashboards, reports, and queries to support decision-making.

- Ensure data quality and support DOE's compliance with reporting mandates.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.