Oracle HCM / Reporting Consultant

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

Contract Duration: 12+ Months

Job Summary

STAFFXPERT LLC is seeking an Oracle HCM / Reporting Consultant on behalf of our client in San Francisco, CA. The ideal candidate will have strong hands-on experience with Oracle Fusion Cloud HCM, Oracle Transactional Business Intelligence (OTBI), BI Publisher (BIP), and SQL.

This role will focus on gathering reporting requirements, developing and optimizing reports and dashboards, validating data, troubleshooting reporting issues, and providing knowledge transfer to business and IT teams.

Key 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.

Required 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
• RTF, Excel, and PDF layouts
• Bursting and report scheduling
• Parameterized reports
• Report troubleshooting and performance tuning
• Strong understanding 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, documentation, stakeholder-management, and knowledge-transfer skills.

Preferred Qualifications

Hands-on reporting experience with one or more Oracle HCM areas, including:

• Core HR
• Workforce Management
• Employee and Assignment Data
• Compensation
• Absence Management
• Payroll
• Talent Management
• HCM OTBI Subject Areas
• HCM BI Publisher Reporting

Email: [e-mail]

LinkedIn: https://www.linkedin.com/in/adarsh-sharma-a08126178/