Business Intelligence Analyst
- Aurora, United States
- $110K – $125K /yr
- Mid Level
- Bachelor's degree
- Posted
Skills
Required
- functional data modeling
- test coordination
- Government Invoicing
- G-Invoicing
- Analyze Intragovernmental Transactions
- IGT
- GT&C
Preferred
- Financial ERP Systems
- Oracle Federal Financials / Oracle E-Business Suite
- EBS
- General Ledger
- Git
- Jira
- Confluence
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.
About Tyto Athene, LLC
- Quantum Sky engineers the advantage across cyber, networks, software, and quantum because the mission demands dominance, not parity.
- We draw it.
- At Quantum Sky, we believe that success starts with our people.
- We foster a collaborative, innovative, and mission-driven environment where every team member plays a critical role in shaping the future of technology.
- Are you ready to join #TeamQuantumSky?
Responsibilities
- 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.
- 1.
- 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).
- Define functional requirements for ingesting and processing the CARS Transactional Data Extract (CTDE) within OFF and EDW to automate daily cash and disbursement reconciliations for Agency Location Code 97000012.
- Line of Accounting (LOA) & Common Cost Accounting Structure (CCAS): Perform functional requirements discovery and document data dictionary additions across OFF and EDW to support cost accounting reporting.
- Analyze updates in TEDS healthcare and pharmacy claims records, mapping schema changes to OFF claims processing extensions and EDW reporting repositories.
- Support functional analysis, data ingestion validation, and specialized financial reporting for CAP/DME data submitted by Managed Care Support Contractors.
- Collaborate directly with the CRM Financial Manager during biennial CRMSIT testing; identify specific test claim scenarios, define modified TED record values, and analyze payment calculation results.
- 4.
- Testing, User Acceptance & Defect Management Collaborate with Quality Assurance and Test Engineers to translate functional business requirements into rigorous test scenarios and scripts within HP Quality Center (QC) / ALM.
- assist users during test execution, capture test artifacts/screenshots, validate business logic, and help classify test defects as major, moderate, or minor.
- Verify that software modifications fully satisfy documented business requirements prior to CMB approval and production deployment.
- 5.
- Reporting Validation & User Enablement Validate ad hoc queries and standard reports generated via Oracle Analytics Server (OAS), BI Publisher, and SplashBI to ensure business logic accuracy and accounting integrity.
- Assist in developing application user training materials, user guides, and Standard Operating Procedures (SOPs) to support financial and operational users across DHA commands and MTFs.
- Ensure all functional reporting outputs adhere to Section 508 and WCAG 2.1 Level AA accessibility criteria.
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.
- 3.
- Federal Mandates & Enterprise Initiative Analysis Provide dedicated business analysis, functional data modeling, and test coordination for key contract initiatives: Government Invoicing (G-Invoicing): Analyze Intragovernmental Transactions (IGT) Buy/Sell business rules, General Terms and Conditions (GT&C), orders, performance, and fund settlement integration with OFF.
- BEA SFIS, Data Act & SLOA Compliance: Perform annual business analysis of the DoD Business Enterprise Architecture (BEA) standard release; define system and reporting changes required to sustain Standard Financial Information Structure (SFIS), Data Act, and Standard Line of Accounting (SLOA) compliance across OFF and EDW.
- Citizenship: Must be a U.S. Citizen (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.
- In lieu of a bachelor’s degree, fifteen (15) years of dedicated Business Analyst experience may be substituted).
- 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 contract.
Proven experience writing formal
- System Requirements Specifications (SRS), business process flows, functional design specifications, and maintaining bi-directional Requirements Traceability Matrices (RTM) Cybersecurity Certification: Must possess or obtain a DoD 8140.03 / DoDD 8570.01-M IAT Level II certification within three (3) months of hire.
- Working familiarity with data warehouse architecture (staging, archive, dimensional marts), ETL data flows, and BI tools (Oracle Analytics Server, OBIEE, BI Publisher, SplashBI).
- Working knowledge of DoD SFIS, SLOA, Treasury CARS, or G-Invoicing data standards.
- CBAP (Certified Business Analysis Professional), PMI-PBA (PMI Professional in Business Analysis), or similar credential is an asset.
Preferred
- 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 Ledger (USSGL), and federal accounting flows.
- Prior experience supporting DHA, TRICARE Encounter Data System (TEDS), MCSC healthcare claims processing, or pharmacy rebate reconciliations.
- 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.
- Must possess or be capable of obtaining a favorably adjudicated Tier 2 (T2) Public Trust / Non-Critical Sensitive IT-II background investigation (SF-85P / MBI) and receive a DoD Common Access Card (CAC) prior to accessing systems.
Pay
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 $110,000-$125,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
- Highlights of our benefits include Health/Dental/Vision, 401(k) match, Paid Time Off, STD/LTD/Life Insurance, Referral Bonuses, professional development reimbursement, and parental leave.
- The world the mission operates in is going post-quantum, contested, and machine-speed.
Location
Aurora, CO Shift: Staff must have the flexibility to support cyclical surges (e.g., month-end close, fiscal year-end in September/October) with flex-time arrangements between pay periods as pre-approved by the COR.
We don't follow the map.
Quantum Sky Engineering LLC is an Equal Opportunity Employer; all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, [sexual orientation, gender identity,] national origin, disability, status as a protected veteran, or any characteristic protected by applicable law.
jobapplier