Seeking a skilled ERP Specialist with robust experience in Oracle Business Intelligence Applications (OBIA) and Oracle Analytics Cloud (OAC). This role involves developing insightful dashboards, performing data visualization, and managing data flows. A strong understanding of RPD development across logical, physical, and presentation layers is crucial. You will be instrumental in investigating and resolving performance issues related to reports, queries, and data refresh jobs, ensuring the integrity and efficiency of our BI solutions.

Key responsibilities include designing and developing Oracle BI Publisher (BIP) and OTBI reports and dashboards to meet diverse functional and regulatory needs. You will translate complex business requirements into effective data models, precise SQL queries, and user-friendly report layouts, prioritizing accuracy, usability, and optimal performance. Building and maintaining data models, templates, bursting definitions, and subject areas aligned with Oracle Fusion data structures are also core duties. Furthermore, you will optimize reports for performance and scalability, implement security measures including row-level data access, and manage report scheduling and bursting according to organizational policies. Providing production support, conducting root-cause analysis, and implementing enhancements for existing reports are also vital aspects of this position.

Candidates should possess hands-on expertise with OBIA and OAC, including dashboards, data visualization, and data flows. Proficiency in RPD development (logical, physical, presentation layers) is essential. Experience in investigating performance issues, conducting root-cause analysis, and implementing permanent fixes is required. The ability to design and develop Oracle BI Publisher (BIP) and OTBI reports/dashboards, translate business requirements into data models and SQL queries, and build/maintain data models, templates, and bursting definitions is paramount. Understanding of dimensional modeling and the ability to design secure subject areas with row-level security are also necessary. Experience troubleshooting and optimizing OAC/OBIEE performance, coupled with strong communication skills to bridge business needs and analytics solutions, are vital for success in this role.