Oracle Analytics Cloud (OAC) Consultant — (OBIEE Migration & Analytics)

Role Overview

We’re looking for a mid-level Oracle Analytics Cloud (OAC) Consultant with hands-on experience in OBIEE and a proven track record of delivering modern analytics on OAC. The role involves migrating legacy OBIEE reports and RPDs to OAC, building scalable semantic models, enabling self-service data visualization, and optimizing performance and security in cloud environments.

You’ll partner with business stakeholders, data engineers, and project managers to deliver high-quality dashboards, governed data models, and automated data pipelines on Oracle Cloud Infrastructure (OCI).

Key Responsibilities

OAC Development & Modeling

Build and enhance datasets, semantic models (Semantic Modeler/RPD), dashboards, and visualizations in OAC DV.
Design and implement row-level and object-level security, usage tracking, and catalog governance.
Create BI Publisher reports, schedules, and bursting for operational reporting.

OBIEE → OAC Migration

Migrate OBIEE RPDs, catalog objects, and prompts to OAC; modernize dashboards in DV while maintaining business logic.
Remediate functional gaps (narratives, custom scripts) and optimize for cloud scalability.
Use BAR exports/imports, data model conversion tools, and catalog migration best practices.

Required Qualifications & Skills

5–9 years in analytics focused on Oracle OAC/OBIEE (minimum 2–4 years in OAC).
Strong experience in semantic modeling (RPD or OAC Semantic Modeler), joins, hierarchies, time series, calculations, and security.
Hands-on experience with OAC DV, BI Publisher, and Catalog; ability to design clean, user-centric dashboards.
Proficiency in SQL (Oracle), performance tuning, and data sourcing (ADW/Autonomous DB, Oracle DB, Excel/CSV, REST).
Experience migrating from OBIEE 11g/12c to OAC, including RPD and catalog objects.
Familiarity with OCI services relevant to OAC (Network, Data Gateway, IDCS).
Strong analytical thinking, problem-solving, and communication skills.

Nice-to-Have (Preferred)

Experience with ODI, GoldenGate, or Oracle Data Integrator for ETL/ELT.
Knowledge of Essbase or OAC Enterprise features (if applicable).
Exposure to CI/CD for analytics (e.g., versioning models, automating BAR deployments).
Visualization best practices (design standards, accessibility, storytelling, KPI design).
Scripting (Python/SQL) for data prep, REST API usage for admin/automation.
Experience with Autonomous Data Warehouse (ADW) and materialized views for performance.

Oracle Analytics Cloud Consultant – OBIEE Migration Specialist