Oracle FDI Visualization and Analytics Engineer

JOB DESCRIPTION

TITLE
Oracle FDI Visualization and Analytics Engineer(remote)
6 month contract to start

JOB SUMMARY
Oracle FDI Visualization and Analytics Engineer designs, develops, and supports governed Finance and HCM analytics in Oracle Fusion Data Intelligence (FDI).

The role extends FDI semantic models and delivers metrics, dashboards, visualizations, analyses, and Publisher reports. Working with Finance, Human Resources, Payroll, data engineering, and leadership, the engineer translates requirements into secure, scalable solutions; validates results; and supports custom content through Oracle's quarterly update cycle.

As a member of Finance Strategy and Operations, the engineer contributes to a collaborative, human-centered, innovative, accountable, transparent, and inclusive culture. This is an on-site position, with alternative work options available as a benefit.

ORGANIZATIONAL RELATIONSHIPS
Reports to: Associate Vice President or Executive Director of Finance Strategy and Operations

Supervises: No supervisory responsibilities

They are implementing Oracle FDI and need a strong resource to help with the implementation and then support it. Oracle is going to assist them with the basic implementation but this person would be involved from the beginning as well.

FDI has been around since 2018 and had a couple different names like:

Oracle Fusion Data Intelligence (FDI) was previously known as Oracle Fusion Analytics Warehouse (FAW), and earlier in that product line as Oracle Analytics for Applications (OAX).

*** Note: OTBI and BI Publisher experience is beneficial but not sufficient . We need analytics professional ( not a report developer ), with strong Finance and HCM data experience using FDI/FAW or Oracle Analytics for Fusion ERP/HCM. Candidates must have hands-on experience developing FDI semantic models, governed metrics, dashboards, reconciliations, and security.***

This is not an ETL developer, its more focused on the semantic layer and developing dashboards, strong SQL is needed for this.

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.

ESSENTIAL DUTIES May include, but not limited to the following:

FDI Analytics, Semantic Model, Dashboard Delivery and Support (75%)

• Design, develop, administer, and support Finance and HCM analytics using FDI Key Metrics, workbooks, dashboards, visualizations, analyses, datasets, data flows, and Publisher reports.
• Extend and maintain FDI semantic models, including facts, dimensions, hierarchies, measures, calculations, joins, aggregation rules, time-series logic, and presentation-layer objects.
• Develop governed business metrics with consistent definitions, calculations, dimensional behavior, security, and reconciliation rules.
• Work with Finance, Human Resources, Payroll, and functional analysts to translate, prioritize, and validate requirements as scalable solutions that maximize delivered FDI functionality.
• Partner with data engineers on FDI data augmentation, external data, custom warehouse objects, and delivered-model extensions.
• Reconcile FDI results with Oracle Fusion transactions, OTBI, BI Publisher, and other approved sources; investigate variances in refreshes, calculations, aggregation, joins, security, and business rules.
• Manage Oracle Analytics Catalog permissions, application roles, object-level access, and row-level security for sensitive Finance and HCM data.
• Diagnose and resolve data, semantic-model, performance, usability, reporting, and security issues.
• Perform unit, integration, regression, and user-acceptance testing, including validation of Oracle quarterly updates and FDI enhancements.
• Provide production support, including incident and defect resolution, release coordination, and stakeholder communication.

Governance, Architecture, & Continuous Improvement (15%)

• Serve as the FDI subject-matter expert for semantic modeling, analytics architecture, metric governance, visualization, and Finance and HCM analytics.
• Partner with data owners, stewards, functional teams, information security, and governance bodies to maintain trusted business definitions, metrics, calculation rules, hierarchies, and reporting standards.
• Maintain the FDI analytics catalog and data dictionary, including content inventories, business definitions, calculations, sources, lineage, refresh schedules, security classifications, ownership, and intended audiences.
• Establish data-quality and reconciliation controls for critical Finance and HCM metrics; document issues, impacts, ownership, remediation, and resolution.
• Apply university requirements for data governance, classification, security, privacy, records retention, and acceptable use to FDI data and content.
• Maintain FDI solutions in accordance with applicable Texas DIR standards, TAC Chapter 202, the DIR Security Control Standards Catalog, and other state and federal requirements.
• Apply approved classification, handling, role-based access, least-privilege, separation-of-duties, and data-protection controls to sensitive information.
• Maintain evidence supporting security and access reviews, risk assessments, audits, and compliance activities.
• Establish standards for semantic models, metrics, content, documentation, testing, deployment, certification, and change control.
• Review and certify trusted content and retire duplicate, obsolete, inconsistent, or unsupported analytical assets.
• Assess Oracle updates and FDI changes; coordinate impact analysis, testing, remediation, documentation, and communication.

