EBS OAC Developer

Job Description: EBS OAC Developer

Job Title: EBS OAC Developer
Location: 100% Remote
Employment Type: Long-Term Contract
Duration: Long-Term

Role Overview

We are looking for an experienced EBS OAC Developer to design, develop, and support Oracle Analytics Cloud (OAC) solutions integrated with Oracle E-Business Suite (EBS). The role will focus on analytics development, data modeling, reporting, dashboards, integrations, and performance optimization.

Key Responsibilities

• Develop and support Oracle Analytics Cloud (OAC) solutions for Oracle EBS data.
• Design and develop OAC dashboards, reports, visualizations, and data models.
• Work with Oracle EBS modules and underlying EBS data structures to support reporting and analytics requirements.
• Develop and maintain semantic models / RPD, subject areas, logical and physical data models.
• Create complex SQL queries, data sets, calculations, and analytics.
• Integrate OAC with Oracle EBS, Oracle Database, and other enterprise data sources.
• Develop and optimize data pipelines, ETL/ELT processes, and data integrations as required.
• Troubleshoot OAC reports, dashboards, data models, and connectivity issues.
• Perform performance tuning of dashboards, SQL queries, data models, and analytics workloads.
• Implement appropriate security, roles, permissions, and data-level access controls.
• Collaborate with functional teams to understand EBS reporting requirements and translate them into analytics solutions.
• Support production deployments, enhancements, testing, and ongoing maintenance.

Mandatory Skills

• Strong hands-on experience with Oracle Analytics Cloud (OAC).
• Strong experience with Oracle E-Business Suite (EBS) reporting and data.
• Experience developing OAC dashboards, reports, and visualizations.
• Strong knowledge of OAC semantic modeling / RPD.
• Strong SQL and Oracle Database skills.
• Experience with Oracle EBS data models and underlying tables.
• Experience with ETL/ELT and data integration.
• Experience with OAC security, user access, and administration concepts.
• Strong troubleshooting and performance-tuning experience.

Preferred Skills

• Experience with OBIEE/OAS in addition to OAC.
• Experience with Oracle Data Integrator (ODI).
• Knowledge of OCI and Oracle Autonomous Database.
• Experience with EBS modules such as Financials, Procurement, Order Management, or Supply Chain.
• Experience with enterprise-scale reporting and analytics implementations.
• Oracle Analytics or OCI certification is a plus.