Business Intelligence Analyst
- Compensation
- Not disclosed
- Location
- Aurora, CO, US
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Contract
- Experience
- Not specified
- Category
- Data analytics
- Posted
Skills
Must have
- Citizenship: Must be a U.S. Citizen (mandatory for DHA IT network access and security vetting).
- Formal Education: Bachelor’s degree from an accredited institution in Computer Science, Information Systems, Business Administration, Finance, Accounting, Engineering, or a related field. Experience S
- Years of Experience: Minimum of five (5) years of documented business analysis experience supporting large-scale enterprise IT systems of comparable size, scope, and complexity to the DHA EOSS contrac
- Core Competency: Proven experience writing formal System Requirements Specifications (SRS), business process flows, functional design specifications, and maintaining bi-directional Requirements Tracea
- Cybersecurity Certification: Must possess or obtain a DoD 8140.03 / DoDD 8570.01-M IAT Level II certification within three (3) months of hire.
Nice to have
- Financial ERP Systems: Functional understanding of Oracle Federal Financials / Oracle E-Business Suite (EBS) R12 modules (General Ledger, Purchasing, Payables, Receivables), U.S. Standard General Ledg
- Data Warehousing & BI Understanding: Working familiarity with data warehouse architecture (staging, archive, dimensional marts), ETL data flows, and BI tools (Oracle Analytics Server, OBIEE, BI Publis
- Military Health System (MHS) Experience: Prior experience supporting DHA, TRICARE Encounter Data System (TEDS), MCSC healthcare claims processing, or pharmacy rebate reconciliations.
- Federal Standards Knowledge: Working knowledge of DoD SFIS, SLOA, Treasury CARS, or G-Invoicing data standards.
- Tools: Hands-on experience with Micro Focus / Serena Solutions Business Manager (SBM), HP Quality Center (QC) / ALM, Git, Jira, Confluence, and basic SQL querying for data validation.
- Professional Certifications: CBAP (Certified Business Analysis Professional), PMI-PBA (PMI Professional in Business Analysis), or similar credential is an asset.
Full description
Description
Quantum Sky is searching for 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.
In this role, you will serve as the functional linchpin between operational stakeholders and technical engineering teams across the enterprise. You will analyze, document, and manage business and system requirements bridging the DHA Financial Management suite—centered on Oracle Federal Financials (OFF R12)—and the Enterprise Data Warehouse (EDW) business intelligence data marts.
Your day-to-day focus will center on capturing business needs from DHA Contract Resource Management (CRM) financial managers, translating federal statutory mandates into system requirements, conducting rigorous cross-system gap analyses, maintaining end-to-end traceability, and supporting user acceptance testing across reporting repositories such as the Financial Reporting Data Mart (FRDM / Contractor Resource Center), Operations Reporting Data Mart (ORDM), Pharmacy Reporting Data Mart (PRDM), and the Capital and Direct Medical Education (CAP/DME) reporting area.
Responsibilities:
1. Requirements Discovery & Comprehensive Gap Analysis
- Actively interface with DHA CRM financial managers, DHA Office of General Counsel (OGC), and operational users to identify business problems and elicit functional system needs.
- Conduct comprehensive cross-system gap analysis whenever changes occur (e.g., analyzing how upstream configuration or accounting rule adjustments in Oracle Federal Financials affect downstream EDW staging, archival layers, and data mart reports).
- Provide business analysis and requirements definitions for reporting reconciliations, data discrepancies, and workflow improvements.
2. System Requirements Documentation & RTM Governance
- Author, maintain, and update formal System Requirements Specifications (SRSs) for DHA ECS applications and operational interfaces (CDRL 0010), coordinating reviews to secure formal Government Contracting Officer Representative (COR) digital signatures.
- Build and maintain a bi-directional Requirements Traceability Matrix (RTM) for each application release, establishing complete traceability from initial stakeholder requirements through design specifications, software version builds, and test cases.
- Attach approved requirements packages and RTMs to Change Requests within the Solutions Business Manager (SBM) and Quality Center (QC) repositories to facilitate review by the Configuration Working Group (CWG) and Configuration Management Board (CMB).