Oracle EBS Technical Analyst

6 days ago

San Antonio, TX, United States Capital Consulting Full time
Job Summary:

We are seeking an experienced Oracle EBS Technical Analyst - Reporting & Integrations to support technical design, development, and optimization across a complex Oracle E-Business Suite (EBS) R12 environment. This role will work across multiple financial and procurement modules to deliver high-quality reporting solutions, build integrations, support data flows, and ensure system stability across environments.

The ideal candidate has strong expertise in SQL/PLSQL, Oracle reporting tools, EBS APIs/open interfaces, and interface development. This is a hands-on technical role that requires excellent analytical skills, deep familiarity with Oracle EBS data models, and the ability to translate functional requirements into scalable technical solutions.

Responsibilities:
  • Design, develop, and maintain Oracle EBS reports using BI Publisher/XML Publisher, Oracle Reports, OTBI (if applicable), and custom SQL/PLSQL.
  • Convert legacy or Discoverer-style reporting requirements into modern reporting components.
  • Troubleshoot and optimize existing reports for performance, accuracy, and reliability.
  • Build report templates, bursting definitions, parameter logic, and associated concurrent programs.
  • Develop, enhance, and support inbound/outbound integrations between Oracle EBS and external systems using flat files, APIs, web services, and secure file transfer protocols.
  • Build PL/SQL-based extract programs and staging logic to support interfaces and data flows.
  • Collaborate with functional teams to understand interface requirements and translate them into technical specs and data mapping documents.
  • Validate integration performance, error handling, and reconciliation reports.
  • Work within the Oracle EBS technical framework, including:
    • Concurrent programs
    • Value sets
    • Flexfields (KFF/DFF)
    • Personalizations and extensions
    • Workflow-based logic (basic exposure acceptable)
  • Create technical design documents (MD70), performance-optimized PL/SQL packages, functions, procedures, and APIs.
  • Participate in RICEW planning, estimation, development, and validation.
  • Create unit test scripts and perform unit testing for all developed components.
  • Support System Integration Testing (SIT) and User Acceptance Testing (UAT) by resolving defects and validating test evidence.
  • Work with QA and functional teams to ensure proper regression coverage during patches and releases.
  • Analyze long-running SQL queries, tune PL/SQL, optimize indexing strategies, and resolve performance bottlenecks.
  • Troubleshoot issues related to EBS concurrent managers, logs, data anomalies, and broken integrations.
  • Provide Tier 2/3 technical support for production environments, including root-cause analysis and long-term corrective actions.
  • Create and maintain technical documentation including:
    • Technical design specs
    • Interface mapping documents
    • Data flow diagrams
    • Runbooks
    • SOPs
  • Ensure all technical artifacts conform to project governance, quality standards, and change-control policies.
  • Maintain documentation updates as part of release readiness activities.
  • Partner with functional analysts, DBAs, and architects to ensure cohesive technical design decisions across modules.
  • Collaborate with data migration teams on extract logic and validation scripts.
  • Participate in architecture discussions, code reviews, and impact assessments for new features.
Required Qualifications:
  • Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.
  • 3-5+ years supporting Oracle E-Business Suite R12 as a technical analyst or developer.
  • U.S. citizenship and ability to obtain a federal security clearance.
  • CompTIA Security+ certification or ability to obtain before start.
  • Strong expertise in:
    • SQL/PL/SQL
    • BI Publisher/XML Publisher
    • Oracle Reports
    • EBS open interfaces/APIs
    • File-based integrations
  • Demonstrated ability to troubleshoot and optimize SQL and PL/SQL for large datasets.
  • Experience supporting reports and integrations in complex ERP programs.
  • Strong analytical and problem-solving skills with attention to detail.
  • Excellent written and verbal communication skills.
  • Ability to work in a remote environment with occasional travel onsite to Lackland Air Force Base in San Antonio, Texas.
