Oracle Fusion Analytics Warehouse Professional - Data Modelling

Strong technical background in Data Warehouse and reporting concepts, including data modelling, ETL processes, and data integration.

Experience in Oracle Autonomous data warehouse (ADW), Data Modelling, Oracle SQL Developer, Data warehouse concepts and implementation, analytics, and advanced analytics concepts and implementation.

Solid understanding of Oracles analytics offerings including Fusion Analytics Warehouse (FAW), Oracle Analytics Cloud (OAC), Oracle Data Integrator (ODI), and Autonomous Data Warehouse (ADW)

Experience using programming languages for data analysis, data engineering, and transformation to answer business questions

Experience building models suited for interactive dashboard consumption

Experience in writing relational and multi-dimensional queries

Role Responsibilities

Development and maintenance of Oracle Fusion Analytics Warehouse: building data models, reports and dashboards, manage data model, data pipelines, security and perform any customizations.

Lead and own all technical aspects of FAW EPM implementations and/or customizations including data migrations, data quality, systems integrations, 3rd-party applications, and custom development.

Design, implement and maintain data models and schemas to support analytical reporting requirements.

Develop and implement reliable, consistent, and scalable data ingestion, transformation, and integration pipelines.

Develop and maintain the semantic model using best practice techniques.

Work on wide range of data sets and use cases to support different Planning & Reporting processes, and lead and drive the design of them

Enable FAW augmentation to support external data integration with other data platforms.

Collaborate with solution architects to design long-term data processing architectures, including data models and tools.

Evaluate data usage patterns, spotting opportunities for optimisation and efficiency improvements.

Support development and Test team(s) within the programme.