Oracle EBS Technical Analyst – Reporting & Integrations

CAPITAL CONSULTING LLC•San Antonio, TX

36d•Remote

About The Position

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.

Requirements

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
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.

Nice To Haves

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.

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.