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 bachelor’s 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