Key responsibilities:
Design and support Finance and HCM analytics using Oracle FDI/FAW.
Develop FDI Key Metrics, workbooks, dashboards, visualizations, analyses, data flows, and Oracle Analytics Publisher reports.
Extend FDI semantic models, including facts, dimensions, measures, calculations, joins, hierarchies, and aggregation rules.
Translate business requirements into secure, scalable, and governed analytical solutions.
Reconcile FDI/FAW results with Oracle Fusion transactions, OTBI, BI Publisher, and other approved sources.
Manage analytical-content security and support testing, migrations, quarterly updates, and production issues.
Support data governance, metric definitions, lineage, data quality, documentation, and content certification.
Required skills:
Oracle FDI/FAW: Hands-on implementation or support experience with Oracle Fusion Data Intelligence or its predecessor, Fusion Analytics Warehouse.
Semantic modeling: Experience with FDI Semantic Model Extensions and dimensional-modeling concepts.
Oracle Analytics within FDI: Experience with Oracle FDI - Key Metrics, workbooks, dashboards, visualizations, datasets, data flows, analyses, and Publisher.
SQL: Strong querying, validation, reconciliation, troubleshooting, and performance-tuning skills.
Fusion knowledge: Working knowledge of Oracle Fusion Cloud Financials and HCM processes and data.
Security and governance: Experience with the Oracle Analytics Catalog, application roles, row-level security, data quality, lineage, and governed metrics.
Support and delivery: Experience with root-cause analysis, testing, quarterly-release validation, production support, documentation, and stakeholder communication.
Experience with Oracle PL/SQL, FDI Data Augmentation, ETL/ELT, data-pipeline troubleshooting, Power BI, Oracle EPM, OCI, or Oracle Database would be a plus.