Oracle HCM OTBI & BI Publisher Reporting Specialist

StaffXpert LLC; San Francisco (CA); On-site; USD 120,000 - 180,000; Full time

Job summary

STAFFXPERT LLC in San Francisco, CA, seeks an Oracle HCM/Reporting Consultant to lead OTBI and BI Publisher reporting initiatives. The role focuses on gathering requirements, designing and validating OTBI reports and dashboards, and delivering scalable data solutions.

You will develop OTBI prompts, tests, and interactive dashboards, while ensuring data accuracy and performance. Collaboration with HCM teams and IT is essential, with knowledge transfer and documentation emphasized.

Qualifications

• Strong hands-on experience with Oracle Fusion Cloud HCM reporting.
• Extensive experience developing Oracle OTBI reports, analyses, and dashboards.
• Strong expertise in Oracle BI Publisher (BIP) development.
• Experience with OTBI subject areas, prompts, filters, and calculated columns.
• Dashboards and drill-down reporting, bursting, and scheduling.
• Knowledge of Oracle HCM data structures and reporting subject areas.
• Experience with report testing, validation, reconciliation, and data troubleshooting.
• Ability to translate business requirements into scalable reporting solutions.
• Strong communication and stakeholder-management skills.

Responsibilities

• Gather, analyze, and document reporting requirements from business stakeholders and functional SMEs.
• Design, develop, test, and deploy OTBI reports, analyses, and dashboards.
• Develop BI Publisher reports, including data models, SQL queries, templates, layouts, bursting, scheduling, and parameters.
• Determine the appropriate reporting solution using OTBI or BI Publisher based on business, performance, formatting, and data requirements.
• Develop OTBI prompts, filters, calculated columns, measures, drill-downs, and interactive dashboards.
• Validate and reconcile report outputs against source data and business requirements.
• Troubleshoot data discrepancies, report failures, and performance issues.
• Optimize OTBI and BI Publisher reports for performance and scalability.
• Collaborate with Oracle HCM functional teams, technical teams, SMEs, and business stakeholders.
• Create technical documentation, report designs, data mappings, test results, and knowledge-transfer materials.
• Train business users on OTBI self-service reporting and support IT teams with BI Publisher development and maintenance.
• Support reporting changes related to Oracle Fusion Cloud updates.

Skills

Oracle Fusion Cloud HCM reporting

OTBI reporting

BI Publisher reporting

SQL

Data analysis

Tools

Oracle OTBI

BI Publisher (BIP)

SQL

Job description

STAFFXPERT LLC in San Francisco, CA, seeks an Oracle HCM/Reporting Consultant to lead OTBI and BI Publisher reporting initiatives. The role focuses on gathering requirements, designing and validating OTBI reports and dashboards, and delivering scalable data solutions.

You will develop OTBI prompts, tests, and interactive dashboards, while ensuring data accuracy and performance. Collaboration with HCM teams and IT is essential, with knowledge transfer and documentation emphasized.