Oracle Reporting Specialist

This is a remote position.

Role Summary

We are seeking an experienced Oracle OTBI & BI Publisher Reports Specialist with deep expertise in Oracle Fusion reporting tools. The role involves designing developing and delivering high-quality reporting solutions across Finance and HCM domains ensuring accuracy performance and alignment with business needs. The ideal candidate will have strong analytical capabilities hands-on experience with Oracle reporting technologies and the ability to collaborate effectively with cross-functional stakeholders.

Key Responsibilities

• Gather and document business reporting requirements from stakeholders
  
• Translate functional specifications into scalable technical reporting solutions
  
• Design and develop OTBI analyses dashboards and reports
  
• Develop and maintain BI Publisher (BIP) reports including data models and templates
  
• Create and manage report layouts (RTF Excel) with standardized formatting
  
• Configure report bursting scheduling and automated distribution
  
• Validate data to ensure accuracy consistency and reliability
  
• Troubleshoot and resolve report performance issues and data discrepancies
  
• Optimize existing reports for performance and usability improvements
  
• Implement and manage report-level security and access controls
  
• Manage version control and deployments using CI/CD pipelines
  
• Collaborate with Finance HR Procurement and IT teams to support reporting needs
  
• Prepare technical documentation user guides and training materials
  
• Provide end-user training and ongoing support
  

Required Skills & Competencies

Technical Skills

• Strong expertise in Oracle OTBI report and dashboard development
  
• Advanced proficiency in BI Publisher (data models templates bursting scheduling)
  
• Expertise in Oracle Fusion HCM Extracts and ERP reporting tools
  
• Hands-on experience with Oracle Business Intelligence Cloud Connector (BICC)
  
• Strong understanding of Oracle Fusion data models schemas and subject areas
  
• Advanced SQL and data manipulation skills
  
• Experience with CI/CD pipelines and automated deployment processes
  
• Strong data visualization and reporting design capabilities
  

Core Competencies

• Strong analytical and problem-solving skills
  
• Ability to translate business requirements into technical solutions
  
• Excellent communication and stakeholder management skills
  
• Ability to work in a multicultural and collaborative environment
  
• Strong organizational and time management skills
  
• High client orientation and adaptability to changing requirements
  
• Mentorship capability for junior team members and stakeholders
  

Education & Certifications

Required

• Advanced degree in Computer Science Information Systems Statistics Mathematics Economics or a related field
  
• Alternatively a bachelors degree with additional relevant experience may be considered
  

Desirable

• Certifications in Oracle OTBI / BI Publisher
  
• Knowledge of Agile PRINCE2 or ITIL Foundation
  
• Basic project management certification (e.g. PRINCE2 Foundation)
  

Experience Requirements

Required

• Minimum 10 years of professional experience in:
  • Business Intelligence & Data Analytics
    
  • Data Visualization & Reporting
    
  • Software Development or Data Engineering
    
• Proven expertise in:
  • OTBI and BI Publisher report development
    
  • HCM Extracts for reporting
    
  • BICC configuration scheduling and data extraction
    

Desirable

• Experience with alternative data extraction tools beyond BICC
  
• Hands-on experience with:
  • Oracle Fusion Cloud HCM
    
  • Oracle Fusion Cloud Financials (ERP)
    
• Experience with Fusion Desktop Integration (FDI)
  
• Experience in HCM Extracts for system integrations
  

Key Deliverables

• OTBI dashboards and analytical reports aligned with business needs
  
• BI Publisher reports (operational and pixel-perfect formats)
  
• Data models and templates (RTF Excel)
  
• Configured report bursting and automated distribution
  
• Version-controlled artifacts and CI/CD deployment packages
  
• Performance-optimized reporting solutions
  
• Comprehensive documentation including:
  • Technical design documents
    
  • Data mapping and logic documentation
    
  • Deployment and pipeline documentation
    
  • User manuals and training materials
    
• Data validation and reconciliation reports