Preferred Qualifications:
  • Familiarity with EBS Financials & Procurement data models (GL, AP, AR, PO, Projects).
  • Knowledge of Oracle Workflow concepts.
  • Experience with version control and CI/CD processes.
  • Exposure to Oracle EBS R12.2 online patching concepts.
  • Basic knowledge of Python or shell scripting for automation.
  • Oracle certifications:
    • Oracle PL/SQL Developer Certified Associate
    • Oracle EBS R12 Technical Specialist
    • Oracle Integration-related certifications
  • Experience working in public-sector or other highly regulated industries.

  • Oracle EBS Business Analyst

    2 weeks ago

    San Antonio, TX, United States SMX Corporation Full time

    Oracle EBS Business Analyst (4829)at SMX(View all jobs) (https://www.smxtech.com/careers/) San Antonio, TX SMX is seeking accomplished Business Analysts to collect, document, and analyze business requirements and configure Oracle E-Business Suite (EBS) solutions. Key responsibilities include gathering requirements, designing and implementing system...

  • Oracle EBS Business Analyst

    4 days ago

    San Antonio, TX, United States SMX Corporation Full time

    Oracle EBS Business Analyst (4829)at SMX(View all jobs) (https://www.smxtech.com/careers/) San Antonio, TX SMX is seeking accomplished Business Analysts to collect, document, and analyze business requirements and configure Oracle E-Business Suite (EBS) solutions. Key responsibilities include gathering requirements, designing and implementing system...

  • Oracle EBS Business Analyst

    1 week ago

    San Antonio, TX, United States SMX Corporation Full time

    Oracle EBS Business Analyst (4829)at SMX(View all jobs) (https://www.smxtech.com/careers/) San Antonio, TX SMX is seeking accomplished Business Analysts to collect, document, and analyze business requirements and configure Oracle E-Business Suite (EBS) solutions. Key responsibilities include gathering requirements, designing and implementing system...

  • Senior Oracle EBS Business Analyst

    4 days ago

    San Antonio, TX, United States SMX Corporation Full time

    Senior Oracle EBS Business Analyst (4828)at SMX(View all jobs) (https://www.smxtech.com/careers/) San Antonio, TX SMX is seeking accomplished Senior Business Analysts to collect, document, and analyze business requirements and configure Oracle E-Business Suite (EBS) solutions. Key responsibilities include gathering requirements, designing and implementing...

  • Oracle EBS Senior Business Analyst

    6 days ago

    San Antonio, TX, United States Capital Consulting Full time

    We are seeking an experienced Oracle EBS Senior Business Analyst - Treasury & Cash Management to lead functional design, testing, banking integrations, configuration, and operational support within a large-scale Oracle E-Business Suite (EBS) modernization effort. This role serves as the primary functional owner for Treasury and Cash Management, including...

  • Oracle EBS Senior Business Analyst

    4 days ago

    San Antonio, TX, United States Capital Consulting Full time

    We are seeking an experienced Oracle EBS Senior Business Analyst - Treasury & Cash Management to lead functional design, testing, banking integrations, configuration, and operational support within a large-scale Oracle E-Business Suite (EBS) modernization effort. This role serves as the primary functional owner for Treasury and Cash Management, including...

  • Oracle EBS Senior Business Analyst

    6 days ago

    San Antonio, TX, United States Capital Consulting Full time

    We are seeking an experienced Oracle EBS Senior Business Analyst - Treasury & Cash Management to lead functional design, testing, banking integrations, configuration, and operational support within a large-scale Oracle E-Business Suite (EBS) modernization effort. This role serves as the primary functional owner for Treasury and Cash Management, including...

  • Oracle EBS Project Manager

    1 week ago

    San Antonio, TX, United States SMX Corporation Full time

    Oracle Ebs Project Manager SMX is seeking accomplished Project Managers to lead Oracle E-Business Suite (EBS) projects - implementations, upgrades, migrations, and sustainment. Key responsibilities will involve managing project scope, budget, timeline, and resources, while coordinating with stakeholders, leading cross-functional teams, and ensuring project...

  • Oracle EBS Project Manager

    1 week ago

    San Antonio, TX, United States SMX Corporation Full time

    Oracle Ebs Project Manager SMX is seeking accomplished Project Managers to lead Oracle E-Business Suite (EBS) projects - implementations, upgrades, migrations, and sustainment. Key responsibilities will involve managing project scope, budget, timeline, and resources, while coordinating with stakeholders, leading cross-functional teams, and ensuring project...

  • Oracle EBS Project Manager

    1 week ago

    San Antonio, TX, United States SMX Corporation Full time

    Oracle Ebs Project Manager SMX is seeking accomplished Project Managers to lead Oracle E-Business Suite (EBS) projects - implementations, upgrades, migrations, and sustainment. Key responsibilities will involve managing project scope, budget, timeline, and resources, while coordinating with stakeholders, leading cross-functional teams, and ensuring project...