Oracle Fusion Data Analytics Specialist

Tipstat; Dubai; On-site; AED 180,000 - 240,000; Full time

Job summary

Tipstat in Dubai is seeking an Oracle Fusion Data Intelligence Specialist to design and optimize FDI solutions and analytics for diverse operations.

You will build semantic models, implement ETL pipelines, and deliver dashboards using OAC, OTBI, and BICC to empower decision-making across the group. Strong SQL/PLSQL, ODI/OCI DI, and ADW expertise are essential for success in this role.

Qualifications

• Experience with Oracle Fusion Data Intelligence (FDI) and FAW.
• Advanced knowledge of Oracle Analytics Cloud (OAC).
• Expert SQL and PL/SQL.
• Data modelling and schema design expertise.
• Experience with ODI / OCI DI.
• Proficiency in ADW.
• Experience with BI Publisher OTBI and BICC.

Responsibilities

• Design build and extend FDI semantic models tailored to business requirements.
• Analyze and develop custom data models including OTBI PVO-based star schemas.
• Collaborate with business stakeholders to translate requirements into technical specifications.
• Perform setup configuration and migration activities within Fusion Data Intelligence Platform (FDIP).
• Lead and support end-to-end FDI or FAW implementation cycles.
• Document implementation processes and maintain technical documentation.
• Develop and optimize reports and dashboards using Oracle Analytics Cloud (OAC) and ADW.
• Create and fine-tune SQL queries and PL/SQL scripts for data extraction and manipulation.
• Utilize BI Publisher OTBI and BICC for report generation and data integration.
• Implement and manage ETL processes using ODI and OCI DI.
• Integrate external data sources into FDI and ADW environments.
• Monitor and optimize data pipelines for performance and reliability.
• Work with cross-functional teams and provide FDI support and improvements.

Skills

SQL

PL/SQL

Data modeling

Schema design

FDI

OAC

ETL

ODI

OCI DI

ADW

OTBI/BICC

Tools

ODI

OCI DI

ADW

OTBI

BICC

Job description

The Oracle Fusion Data Intelligence Specialist at Group will play a pivotal role in driving the organizations digital transformation by leveraging Oracle Fusion Data Intelligence (FDI) and related analytics technologies. As part of the Digital and Transformation division within the Corporate Cluster the specialist will be responsible for designing implementing and optimizing advanced data models reports and dashboards to support business decision-making across the groups diverse operations. This role is critical in ensuring that data from Oracle Fusion ERP HCM SCM and CX modules is effectively harnessed to deliver actionable insights and enhance operational efficiency. Working closely with the Manager of Data Strategy and Analytics the specialist will lead the setup configuration and migration of FDI solutions integrate external data sources and support the development of robust ETL processes. The successful candidate will collaborate with cross-functional teams to ensure that analytics solutions align with business needs adhere to best practices and support teams vision of being a global leader in trade and logistics innovation.

Data Modeling and Solution Design

(25% of time)

• Design build and extend FDI semantic models tailored to business requirements.
• Analyze and develop custom data models including OTBI PVO-based star schemas.
• Collaborate with business stakeholders to translate requirements into technical specifications.

Implementation Setup and Migration

(20% of time)

• Perform setup configuration and migration activities within Fusion Data Intelligence Platform (FDIP).
• Lead and support end-to-end FDI or FAW implementation cycles.
• Document implementation processes and maintain technical documentation.

Reporting and Analytics Development

(25% of time)

• Develop and optimize reports and dashboards using Oracle Analytics Cloud (OAC) and ADW.
• Create and fine-tune SQL queries and PL/SQL scripts for data extraction and manipulation.
• Utilize BI Publisher OTBI and BICC for report generation and data integration.

ETL and Data Integration

(20% of time)

• Implement and manage ETL processes using Oracle Data Integrator (ODI) and OCI Data Integration (OCI DI).
• Integrate external data sources into FDI and ADW environments.
• Monitor and optimize data pipelines for performance and reliability.

Collaboration Support and Continuous Improvement

(10% of time)

• Work closely with cross-functional teams to ensure analytics solutions meet evolving business needs.
• Provide technical support and troubleshooting for FDI-related issues. Stay updated on emerging Oracle technologies and recommend improvements.

Requirements

• Oracle Fusion Data Intelligence (FDI) / Fusion Analytics Warehouse (FAW) (Advanced)
• Oracle Analytics Cloud (OAC) (Advanced)
• SQL and PL/SQL (Expert)
• Data Modeling and Schema Design (Advanced)
• Oracle Data Integrator (ODI) / OCI Data Integration (OCI DI) (Advanced)
• Oracle Autonomous Data Warehouse (ADW) (Intermediate)
• BI Publisher OTBI and BICC (Intermediate)