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.
Essential Duties:
* 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
• Ability to 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 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
• 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.
Secret level security clearance is required
Additional skill sets:
• 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 Fix Assets
The successful candidate must also be willing and able to travel as part of DEAMS Deployment as required.
Application Deadline: 2-6-2026
# LI-SA
#CJPost
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.
At SMX®, we are a team of technical and domain experts dedicated to enabling your mission. From priority national security initiatives for the DoD to highly assured and compliant solutions for healthcare, we understand that digital transformation is key to your future success.
We share your vision for the future and strive to accelerate your impact on the world. We bring both cutting edge technology and an expansive view of what’s possible to every engagement. Our delivery model and unique approaches harness our deep technical and domain knowledge, providing forward-looking insights and practical solutions to power secure mission acceleration.
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).
Top Skills
Similar Jobs
What you need to know about the Los Angeles Tech Scene
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
