Oracle Cloud Fusion - Reporting with OAC/FDI

Job Title : Oracle Cloud Fusion - Reporting with OAC/FDI Location : Houston, TX 77092 (Hybrid) Duration: Long term contract Note- Onsite face to face interview About the Role We are seeking an experienced Oracle Cloud Fusion Reporting & Analytics Engineer to design and deliver enterprise-grade reporting and analytics solutions. This role requires deep expertise in Oracle Analytics Cloud (OAC) and Oracle Fusion Data Intelligence (FDI), combined with hands-on experience across Oracle Fusion Cloud modules. You will serve as a key analytics resource, bridging business requirements and technical delivery to drive meaningful insights across the organization. Key Responsibilities • Design, develop, and maintain analytics solutions using Oracle Analytics Cloud (OAC), including dashboards, data flows, and self-service reporting • Implement and manage Oracle Fusion Data Intelligence (FDI) pipelines, prebuilt decks, and KPI configurations • Build and extend FDI subject areas and data augmentation to meet custom business requirements • Develop reports using OTBI, BI Publisher, Financial Reporting Studio (FRS), and Smart View across Fusion modules • Configure and maintain OAC semantic models (RPD) and data visualizations • Partner with Finance, HR, Supply Chain, and other functional teams to translate business needs into analytics solutions • Monitor and optimize FDI data pipeline performance, refresh schedules, and data integrity • Manage OAC security, role-based access, and data-level permissions • Support quarterly Oracle Cloud release assessments for impact on OAC and FDI environments • Create and maintain technical documentation, data dictionaries, and user training materials • Mentor junior analysts and support self-service analytics adoption across the business Required Qualifications • 5+ years of experience in Oracle Cloud Fusion reporting and analytics • Hands-on experience with Oracle Analytics Cloud (OAC), including data visualization, data flows, and semantic layer configuration • Demonstrated experience with Oracle Fusion Data Intelligence (FDI), including prebuilt content, pipeline management, and augmentation • Proficiency with OTBI subject areas, BI Publisher, and Financial Reporting Studio (FRS) • Strong SQL skills; experience querying Oracle Fusion schema or Autonomous Data Warehouse (ADW) • Solid understanding of at least two Oracle Fusion modules (e.g., GL, AP, AR, HCM, SCM, Procurement) • Experience working with data models, dimensional modeling, and analytics best practices Preferred Qualifications • Experience extending FDI with custom subject areas, custom datasets, or third-party data sources • Familiarity with Oracle Autonomous Data Warehouse (ADW) as the FDI data store • Experience with OAC semantic model (RPD) development using Oracle Analytics Modeler • Knowledge of Oracle Fusion security model and its impact on data visibility in OAC/FDI • Oracle Cloud certifications (Oracle Analytics Cloud, Fusion ERP Implementation Specialist, or equivalent) • Exposure to Oracle AI/ML capabilities within OAC (forecasting, explain, anomaly detection) • Familiarity with Agile delivery methodologies Key Competencies • Strong stakeholder communication — able to present analytics findings clearly to executive and operational audiences • Meticulous about data accuracy, consistency, and governance • Self-starter who can manage competing priorities in a fast-paced environment • Collaborative mindset with experience working across IIT and business teams