Data & Analytics Expert – Finance Systems

About the role

The Data & Analytics Expert will design, develop and support data integration, warehousing and analytics solutions for Finance Systems using Oracle ADW, ODI and OAC. The role works in a cloud‑based Oracle Fusion ERP environment and collaborates with multiple application teams to deliver reporting and analytical capabilities.

Key responsibilities

• Design, develop and maintain data warehouse solutions on Oracle ADW sourced from Oracle Fusion ERP, Oracle EBS R12.x and other systems.
• Build and monitor ETL/ELT pipelines using ODI, handling scheduling, load failures and performance tuning.
• Develop dashboards, reports, datasets and data flows in Oracle Analytics Cloud.
• Provide technical support for data‑warehousing, integration and analytics projects, meeting SLA KPIs.
• Perform performance tuning of ADW, ODI jobs and OAC content and resolve application/code bugs.

Required profile

• Bachelor’s degree or higher in IT/Computer Science or related field.
• 6+ years of hands‑on experience in data warehousing/BI development.
• Strong knowledge of financial and supply‑chain processes is an advantage.

Required skills

• Oracle Autonomous Data Warehouse (schema design, SQL/PL‑SQL, performance tuning).
• Oracle Data Integrator (mappings, packages, load plans, scheduling).
• Oracle Analytics Cloud (datasets, data flows, dashboards, semantic modeling).
• Advanced SQL & PL‑SQL, dimensional modeling (star schema), ETL/ELT best practices.
• Familiarity with Oracle Fusion tools (BICC, OTBI, BI Publisher, REST/SOAP APIs) is a plus.