DHA-EOSS Data Mart Data Warehousing Specialist ; EDW Data Mart Specialist

Quantum Sky is searching for a
Senior Data Mart Data Warehousing Specialist (EDW Data Mart Specialist
- Senior) supporting the Defense Health Agency (DHA) E-Commerce Operational Systems Support (EOSS) program, you will serve as a senior technical authority for the design, implementation, administration, optimization, and lifecycle sustainment of enterprise business intelligence reporting repositories and analytical data marts.

The DHA E-Commerce Data Warehouse (EDW) is a 2-tier, Linux-based analytics ecosystem hosted on Amazon Web Services (AWS) Gov Cloud East (MedCOI), utilizing Oracle DBMS, Oracle Analytics Server (OAS), BI Publisher, and Web Logic. The EDW distributes private-sector healthcare, financial, and contract data across specialized reporting marts:

• Financial Reporting Data Mart (FRDM): Hosts the Contractor Resource Center (CRC) and Ad Hoc financial reporting suites.

• Operations Reporting Data Mart (ORDM): Automated BI capability consolidating healthcare, dental, and operational contract performance.

• Contract Reporting Data Mart (CRDM): Comprehensive BI dashboards and standard reports for DHA Contract Management
  - Aurora.

• Pharmacy Reporting Data Mart (PRDM): Claim-level reconciliation and manufacturer rebate dispute resolution.

• Capital and Direct Medical Education (CAP/DME): High-level financial analytics and modeling.

In this senior role, you will architect dimensional data models, design intuitive dashboards, administer analytics application tiers, ensure Section 508 compliance, and collaborate with data warehouse engineers and database administrators to deliver performant reporting solutions.

Responsibilities:

• Administer, configure, upgrade, and optimize Oracle Analytics Server (OAS), OBIEE, and BI Publisher enterprise platforms operating on Red Hat Enterprise Linux (RHEL) within AWS Gov Cloud.

• Lead COTS software upgrades for OAS and Oracle Web Logic application servers, completing upgrades at least three (3) months prior to vendor end-of-support deadlines.

• Architect, implement, and maintain Star-Schema and Snowflake dimensional data models, aggregates, materialized views, and Repository (RPD) layers (Physical, Business Model & Mapping, and Presentation tiers).

• Perform OAS Web Catalog administration, managing security permissions, folder hierarchies, role-based dashboards, and shared analytics objects.

• Partner with Database Administrators (DBAs) to tune complex SQL queries, analyze indexing strategies, and optimize physical schema performance against high-volume transaction datasets.

• Develop, test, and maintain interactive dashboards, complex drill-down reports, and pixel-perfect operational templates across all DHA ECS reporting marts: FRDM / CRC, ORDM, PRDM, and CRDM.

• Maintain and enhance the restricted-access Contractor Resource Center (CRC) web portal, providing managed care support contractors (MCSCs) and military treatment facility (MTF) commands with visibility into claims, invoices, and payment data.

• Deliver advanced claim-level reconciliation reporting in PRDM to analyze pharmacy rebate disputes and manufacturer discrepancies.

• Provide ad-hoc reporting capabilities using OAS and SplashBI, enabling executive leadership and CRM financial managers to analyze budget execution, commitments, and obligations.

• Support the completion and production rollout of the in-flight CRDM project.

• Ensure all web-based reporting interfaces, OAS dashboards, and exported deliverables strictly comply with Revised Section 508 of the Rehabilitation Act and WCAG 2.1 Level A and Level AA accessibility standards.

• Support key DoD enterprise accounting initiatives within EDW reporting:

  • All Sets of Books: Integrate accounting data from all Oracle Federal Financials (OFF) Sets of Books into EDW data marts.

  • BEA SFIS & SLOA: Incorporate Standard Financial Information Structure (SFIS) and Standard Line of Accounting (SLOA) data changes into reporting models.

  • CARS Integration: Align reporting structures with Central Accounting Reporting System (CARS) transactional data extract reconciliations.

  • Common Cost Accounting Structure (CCAS): Enhance data marts to reflect updated cost accounting attributes.

• Support operational execution schedules in accordance with DHA ECS requirements (monitoring nightly data mart…