Participation & Collaboration (10%)

• Collaborate on university initiatives involving Oracle Cloud, FDI adoption, reporting modernization, data governance, and enterprise analytics.
• Facilitate requirements and design sessions that align stakeholder needs, constraints, and institutional objectives.
• Communicate findings, data limitations, risks, dependencies, and recommendations clearly to technical and non-technical audiences.
• Support release planning, acceptance testing, change management, incident reviews, governance forums, vendors, and Oracle support.
• Develop documentation and provide training, mentoring, and knowledge transfer to support adoption and continuity.

EDUCATION
Bachelor's degree required. Additional job-related experience may substitute for the required education on a year-for-year basis.

EXPERIENCE
Five to seven years of enterprise analytics or business intelligence experience, including hands-on implementation or support of Oracle Fusion Data Intelligence (formerly Fusion Analytics Warehouse).

REQUIREMENT
Regular and reliable attendance at the University during regularly scheduled days and work hours is an essential function of this position.

EXPERIENCE, KNOWLEDGE, SKILLS, AND ABILITIES The following are essential:

• Hands-on experience with FDI and embedded Oracle Analytics capabilities, including Key Metrics, workbooks, dashboards, visualizations, datasets, data flows, analyses, and Publisher reports.
• Experience extending FDI semantic models using facts, dimensions, hierarchies, measures, calculations, joins, aggregation rules, time-series logic, and presentation-layer objects.
• Strong knowledge of dimensional modeling, including grain, conformed dimensions, star schemas, effective-dated data, slowly changing dimensions, and aggregation.
• Strong SQL skills for querying, analysis, reconciliation, troubleshooting, and performance tuning across Oracle Fusion, FDI, and related analytical data structures.
• Working knowledge of Oracle Fusion Cloud Financials and HCM and the ability to translate requirements into scalable, secure, and maintainable analytics.
• Ability to reconcile analytical results with Oracle Fusion transactions, OTBI, BI Publisher, and other approved sources; investigate variances; and document calculation logic.
• Experience managing content, security, and migrations using the Oracle Analytics Catalog, application roles, object- and row-level permissions, and FDI Bundles.
• Knowledge of data governance and security, including metric definitions, stewardship, lineage, data quality, classification, retention, certification, Texas DIR requirements, TAC Chapter 202, and university policies.
• Experience supporting production analytics, including incident resolution, root-cause analysis, performance optimization, change control, testing, and quarterly-release validation.
• Strong analytical, troubleshooting, documentation, communication, collaboration, and prioritization skills.

Additional / Preferred

• Experience with delivered FDI Finance and HCM content, Oracle Analytics Cloud, OTBI, BI Publisher, or Oracle Analytics Client Tools.
• Experience with FDI Data Augmentation or External Application Merge, including external datasets, custom warehouse objects, mappings, business keys, joins, and refresh schedules.
• Working knowledge of data engineering and ETL/ELT, including troubleshooting pipelines, refresh failures, rejected records, data-quality issues, and source-to-warehouse reconciliation.
• Working knowledge of Oracle PL/SQL for developing or troubleshooting views, procedures, functions, and scripts supporting analytics, reconciliation, and performance optimization.
• Experience with Microsoft Power BI, Oracle EPM, Oracle Autonomous AI Lakehouse, OCI, Oracle Database, or Oracle data-integration services.
• Advanced functional knowledge of one or more Oracle Fusion Cloud Financials or HCM areas.
• Higher education, government, or public-sector experience, including accessible analytics, regulatory reporting, or familiarity with FERPA, HIPAA, SOC 2, TX-RAMP, or related requirements.
• Relevant Oracle certification in FDI, Oracle Analytics, OCI, Fusion Cloud Financials, HCM, or a related technology.