Oracle FDI Visualization and Analytics Engineer

JOB DESCRIPTION

TITLE
Oracle FDI Visualization and Analytics Engineer(Remote)

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

Few important things:

• Client need someone who has been through an FDI implementation.
• Guide TWU and validate what the Oracle implementation team is doing
• Then be the SME for the FDI environment going forward
• This is a very hands on/technical role as well as guidance and consulting with TWU on how to best standup the tool/environment
• They need to be an expect on the analytics/visualization side
• This is not a data engineering role, pipeline building, etc. but they need to understand that and how to partner with the data engineering team to request data and understand where its coming from and what's needed to develop the visualizations.

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.