This job is closed
Applications are no longer available for this announcement. Explore current related opportunities below.
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:
LinkedIn:
#J-18808-Ljbffr
Worksite address
san francisco, CA, 94199, US
Who can apply
Review the original listing for work authorization, qualifications and employer requirements.