Oracle HCM & OTBI Reporting Consultant

Yorkshire Global Solutions Inc.; San Francisco (CA); Hybrid; USD 103,000 - 165,000; Full time

Job summary

Yorkshire Global Solutions Inc. is seeking an Oracle HCM/Reporting Consultant for a 12+ month contract in San Francisco, hybrid with 3 onsite days. You will design OTBI analyses, dashboards, and BI Publisher reports, aligning with ERP/HCM data, security, and governance standards.

You will gather requirements, validate outputs with business stakeholders, and train users to build OTBI reports while ensuring performance and data accuracy across Fusion Cloud modules.

Qualifications

• Strong hands-on OTBI analyses, dashboards, and subject areas.
• Proven BI Publisher report development (RTF/Excel/PDF layouts).
• SQL queries, data extraction, joins, aggregations and modeling.
• Experience with Oracle Fusion Cloud modules (Finance, HCM, Procurement or EPM).
• Knowledge of data security models and RBAC for reports.

Responsibilities

• Design and develop OTBI reports, dashboards, and analyses.
• Develop BI Publisher reports including templates and layout.
• Analyze requirements and choose OTBI vs. BIP approach.
• Test, validate, and troubleshoot reports for accuracy.
• Provide documentation and knowledge transfer to staff.
• Collaborate with SMEs and IT for validated outputs.

Skills

OTBI design

BI Publisher

SQL & data modeling

Oracle Fusion Cloud

Performance optimization

Security & data governance

Documentation & KT

Training & enablement

Collaboration & integration

Tools

OTBI

BI Publisher

Job description

Yorkshire Global Solutions Inc. is seeking an Oracle HCM/Reporting Consultant for a 12+ month contract in San Francisco, hybrid with 3 onsite days. You will design OTBI analyses, dashboards, and BI Publisher reports, aligning with ERP/HCM data, security, and governance standards.

You will gather requirements, validate outputs with business stakeholders, and train users to build OTBI reports while ensuring performance and data accuracy across Fusion Cloud modules.