Oracle Fusion HCM Reporting Developer

Prophecy Technologies Corp; Northern (KY); On-site; USD 90,000 - 130,000; Full time

Job summary

Prophecy Technologies Corp in the United States seeks an Oracle Fusion HCM Reporting Developer/Consultant to design, develop, test, and support custom reports, analytics, and data extracts.

The role requires 4 to 8+ years of experience with Oracle HCM Cloud reporting, strong SQL/PLSQL, BI Publisher, OTBI, and web services, and collaboration with stakeholders.

You will translate HR requirements into dashboards and scheduled reports as part of the cloud HR solution.

Qualifications

• 4 to 8+ years with Oracle HCM Cloud reporting
• Strong SQL/PLSQL and BI Publisher experience
• Familiar with OTBI, HCM extracts, and data modeling

Responsibilities

• Design, develop, test, and support custom reports, analytics, and data extracts within Oracle Fusion Cloud HCM.
• Build complex operational and transactional reports using OTBI and BI Publisher.
• Configure and manage outbound data extracts using HCM Extracts and BICC for third-party integrations.
• Write optimized SQL queries and data models to extract HR, payroll, benefits, and compensation data.
• Troubleshoot report performance issues and validate output data accuracy.

Skills

SQL

PL/SQL

BI Publisher

OTBI

Web Services

Tools

BI Publisher Layout Editor

OTBI Subject Areas

Job description

Role: Oracle Fusion HCM Reporting Developer/Consultant

Oracle Fusion HCM Reporting Developer/Consultant designs, develops, tests, and supports custom reports, analytics, and data extracts within Oracle Fusion Cloud Human Capital Management.

Key Responsibilities

• Report Development: Build complex operational and transactional reports using OTBI (Oracle Transactional Business Intelligence) and BI Publisher (BIP).
• Data Extraction: Configure and manage outbound data extracts using [HCM Extracts] and BICC (Business Intelligence Cloud Connector) for third-party integrations.
• Data Modeling: Write optimized SQL queries, data models, and fast formulas to extract HR, payroll, benefits, and compensation data.
• System Maintenance: Troubleshoot report performance issues, validate output data accuracy, and participate in quarterly cloud release regression testing.
• Collaboration: Partner with functional consultants and business stakeholders to translate complex HR requirements into actionable dashboard metrics and scheduled reports.

Required Qualifications

• Experience: 4 to 8+ years working with Oracle HCM Cloud architectures and reporting frameworks.
• Technical Skills: Strong proficiency in SQL, PL/SQL, BI Publisher layout editor, OTBI subject areas, and web services.
• Functional Knowledge: Solid understanding of core HR, payroll, or talent management modules within Oracle Fusion.