Business Intelligence Analyst

Quantum Sky•Aurora, CO

7d•$110,000 - $125,000•Onsite

About The Position

Quantum Sky is seeking a detail-oriented, collaborative Business Intelligence Analyst (FM/EDW Business Analyst) to support the Defense Health Agency (DHA) E-Commerce Operational Systems Support (EOSS) contract in Aurora, Colorado. The analyst serves as a functional link between operational stakeholders and technical engineering teams, analyzing, documenting, and managing 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 role focuses on gathering needs from DHA Contract Resource Management (CRM) financial managers, translating federal mandates into system requirements, conducting cross-system gap analyses, maintaining requirements traceability, and supporting user acceptance testing. Reporting repositories include the Financial Reporting Data Mart (FRDM / Contractor Resource Center), Operations Reporting Data Mart (ORDM), Pharmacy Reporting Data Mart (PRDM), and Capital and Direct Medical Education (CAP/DME) reporting area. The analyst also supports federal financial and healthcare initiatives, reporting validation, user enablement, and accessibility compliance. The position is based in Aurora, Colorado. Staff must be flexible to support cyclical 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.

Requirements

U.S. citizenship is mandatory 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 5 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 3 months of hire.
Must possess or be capable of obtaining a favorably adjudicated Tier 2 Public Trust / Non-Critical Sensitive IT-II background investigation (SF-85P / MBI) 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; 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 Solutions Business Manager (SBM), HP Quality Center / ALM, Git, Jira, Confluence, and basic SQL querying for data validation.
CBAP, PMI-PBA, or a 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 when changes occur, including evaluating effects of Oracle Federal Financials configuration or accounting-rule changes on EDW staging, archival layers, and data mart reports.
Define business requirements for reporting reconciliations, data discrepancies, and workflow improvements.
Author, maintain, and update formal System Requirements Specifications for DHA ECS applications and operational interfaces (CDRL 0010), coordinating reviews for Government COR digital signatures.
Build and maintain a bi-directional Requirements Traceability Matrix for each application release, tracing stakeholder requirements through design specifications, software builds, and test cases.
Attach approved requirements packages and RTMs to Change Requests in Solutions Business Manager and Quality Center repositories for Configuration Working Group and Configuration Management Board review.
Analyze G-Invoicing requirements, including IGT Buy/Sell rules, GT&Cs, orders, performance, and fund settlement integration with OFF.
Perform annual business analysis of DoD BEA standard 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 Extracts in OFF and EDW to automate daily cash and disbursement reconciliations for Agency Location Code 97000012.
Discover and document functional requirements and data dictionary additions across OFF and EDW for LOA and CCAS cost accounting reporting.
Analyze TEDS healthcare and pharmacy claims-record updates and map schema changes to OFF claims-processing extensions and EDW reporting 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; identify test-claim scenarios, define modified TED record values, and analyze payment-calculation results.
Work with Quality Assurance and Test Engineers to translate functional requirements into test scenarios and scripts in HP Quality Center / ALM.
Support Government UAT by assisting users during execution, capturing test artifacts and screenshots, validating business logic, and helping classify defects as major, moderate, or minor.
Verify that software modifications satisfy documented requirements before CMB approval and production deployment.
Validate ad hoc queries and standard reports produced through Oracle Analytics Server, BI Publisher, and SplashBI for business-logic accuracy and accounting integrity.
Help develop application 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.