Senior Oracle Analytics Server (OAS) BI Developer

Dicetek LLC; Ajman; On-site; AED 120,000 - 200,000; Full time

Job summary

A leading technology solutions provider is seeking a skilled professional to develop and maintain Oracle BI solutions using Oracle Analytics Server. The ideal candidate should have over 5 years of experience in this area, along with strong SQL and PL/SQL knowledge, and proficiency in creating interactive dashboards and reports. The role requires a robust understanding of data warehousing, ETL processes, and user access control configurations.

Qualifications

• 5+ years of experience in designing and maintaining Oracle BI solutions.
• Experience in migrating from OBIEE to OAS.
• Strong understanding of dimensional modeling and ETL processes.

Responsibilities

• Develop and maintain Oracle BI solutions using OAS.
• Create interactive dashboards and reports leveraging OAS functionalities.
• Ensure user access controls and data security configurations.

Skills

Oracle Analytics Server (OAS)

SQL

PL/SQL

Data Visualizations

Oracle BI Publisher

Tools

Oracle Data Integrator (ODI)

Oracle Database

Job description

Technical Expertise

Core Expertise In Oracle Analytics Server (OAS)

• Proficiency in building interactive dashboards, pixel-perfect reports, and narrative visualizations using OAS.
• Strong understanding of the Oracle BI Repository (RPD):
• Physical Layer
• Business Model and Mapping (BMM) Layer
• Presentation Layer
• Experience in configuring row-level and column-level security and implementing user/role-based access controls in OAS.
• Mastery of Oracle BI Publisher for creating formatted reports.

Expertise in using Data Visualizations and custom features like map-based visualizations and geo-spatial analytics.

Database Skills

• Proficiency in SQL and PL/SQL for data manipulation and querying.
• Strong knowledge of Oracle Database, including:
• Query optimization
• Indexing and partitioning
• Working with Oracle Autonomous Data Warehouse (ADW)
• Familiarity with other databases (e.g., SQL Server, PostgreSQL) is a plus.

Data Warehousing And BI Concepts

• Strong understanding of:
• Dimensional modeling (Star Schema, Snowflake Schema)
• Fact tables, dimension tables, and aggregates
• ETL processes for loading and transforming data
• Experience with data warehousing tools like Oracle Data Integrator (ODI) or other ETL tools.

Experience Requirements

• 5+ years of experience in designing, developing, and maintaining Oracle BI solutions, including OAS or OBIEE.
• Experience in:
• End-to-end BI solution development.
• Migrating from Oracle Business Intelligence Enterprise Edition (OBIEE) to Oracle Analytics Server (OAS).
• Integrating OAS with external systems (e.g., APIs, Excel, or third-party BI tools).