Title: Oracle Fusion Reporting & Analytics Developer
Duration: Full Time
Statement of the Job
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.
Required Skills & Experience
- Oracle Transactional Business Intelligence (OTBI): 3+ years developing subject area analyses, dashboards, and reports
- Oracle Analytics Cloud (OAC): 2+ years creating data visualizations, data flows, and advanced analytics
- Oracle Analytics Server (OAS): 2+ years developing dashboards and reports
- BI Publisher: 4+ years building complex templates, layouts, and data models
- Fusion Data Intelligence (FDI): 2+ years working with FDI subject areas, pipelines, and data warehouse
Database & Data Warehouse
- Oracle Autonomous Data Warehouse: 2+ years experience with ADW architecture, SQL optimization, and data modeling
- Oracle Database 19c/21c: 5+ years with advanced SQL, PL/SQL stored procedures, functions, and packages
- Data Modeling: Strong understanding of dimensional modeling, star schemas, and data warehouse concepts
- ETL/Data Integration: Experience with Oracle Data Integrator (ODI) or similar tools preferred
Legacy Systems & Migration
- Oracle E-Business Suite (EBS): Understanding of EBS data model and custom reports
- OBIEE 12c: Experience migrating from OBIEE to OAC/OTBI preferred
- PL/SQL Modernization: Proven ability to refactor and optimize legacy database code
- Migration Methodologies: Knowledge of cloud migration strategies and best practices
Technical Skills
- Strong SQL and PL/SQL programming capabilities
- Understanding of REST APIs and web services for data integration
- Experience with version control systems (Git, SVN)
- Knowledge of Oracle Cloud Infrastructure (OCI) fundamentals
- Familiarity with data security and role-based access controls
Soft Skills & Work Style
- Excellent verbal and written communication skills
- Strong client interface and training abilities
- Ability to work under pressure and adapt to changing priorities
- Detail-oriented with strong process improvement mindset
- Collaborative team player who can also work independently
- Experience in agile/scrum methodology and ceremonies
Preferred Qualifications
- 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
Bachelor's Degree in Computer Science, Information Systems, Business, or related technical discipline
Equivalent combination of education and relevant work experience will be considered