Oracle HR Reports Developer

Overview

Oracle HR Reports Developer responsible for designing and managing enterprise HR reporting and analytics across Oracle BI Publisher (BIP), OTBI, FDI, and FAW / Lakehouse for global HR and related teams.

What you'll do

• Design, develop, and maintain Oracle BI Publisher (BIP) reports and templates (RTF, Excel, eText).
• Build and optimize data models and SQL queries, including flexfield-based reporting solutions.
• Configure report bursting, scheduling, and automated distribution for BIP.
• Develop and maintain OTBI analyses, dashboards, KPIs, and self-service reporting experiences.
• Design and build FDI dashboards/reports/analytics, including subject areas, semantic model extensions, and security.
• Configure and optimize FAW environments and extend lakehouse integrations using ODI, OCI Object Storage, APIs, and ETL.

What you'll need

• 5+ years of Oracle HCM reporting and analytics experience in a SaaS environment.
• Hands-on expertise with Oracle BI Publisher, including data models, SQL, flexfields, bursting, and report development.
• Advanced knowledge of OTBI analyses, dashboards, and Oracle HCM subject areas.
• Proficiency in Oracle SQL and PL/SQL for reporting and data extraction.
• Experience with Oracle FDI, FAW, or Oracle Analytics Cloud (OAC), including dashboard development and semantic modeling.
• Understanding of data warehousing concepts such as dimensional modeling and incremental data loads.