Oracle Business Intelligence Analyst

Oracle Business Intelligence Analyst (4932) at SMX (View all jobs) ()

United States

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.

• 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 contained 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 ad hoc 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

• 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
• Experience working with 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 level of 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 and ability to travel as part of DEAMS Deployment as required

2-6-2026

The SMX salary determination process takes into account a number of factors, including but not limited to geographic location, Federal Government contract labor categories, relevant prior work experience, specific skills, education, and certifications. At SMX, one of our core values is to invest in our people so we offer a competitive mix of compensation, learning & development opportunities, and benefits. Some key components of our robust benefits include health insurance, paid leave, and retirement.

The proposed salary for this position is: $89,100—$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 (i.e. H1B, F-1 OPT, F-1 STEM OPT, F-1 CPT, J-1, TN, E-2, E-3, L-1 and O-1, or any EADs or other forms of work authorization that require immigration support from an employer).