Kearney & CompanyRemote
Oracle Business Intelligence Analyst
United States of America
Full Time
1 week ago
$80,000 - $140,000 USD
No H1B
Key skills
Oracle Business Intelligence Enterprise Edition (OBIEE)Oracle Analytics Server (OAS)Structured Query Language (SQL)Enterprise Resource Planning (ERP)Financial modules - General LedgerFinancial modules - Accounts PayableFinancial modules - Accounts ReceivableFinancial modules - ProjectsFinancial modules - PurchasingFinancial modules - Fixed AssetsAgile software developmentScrumScaled Agile Framework (SAFe)SQLBusiness IntelligenceOracleERPAgile
About this role
Kearney & Company is seeking an Oracle Business Intelligence Analyst to join our team. The successful candidate will serve as a key member of the DEAMS FMO Reports team, providing critical business development assistance and supporting the development and deployment of the Defense Enterprise Accounting Management System (DEAMS). Responsibilities include creating and modifying reports, performing data analysis, and participating in process improvement workshops.
Responsibilities:
- Create, modify, and monitor OBIEE/OAS reports
- Perform ad-hoc query research and advanced data analysis
- Validate data integrity by developing complex Structured Query Language (SQL) to ensure accurate data granularity between the core system and reporting outputs
- Resolve complex reporting issues escalated from the help desk, accurately distinguishing between operational user errors and systemic flaws
- Review tickets to determine if architectural design changes are required
- Research and optimize SQL used within the reporting environment
- Develop requirements and execute functional and performance testing for DEAMS reports
- Review technical and functional design documents
- Participate in process improvement workshops to identify gaps, document workflows, and engineer effective solutions
- Apply Agile software development practices, leveraging Scrum-based methodologies and the Scaled Agile Framework (SAFe) to deliver reporting solutions
Requirements:
- Minimum 5 years of operational and design experience in enterprise ERP environments, with proven hands-on experience using a reporting and query tool such as Oracle, SQL Developer, or similar, to support data analysis, performance tuning, and system design activities
- Advanced ability to write, analyze, and optimize complex SQL
- Familiarity with core financial modules, including General Ledger, Accounts Payable, Accounts Receivable, Projects, Purchasing, and Fixed Assets
- Must be willing and able to travel as required to support DEAMS deployment activities at various locations
- Ability to obtain a U.S. secret level security clearance (requires US Citizenship)
- Masters Degree
- Strong understanding of Air Force Financial Management processes