Oracle Business Intelligence Analyst

Oracle Business Intelligence Analyst (4932)

SMX is looking for a highly skilled Oracle Business Intelligence Analyst to join our team. The successful candidate will be responsible for developing and maintaining reports using Oracle software that meet the needs of our client. The candidate will work with other project team members to deliver work products timely and with quality. This position is remote.

Responsibilities:

• Provide analysis and problem resolution for fixes to reporting issues escalated from the help desk team
• Review help desk tickets to determine if they require a design change
• Create, modify, and monitor Discoverer Reports
• Create, modify, and monitor OBIEE Reports
• Analyze and develop complex SQL to compare data within the system to validate that it matches the data at the correct level of grain within the OBIEE Reports System
• Maintain the Discoverer End User Layer with deployment document updates to the PMO and DBAs
• Develop requirements and perform functional and performance testing for DEAMS reports
• Perform adhoc query research and analysis
• Research and optimize SQL used for Discoverer and OBIEE Reports
• Review functional and technical design documents
• Participate in process improvement workshops
• Identify processes, document gaps, and provide solutions to bridge gaps and enhance processes
• Knowledge of Agile software development practices, including Scrum-based methodologies like SAFe

Required

Skills & Experience:

• Thorough understanding and hands on experience with Business Intelligence Applications and SQL
• 5+ years of working and design experience in Oracle ERP Applications
• Secret level security clearance is required
• Experience working Oracle R12
• Ability to analyze user reported errors to determine if the error is operational or systemic
• Knowledge and experience in Air Force Financial Management
• Oracle Business Intelligence Enterprise Edition (OBIEE)
• Deep knowledge and hands on experience with Oracle Discoverer, OBIEE, and Structured Query Language
• Knowledge of General Ledger, Accounts Payables, Accounts Receivables, Projects, Purchasing, and Fixed Assets
• Willingness to travel as part of DEAMS Deployment as required

Final date to receive applications: 2-6-2026

Salary: $89,100 USD - $148,500 USD

SMX is an Equal Opportunity employer including disabilities and veterans. Selected applicant may be subject to a background investigation and/or education verification. SMX does not sponsor a new applicant for employment authorization or immigration related support for this position.