DHA-EOSS Data Mart Data Warehousing Specialist 213 (EDW Data Mart Specialist)

Quantum Sky•Aurora, CO

1d•$140,000 - $155,000•Onsite

About The Position

Quantum Sky is seeking a senior Data Mart Data Warehousing Specialist (EDW Data Mart Specialist) to support the Defense Health Agency E-Commerce Operational Systems Support (DHA EOSS) program. The specialist will serve as a senior technical authority for the design, implementation, administration, optimization, and lifecycle sustainment of enterprise business intelligence repositories and analytical data marts. The DHA E-Commerce Data Warehouse is a two-tier, Linux-based analytics environment hosted on AWS GovCloud East (MedCOI) and built with Oracle DBMS, Oracle Analytics Server (OAS), BI Publisher, and WebLogic. Its reporting marts support financial, healthcare, contract, pharmacy, and medical education analytics. The role includes dimensional data modeling, dashboard development, analytics platform administration, Section 508 accessibility compliance, and collaboration with data warehouse engineers and database administrators to deliver performant reporting solutions. The position is based at 16401 East Centretech Parkway, Aurora, Colorado. The standard schedule is 40 hours per week, Monday through Friday, with flexibility across pay periods to support off-hours production needs during month-end and fiscal year-end close. Compensation is typically $140,000–$155,000, depending on candidate qualifications and other factors. Quantum Sky describes its environment as collaborative, innovative, and mission-driven, supporting work across cyber, networks, software, and quantum. The company is an Equal Opportunity Employer.

Requirements

Must be a U.S. citizen.
Must possess or obtain a DoD 8140.03 / DoDD 8570.01-M IAT Level II certification, such as CompTIA Security+ CE, CCNA Security, or CySA+, within three months of contract assignment.
Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related discipline, or 15 years of documented equivalent professional experience in lieu of a degree.
At least five years of specialized experience administering OAS/OBIEE applications, including installations, clustering, security, and configuration, as well as development and BI Publisher in an enterprise data warehouse environment.
Extensive experience in dimensional modeling, data warehouse design, and SQL query optimization using Oracle DBMS hosted on Linux/RHEL.
Demonstrated experience supporting large-scale, complex transactional and analytical reporting environments comparable in size and complexity to DHA ECS.
Must possess 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.
Must be able to flex hours across pay periods to support off-hours production needs during month-end and fiscal year-end close.

Nice To Haves

Prior experience supporting DHA, TRICARE Encounter Data System (TEDS), Military Health System (MHS), or DoD financial systems.
Hands-on experience administering Oracle WebLogic Server, binding SSL certificates, and integrating Oracle Internet Directory (OID) with PKI/CAC.
Knowledge of Section 508 and WCAG 2.1 accessibility testing and compliance for web dashboards and PDF/Excel outputs.
Familiarity with federal accounting standards, SFIS, and Treasury reporting structures.
Experience with secure cloud environments, particularly AWS GovCloud East and DISA/MedCOI virtual infrastructure (AVHE/VDI).
Experience with BMC Control-M automated batch scheduling and Informatica PowerCenter ETL pipelines.
Working knowledge of Git/GitHub and enterprise ticketing systems such as Micro Focus SBM and Quality Center.

Responsibilities

Administer, configure, upgrade, and optimize OAS, OBIEE, and BI Publisher platforms running on Red Hat Enterprise Linux in AWS GovCloud.
Lead OAS and Oracle WebLogic COTS software upgrades at least three months before vendor end-of-support deadlines.
Architect, implement, and maintain Star-Schema and Snowflake dimensional models, aggregates, materialized views, and RPD Physical, Business Model & Mapping, and Presentation layers.
Administer the OAS Web Catalog, including security permissions, folder structures, role-based dashboards, and shared analytics objects.
Work with database administrators to tune complex SQL queries, analyze indexing strategies, and improve physical schema performance for high-volume transaction datasets.
Develop, test, and maintain interactive dashboards, drill-down reports, and pixel-perfect operational templates across FRDM/CRC, ORDM, PRDM, and CRDM.
Maintain and enhance the restricted-access Contractor Resource Center portal, providing managed care support contractors and military treatment facility commands with claims, invoice, and payment information.
Develop PRDM claim-level reconciliation reporting to analyze pharmacy rebate disputes and manufacturer discrepancies.
Provide ad hoc reporting using OAS and SplashBI for executive leadership and CRM financial managers analyzing budget execution, commitments, and obligations.
Support completion and production rollout of the in-flight CRDM project.
Ensure web reporting interfaces, dashboards, and exported deliverables comply with Revised Section 508 and WCAG 2.1 Level A and AA accessibility standards.
Integrate accounting data from all Oracle Federal Financials Sets of Books into EDW data marts and incorporate SFIS and SLOA data changes into reporting models.
Align reporting structures with CARS transactional data extract reconciliations and enhance data marts to reflect updated CCAS attributes.
Monitor nightly data mart loads from 6:00 PM to 6:00 AM MT and support scheduled weekend release windows.
Plan and execute quarterly data mart benchmarking and performance testing, tracking website access hits, report runtimes, and user concurrency.
Provide Level 2 and Level 3 incident troubleshooting, resolving report performance degradation and errors within contractual SLAs of four hours during financial month-end close and eight hours during standard operations.
Deliver end-user training, update user manuals, and administer drop-down menus for DHA ECS stakeholders.
Execute change management in accordance with IEEE 1074 SDLC standards and DHA Configuration Management Board procedures using Git, Quality Center, and Solution Business Manager.
Develop and maintain technical Solution Design Documents and Requirements Traceability Matrices.
Support CAC/PIV authentication and Oracle Internet Directory user access controls.
Work with cybersecurity teams to remediate STIGs and ACAS/HBSS vulnerability scan findings on OAS and WebLogic hosting tiers.
Participate in annual DHA ECS continuity-of-operations and disaster-recovery reconstitution drills.