DHA-EOSS Database Administrator

Quantum Sky is searching for a detail-oriented and technically skilled Data Mart Data Warehousing Specialist (EDW Data Mart Specialist) to join our team supporting the Defense Health Agency (DHA) E-Commerce Operational Systems Support (EOSS) contract in Aurora, Colorado.

In this role, you will be part of the core Business Intelligence and Data Warehousing engineering team responsible for administering, enhancing, and maintaining the front-end reporting data marts of the DHA E-Commerce Data Warehouse (EDW). The EDW integrates private sector healthcare claims, financial accounting, and contract administration data for the Military Health System (MHS).

Working in a modern cloud-hosted environment within MedCOI AWS Gov Cloud East, you will configure and maintain reporting tools including Oracle Analytics Server (OAS), Oracle Business Intelligence Enterprise Edition (OBIEE), and BI Publisher across four dedicated reporting domains: the Financial Reporting Data Mart (FRDM), Operations Reporting Data Mart (ORDM), Pharmacy Reporting Data Mart (PRDM), and Contract Reporting Data Mart (CRDM). You will develop complex user reports, resolve reporting incidents, manage drop-down menus and metadata, support user access administration, and ensure all reporting interfaces comply with federal Section 508 accessibility mandates.

Responsibilities:

• Administer, configure, and sustain the DHA ECS reporting data marts (FRDM, ORDM, PRDM, CRDM, and Ad Hoc reporting portals) executing on Oracle and Linux (RHEL) platforms.

• Maintain and support Oracle Analytics Server (OAS), OBIEE, and Oracle Web Logic COTS server software stacks, supporting routine maintenance, configuration updates, and vendor patch application.

• Maintain report repositories, subject areas, physical-to-logical data mappings, and catalog objects (dashboards, analyses, prompts, and report templates).

• Administer drop-down menus, parameter filters, and presentation variables to align with changes in DHA contracting, financial, and operational business rules.

• Develop, test, and maintain pixel-perfect operational and management reports using BI Publisher and interactive dashboards in OAS.

• Support the restricted-access Contractor Resource Center (CRC) web portal, ensuring data integrity and timely generation across its seven complex report types covering healthcare claims, invoices, and payment data for Managed Care Support Contractors (MCSCs).

• Implement report modifications to incorporate financial data from all Oracle Federal Financials (OFF) Sets of Books into FRDM and PRDM reporting.

• Support user community ad hoc inquiries, generating custom datasets and reports for DHA Contract Resource Management (CRM), Contract Operations - Aurora (CO-Aurora), and DHA leadership.

• Manage data mart user profiles, access permissions, and dashboard security filters via Oracle Internet Directory (OID) / Single Sign-On (SSO) utilizing Common Access Card (CAC) PKI authentication.

• Provide direct user support, troubleshooting reporting discrepancies, query timeouts, and dashboard access issues.

• Maintain user guides, standard operating procedures (SOPs), and training documentation for data mart users in accordance with CDRL 0014 (Training Materials).

• Conduct functional walk-throughs and informal training for DHA analysts and contractor stakeholders.

• Ensure all OAS/OBIEE dashboards, generated PDF/Excel reports, and web interfaces conform strictly to Revised Section 508 Standards and WCAG 2.1 Level A and Level AA conformance requirements.

• Implement design standards supporting assistive technologies, ensuring compliance for users with visual, hearing, cognitive, and motor limitations (Revised 508 Chapter 3 & Chapter
  6).

• Remediate identified accessibility findings across existing reporting catalog objects.

• Support testing and rollout of in-flight enhancement initiatives, including the Contract Reporting Data Mart (CRDM) project and Line of Accounting / Common Cost Accounting (LOA/CCAS) reporting fields
• Perform unit testing and support User Acceptance Testing (UAT) for all new report builds, capturing test evidence and screenshots for CMB change packages.
• Track monthly usage metrics, including website access hits and report execution counts across FRDM, ORDM, PRDM, and CRDM to detect anomalies or…