Oracle Fusion Cloud FDI OAC Reports Lead

KAYGEN•Irvine, CA

3d•Onsite

About The Position

KAYGEN is seeking an Oracle Fusion Cloud FDI OAC Reports Lead for an onsite role in Irvine, CA. This is a 6+ month contract position. The role involves managing the end-to-end delivery of Oracle-based analytics, data warehousing, and reporting solutions. The lead will collaborate with functional teams to translate business requirements into technical designs, focusing on BI Publisher (BIP), OTBI, and Fusion Data Intelligence (FDI). Responsibilities include securing reports using RBAC, performance tuning, and leading data validation processes to ensure accuracy and adherence to security policies.

Requirements

7+ years of experience in Oracle reporting and analytics.
Strong hands‐on experience with BI Publisher (BIP), OTBI (Analytics, Dashboards, Subject Areas) and Fusion Data Intelligence (FDI)
Working knowledge of: Oracle Fusion duty roles, privileges, and data security
Proficiency in SQL, XML, XSLT, and data modeling techniques.
Strong understanding of Fusion data structures across key functional modules (FIN/SCM/HCM).
Excellent communication, documentation, and client‐facing skills.
Ability to communicate complex technology solutions to diverse teams namely, technical, business and management teams

Nice To Haves

Experience managing team size of 5-6 would be a plus

Responsibilities

Manages the end-to-end delivery of Oracle-based analytics, data warehousing, and reporting solutions
Work closely with functional teams to gather, interpret, and convert business requirements into detailed technical design documentation.
Securing OTBI and BIP reports using role-based access control (RBAC)
Performance tuning of BI extracts, OTBI queries, and custom data models.
Proficient in designing advanced report layouts using RTF, Excel, and PDF templates.
Strong experience in building XML data models, data sets, and complex report logic.
Skilled in configuring and managing bursting definitions for automated, rule-based report distribution
Expertise in developing dashboards and analyses across various subject areas.
Hands-on experience with Semantic Model Extension (SME), data augmentation, and Oracle Analytics Cloud (OAC).
Lead comprehensive data validation processes to ensure dashboard metrics accurately align with source data (OTBI/BIP) while upholding security policies and data modeling best practices.