Oracle Cloud Architect

Client is seeking an Oracle ERP Cloud – FDI/OAC Reports Lead to drive reporting initiatives within the Oracle Fusion Cloud ecosystem. This role requires strong technical proficiency in BI Publisher (BIP), Oracle Transactional Business Intelligence (OTBI), and Fusion Data Intelligence (FDI), along with working knowledge of Oracle ERP Fusion Cloud. The ideal candidate will bring extensive experience in designing, developing, and managing complex reports and dashboards using OTBI, BIP, and FDI. The selected professional will lead reporting and analytics initiatives across the Oracle Fusion Cloud ecosystem, ensuring high-quality design, development, and delivery of enterprise reporting solutions. The candidate is also expected to interact with customer process consultants and business SME to understand and analyze various processes, derive automation opportunities and make recommendations for cloud transformation. The ideal candidate will have a solid technical background, strong analytical skills, and hands-on experience building complex reports, dashboards, and data models across Oracle Fusion modules.

Required Qualifications:

• Location for this position is Irvine, CA. This position may require relocation and/or travel to client/project location.
• Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
• At least 7 years of Information Technology experience.
• 6+ years of experience in Oracle reporting and analytics.
• Manages the end-of-the-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.
• 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.
• 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).
• Experience working within the Oracle ERP Fusion Cloud environment.
• 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.
• 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.

Preferred Qualifications:

• Oracle Cloud certifications in Oracle Cloud Reporting & Analytics and OAC.
• Additional certification in SQL or BI tools (e.g., Tableau, Power BI).
• Exposure to legacy to Fusion data/report migration.
• Experience managing team size of 5-6 would be a plus.