The Oracle Fusion Reporting & Analytics Developer will provide comprehensive reporting, analytics, and data intelligence solutions for our Oracle Fusion Cloud environment. This role will design, develop, and maintain enterprise reports using OTBI, Oracle Analytics Cloud (OAC), Oracle Analytics Server (OAS), and Fusion Data Intelligence (FDI). The ideal candidate will work closely with business stakeholders and data analysts to deliver actionable insights while modernizing legacy reporting processes.
Reporting & Analytics Development
Design, develop, and maintain OTBI reports and dashboards in Oracle Fusion Cloud. Create advanced analytics and visualizations in OAC and maintain OAS reports for on-prem needs. Build pixel-perfect BI Publisher reports for compliance and optimize dashboards using FDI.
Data Architecture & Integration
Leverage ADW for robust data models and Fusion Data Intelligence subject areas. Design optimized schemas for enterprise reporting, integrate data from ERP, HCM, SCM, and perform logical business modeling.
Legacy Modernization
Modernize PL/SQL processes and migrate OBIEE reports to OAC/OTBI. Refactor inefficient procedures for cloud architecture and document migration paths.
Performance & Optimization
Enhance query performance across OTBI, OAC, and ADW. Apply best practices for caching, aggregation, and indexing. Monitor and tune SQL/PLSQL for efficiency.
Collaboration & Compliance
Work with analysts to translate requirements into solutions, train users on OTBI/OAC/OAS, and ensure data quality with governance teams. Maintain technical documentation, user guides, and follow change management processes.
Project Management
Participate in agile ceremonies, provide status updates, and manage priorities using SCA tools.
Oracle Fusion & Cloud Analytics
OTBI: 3+ yrs building analyses, dashboards, and reports
OAC: 2+ yrs creating visualizations, data flows, and analytics
OAS: 2+ yrs developing dashboards/reports
BI Publisher: 4+ yrs designing templates, layouts, and data models
FDI: 2+ yrs working with subject areas, pipelines, and data warehouse
Database & Data Warehouse
ADW: 2+ yrs in architecture, SQL tuning, and modeling
Oracle DB 19c/21c: 5+ yrs advanced SQL, PL/SQL procedures
Data Modeling: Expertise in dimensional modeling, star schemas
ETL: Experience with ODI or similar tools
Legacy & Migration
EBS: Knowledge of data model and custom reports
OBIEE: Migration to OAC/OTBI
PL/SQL: Refactoring and optimization
Cloud Migration: Strategies and best practices
Technical Skills
Strong SQL/PLSQL, REST APIs, Git/SVN, OCI fundamentals, data security
Soft Skills
Excellent communication, client training, agile experience, detail-oriented, adaptable, collaborative
Oracle Cloud certifications (OAC, Fusion Applications, ADW)
Experience with Oracle Integration Cloud (OIC)
Knowledge of Oracle HCM, ERP, or SCM Cloud modules
Experience with data governance and master data management
Familiarity with AI/ML capabilities in Oracle Analytics Cloud
Python or R programming for advanced analytics
Never miss an opportunity! Create an alert based on the job you applied for.