Oracle Fusion Data Analytics Specialist

Tipstat; Dubai; On-site; AED 120,000 - 200,000; Full time

Job summary

A dynamic technology company in Dubai is seeking an Oracle Fusion Data Intelligence Specialist to drive digital transformation through advanced data analytics. The role involves designing data models, managing ETL processes, and collaborating with cross-functional teams to produce impactful insights. Candidates should have proven experience with Oracle analytics tools and a strong background in SQL.

Qualifications

• Minimum 5 years experience with Oracle Fusion Data Intelligence and analytics.
• Advanced knowledge of SQL and PL/SQL.
• Expertise in data modeling and integration processes.

Responsibilities

• Design and implement advanced data models and dashboards.
• Manage ETL processes and integrate external data sources.
• Collaborate with teams to ensure analytics meet business needs.

Skills

Oracle Fusion Data Intelligence (FDI)

Oracle Analytics Cloud (OAC)

SQL

PL/SQL

Data Modeling

Oracle Data Integrator (ODI)

Oracle Autonomous Data Warehouse (ADW)

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)