DHA-EOSS Business Intelligence Analyst (FM/EDW Business Analyst)

Quantum Sky•Aurora, CO

1d•$115,000 - $124,000•Onsite

About The Position

Quantum Sky is seeking a detail-oriented, collaborative Business Intelligence Analyst to support the Defense Health Agency (DHA) E-Commerce Operational Systems Support (EOSS) contract in Aurora, Colorado. The position serves as a functional link between operational stakeholders and technical engineering teams across the enterprise. It analyzes, documents, and manages business and system requirements connecting DHA’s Financial Management suite, centered on Oracle Federal Financials (OFF R12), with Enterprise Data Warehouse (EDW) business intelligence data marts. The analyst captures business needs from DHA Contract Resource Management (CRM) financial managers, translates federal statutory mandates into system requirements, conducts cross-system gap analyses, maintains requirements traceability, and supports user acceptance testing across reporting repositories including FRDM, ORDM, PRDM, and CAP/DME. The role also supports federal financial initiatives and interfaces, reporting validation, user training, and accessibility compliance. The position is based in Aurora, Colorado. Staff must be flexible to support cyclical workload surges, such as month-end close and fiscal year-end in September/October, with flex-time arrangements between pay periods pre-approved by the COR. The stated salary range is typically $115,000–$124,000, with actual compensation dependent on factors including education, experience, certifications, and other requirements.

Requirements

Must be a U.S. citizen for DHA IT network access and security vetting.
Bachelor’s degree from an accredited institution in Computer Science, Information Systems, Business Administration, Finance, Accounting, Engineering, or a related field; alternatively, 15 years of dedicated Business Analyst experience may substitute for the degree.
At least five years of documented business analysis experience supporting large-scale enterprise IT systems comparable in size, scope, and complexity to the DHA EOSS contract.
Proven experience writing formal System Requirements Specifications, business process flows, and functional design specifications, and maintaining bi-directional Requirements Traceability Matrices.
Must possess or obtain a DoD 8140.03 / DoDD 8570.01-M IAT Level II certification within three months of hire.
Must possess or be capable of obtaining a favorably adjudicated Tier 2 Public Trust / Non-Critical Sensitive IT-II background investigation and receive a DoD Common Access Card before accessing systems.

Nice To Haves

Functional understanding of Oracle Federal Financials / Oracle E-Business Suite R12 modules, including General Ledger, Purchasing, Payables, and Receivables, as well as USSGL and federal accounting flows.
Working familiarity with data warehouse architecture, including staging, archive, and dimensional marts; ETL data flows; and BI tools such as Oracle Analytics Server, OBIEE, BI Publisher, and SplashBI.
Prior experience supporting DHA, TEDS, MCSC healthcare claims processing, or pharmacy rebate reconciliations.
Working knowledge of DoD SFIS, SLOA, Treasury CARS, or G-Invoicing data standards.
Hands-on experience with Micro Focus / Serena SBM, HP Quality Center / ALM, Git, Jira, Confluence, and basic SQL querying for data validation.
CBAP, PMI-PBA, or similar professional credential.

Responsibilities

Interface with DHA CRM financial managers, DHA Office of General Counsel, and operational users to identify business problems and elicit functional system needs.
Conduct cross-system gap analyses to assess how upstream Oracle Federal Financials configuration or accounting rule changes affect EDW staging, archival layers, and data mart reports.
Define business analysis requirements for reporting reconciliations, data discrepancies, and workflow improvements.
Author, maintain, and update formal System Requirements Specifications for DHA ECS applications and operational interfaces, coordinating reviews for COR digital signatures.
Build and maintain a bi-directional Requirements Traceability Matrix for each application release, linking stakeholder requirements to design specifications, software builds, and test cases.
Attach approved requirements packages and RTMs to Change Requests in SBM and QC repositories for Configuration Working Group and Configuration Management Board review.
Analyze G-Invoicing business rules and integration of IGT Buy/Sell transactions, GT&C, orders, performance, and fund settlement with OFF.
Analyze annual DoD BEA releases and define system and reporting changes needed to maintain SFIS, Data Act, and SLOA compliance across OFF and EDW.
Define functional requirements for ingesting and processing CARS Transactional Data Extract data within OFF and EDW to automate daily cash and disbursement reconciliations.
Discover and document functional requirements and data dictionary additions for LOA and CCAS cost-accounting reporting across OFF and EDW.
Analyze TEDS healthcare and pharmacy claims record updates, mapping schema changes to OFF claims-processing extensions and EDW repositories.
Support CAP/DME functional analysis, data ingestion validation, and specialized financial reporting for data submitted by Managed Care Support Contractors.
Collaborate with the CRM Financial Manager during biennial CRMSIT testing to identify test claim scenarios, define modified TED record values, and analyze payment calculation results.
Work with Quality Assurance and Test Engineers to translate requirements into test scenarios and scripts in HP Quality Center/ALM.
Support Government UAT by assisting users, capturing test artifacts and screenshots, validating business logic, and classifying defects as major, moderate, or minor.
Verify that software modifications meet documented business requirements before CMB approval and production deployment.
Validate ad hoc queries and standard reports produced with Oracle Analytics Server, BI Publisher, and SplashBI for business logic accuracy and accounting integrity.
Help develop user training materials, user guides, and SOPs for financial and operational users across DHA commands and MTFs.
Ensure functional reporting outputs meet Section 508 and WCAG 2.1 Level AA accessibility criteria.
Support cyclical work surges, including month-end close and fiscal year-end, with flex-time arrangements pre-approved by the COR.