Oracle OTBI & BI Publisher Reports Developer (Remote)

StaffXpert LLC; Town of Florida (NY); On-site; USD 120,000 - 160,000; Full time

Job summary

STAFFXPERT is seeking an experienced Oracle OTBI Consultant / BI Publisher Reports Developer for remote work with monthly travel to client locations. The role focuses on Oracle Fusion Cloud ERP, EBS R12, and FAW reporting, delivering GL, AP, AR, and procurement reports.

Responsibilities include designing and optimizing BI Publisher reports, tuning SQL, and supporting OIC interfaces. Travel involves two consecutive weeks onsite each month until project completion.

Qualifications

• Hands-on experience with Oracle OTBI, BI Publisher and ERP reporting platforms.
• Strong SQL/PL-SQL development experience for complex reporting.
• Experience with Oracle Fusion Cloud ERP and EBS R12 reporting modules.

Responsibilities

• Develop and maintain reports using Oracle Fusion OTBI and BI Publisher.
• Design and develop BI Publisher/XML Publisher reports and templates.
• Build reporting solutions across GL, AP, AR, Procurement and related ERP modules.
• Develop and optimize complex SQL queries for reporting and data extraction.
• Perform SQL/database performance tuning and code optimization.
• Develop and maintain PL/SQL packages, procedures, functions and triggers.
• Support interfaces and reporting objects used by Oracle Integration Cloud (OIC).
• Work with FAW when applicable and configure Fusion reporting security.

Skills

OTBI

BI Publisher

Fusion ERP

Tools

Oracle SQL

Oracle PL/SQL

XML Publisher

FAW

OIC

Job description

STAFFXPERT is seeking an experienced Oracle OTBI Consultant / BI Publisher Reports Developer for remote work with monthly travel to client locations. The role focuses on Oracle Fusion Cloud ERP, EBS R12, and FAW reporting, delivering GL, AP, AR, and procurement reports.

Responsibilities include designing and optimizing BI Publisher reports, tuning SQL, and supporting OIC interfaces. Travel involves two consecutive weeks onsite each month until project completion.