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 GovCloud 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:

1. Data Mart Administration & Technical Sustainment

• 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 WebLogic 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.

2. Report Development & Ad Hoc Analytics

• 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.

3. User Administration & Support Services 

• 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.

4. Section 508 Accessibility & Compliance 

• 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.

5. Testing, In-Flight Projects & Operational SLAs

• 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 performance degradations.
• Adhere to strict contract outage resolution SLAs, supporting rapid troubleshooting to restore reporting services within 4 hours during monthly financial closeouts and 8 hours during normal operational windows.

Required:

• Citizenship: Must be a United States Citizen (contractual prerequisite for DHA network access and background clearance ).

• Security Clearance: Must possess an active or favorably adjudicated Tier 2 (T2) Public Trust background investigation (SF-85P / MBI) or higher (e.g., Tier 3 / Secret) with an IT Level II sensitivity designation prior to performance start .

• Cybersecurity Certification (if privileged): If assigned administrative/privileged system access, must possess or obtain a DoD 8570.01-M / DoD Manual 8140.03 IAT Level II baseline certification (e.g., CompTIA Security+ ce, CCNA-Security) within 6 months of hire.

• Formal Education: Bachelor’s degree from an accredited institution in Computer Science, Information Systems, Software Engineering, Mathematics, or a related field.

  • Experience Substitution Rule: In accordance with fifteen (15) years of documented experience in data warehousing, BI development, or reporting administration may be substituted in lieu of a bachelor’s degree.

• Years of Experience: Minimum of three (3) years of hands-on experience in business intelligence reporting, data mart maintenance, and SQL development within an enterprise data warehouse environment.

Required Technical Competencies:

• BI & Reporting Platforms: Strong working knowledge of Oracle Analytics Server (OAS), Oracle Business Intelligence Enterprise Edition (OBIEE 11g/12c), and BI Publisher report authoring.
• SQL & Data Querying: Advanced proficiency in writing and optimizing SQL queries, understanding relational schemas, star schemas, dimensional models, and aggregate tables.
• Data Mart Administration: Experience maintaining reporting catalogs, creating dashboard prompts, configuring user security filters, and managing scheduled report bursts.
• Operating Environment: Familiarity with Linux (RHEL) commands, basic shell navigation, and understanding multi-tier web application architectures.

Desired:

• Prior experience supporting Military Health System (MHS), TRICARE Encounter Data (TEDS), or Department of Defense financial/contracting reporting systems.

• Direct experience developing Section 508 / WCAG 2.1 compliant reports and web dashboards.

• Familiarity with Oracle WebLogic Server administration, SSL certificates, and CAC/PKI authentication.

• Knowledge of Informatica PowerCenter workflows and batch job monitoring in BMC Control-M.

• Experience with cloud-hosted BI environments (AWS GovCloud / MedCOI)

Clearance:

• Must possess an active or favorably adjudicated Tier 2 (T2) Public Trust background investigation (SF-85P / MBI) or higher (e.g., Tier 3 / Secret) with an IT Level II sensitivity designation prior to performance start.

Location:

• Aurora, CO

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 $135,000-$155,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: