> Markdown version of [/jobs/ext/2835597-oracle-otbi-consultant](https://www.wearedevelopers.com/jobs/ext/2835597-oracle-otbi-consultant). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Oracle OTBI Consultant

- **Company:** Apton Inc
- **Location:** United States (Remote available)
- **Contract:** Permanent contract
- **Skills:** Data Analysis, Cloud Computing, Data Validation, Data Integrity, Data Security, Data Structures, Database Schema, Oracle (Applications), Oracle SQL Developer, Performance Tuning, PL-SQL, Oracle Fusion Middleware, Bi Publisher, Netsuite Erp, Xml Publisher, Oracle Ebusiness, Oracle Erp, Oracle Integration
- **Published:** September 10, 2026
- **Apply:** https://www.dice.com/job-detail/d868518f-1099-4557-a896-b800ee04e671

## About the Role

Job Summary We are looking for an experienced Oracle BI Publisher Reports Developer / PL/SQL Engineer with robust expertise in Oracle Fusion Cloud ERP, Oracle E-Business Suite R12, BI Publisher, OTBI, XML Publisher, and Oracle PL/SQL.

The candidate will be responsible for designing, developing, optimizing, and supporting enterprise reporting solutions across GL, AP, AR, Procurement, and other Oracle ERP modules.

Must-Have Skills Strong experience in Oracle Fusion Cloud ERP reporting, including OTBI, BI Publisher, and reporting security such as roles and data access sets. Hands-on experience with Oracle E-Business Suite R12 reporting, preferably using BI Publisher/XML Publisher.

Solid knowledge of Oracle PL/SQL, XML Publisher, and BI Publisher. Ability to design and develop XML Publisher and BI Publisher templates. Experience working with functional teams to gather requirements and deliver technical solutions for GL, AP, and AR. Robust SQL skills with experience in query development, optimization, and performance tuning.

Experience developing and maintaining PL/SQL packages, procedures, functions, and triggers, including packages supporting Oracle Integration Cloud interfaces.

Strong understanding of Oracle GL, AP, and AR tables and data structures.

Experience implementing data validation, error handling, data integrity, and performance tuning in PL/SQL solutions.

Ability to prepare technical documentation and provide production support for reports and database objects.

Excellent communication and stakeholder management skills.

Key Responsibilities 1. Oracle Fusion & EBS Reporting Design, develop, enhance, and optimize reports using Oracle Fusion OTBI and BI Publisher. Work with Fusion Analytics Warehouse (FAW) where applicable.

## Description

Location: Remote + traveling to a client warehouse for two consecutive weeks every month until the project is completed.


## Related Videos

- [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story)
- [Micro-frontends anti-patterns](https://www.wearedevelopers.com/videos/420-micro-frontends-anti-patterns)
- [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents)
- [Parquet, Delta, Iceberg & Ducklake - An introduction for developers](https://www.wearedevelopers.com/videos/100075-parquet-delta-iceberg-ducklake-an-introduction-for-developers)
- [Recruitment Reinvented: Bold strategies and the $10K signing incentive](https://www.wearedevelopers.com/videos/1068-recruitment-reinvented-bold-strategies-and-the-10k-signing-incentive)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [Generating ODF Files in JavaScript — Without LibreOffice](https://www.wearedevelopers.com/magazine/752-generating-odf-files-in-javascript-without-libreoffice)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)
- [The Best Job Search Websites of 2025](https://www.wearedevelopers.com/magazine/368-the-best-job-search-websites-of-2025)