DHA-EOSS Data Mart Data Warehousing Specialist 213 (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) GovCloud East (MedCOI), utilizing Oracle DBMS, Oracle Analytics Server (OAS), BI Publisher, and WebLogic. 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 GovCloud.

• Lead COTS software upgrades for OAS and Oracle WebLogic 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 loads from 6:00 PM – 6:00 AM MT and scheduled weekend release windows).

• Plan and execute quarterly benchmark and performance testing across data marts, tracking website access hits, report execution runtimes, and user concurrency.

• Provide Level 2/Level 3 troubleshooting for data mart incidents, diagnosing report performance degradation and resolving errors within contractual SLAs (4 hours during financial month-end close; 8 hours during standard operations).

• Deliver end-user training, user manual updates, and drop-down menu administration for DHA ECS operational stakeholders.

• Execute change management processes in compliance with IEEE 1074 SDLC standards and DHA Configuration Management Board (CMB) procedures using Git, Quality Center (QC), and Solution Business Manager (SBM).
• Develop and maintain technical Solution Design Documents and Requirements Traceability Matrices (RTM).
• Support DoD Public Key Infrastructure (PKI) Common Access Card (CAC) / PIV authentication and Oracle Internet Directory (OID) user access controls.
• Work alongside cybersecurity teams to remediate Security Technical Implementation Guides (STIGs) and vulnerability scans (ACAS, HBSS) on OAS and WebLogic hosting tiers.
• Participate in annual DHA ECS Continuity of Operations (COOP) and disaster recovery reconstitution drills.

Required:

• Citizenship: Must be a U.S. Citizen (mandatory for DoD IT-II privileged access and network authorization).

• Cybersecurity Certification: Must possess or obtain a DoD 8140.03 / DoDD 8570.01-M IAT Level II certification (e.g., CompTIA Security+ CE, CCNA Security, CySA+) within three (3) months of contract assignment.

• Education & Professional Experience (Senior Level):

  • Bachelor’s degree from an accredited university in Computer Science, Information Systems, Engineering, or a related discipline, or fifteen (15) years of equivalent documented professional experience in lieu of a degree.

  • Minimum of five (5) years of specialized experience in OBIEE / Oracle Analytics Server (OAS) application administration (including installations, clustering, security, and configuration), development, and BI Publisher in an enterprise data warehouse environment.

  • Extensive experience in dimensional modeling, data warehouse design, and SQL query optimization on Oracle DBMS hosted on Linux (RHEL).

  • Demonstrated background supporting large-scale, complex transactional and analytical reporting environments of the size and complexity of DHA ECS.

Desired:

• Prior experience supporting the Defense Health Agency (DHA), TRICARE Encounter Data System (TEDS), Military Health System (MHS), or DoD financial systems.

• Hands-on expertise with Oracle WebLogic Server administration, SSL certificate binding, and Oracle Internet Directory (OID) PKI/CAC integration.

• In-depth understanding of Section 508 / WCAG 2.1 accessibility testing and compliance for web-based dashboards and PDF/Excel outputs.

• Familiarity with federal accounting standards, Standard Financial Information Structure (SFIS), and Treasury reporting structures.

• Experience operating within secure cloud environments, particularly AWS GovCloud East and DISA/MedCOI virtual infrastructure (AVHE/VDI).

• Experience with automated batch scheduling tools (BMC Control-M) and ETL pipelines (Informatica PowerCenter).

• Working knowledge of version control (Git / GitHub) and enterprise ticketing systems (Micro Focus SBM / Quality Center).

Clearance: 

• Must possess an active Tier 3 (T3) NACLC / Secret eligibility or favorable Public Trust IT-II adjudication. Must be capable of obtaining and maintaining a DoD Common Access Card (CAC).

Location:

• 16401 East Centretech Parkway, Aurora, CO 80011

Shift:

• Work Schedule & Flex Time: Standard 40-hour work week Monday through Friday. Due to the cyclical nature of federal healthcare accounting (Month-End and Fiscal Year-End close), staff must have the ability to flex hours worked across pay periods to support off-hours production needs (PWS 5.2.2.30).

Compensation:

• Compensation is unique to each candidate and relative to the skills and experience they bring to the position. The salary range for this position is typically between $120,000-$135,000. This does not guarantee a specific salary as compensation is based upon multiple factors such as education, experience, certifications, and other requirements, and may fall outside of the above-stated range.

Benefits:

• Highlights of our benefits include Health/Dental/Vision, 401(k) match, Paid Time Off, STD/LTD/Life Insurance, Referral Bonuses, professional development reimbursement, and parental leave.

The world the mission operates in is going post-quantum, contested, and machine-speed. Quantum Sky engineers the advantage across cyber, networks, software, and quantum because the mission demands dominance, not parity. We don't follow the map. We draw it. 

At Quantum Sky, we believe that success starts with our people. We foster a collaborative, innovative, and mission-driven environment where every team member plays a critical role in shaping the future of technology. Are you ready to join #TeamQuantumSky? 

Quantum Sky Engineering LLC is an Equal Opportunity Employer; all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, [sexual orientation, gender identity,] national origin, disability, status as a protected veteran, or any characteristic protected by applicable law.