Oracle HCM Cloud

Role: Oracle Cloud HCM BI, Reporting & Dashboard Analyst (155401)
Location: Remote
Duration: 12+ Month CTH
Must Have: Oracle Cloud HCM OTBI and BIP Report and dashboard development see JD

Required Qualifications Education: A Bachelor s degree is required. Additional job-related experience may be substituted for the required education on a year-for-year basis.
Experience: Five to seven years of relevant experience in Oracle Cloud reporting development and support, with a strong emphasis on BI Publisher. Experience supporting Oracle SaaS applications is strongly preferred.
Technical Skills:

• Extensive hands-on experience with Oracle BI Publisher (BIP) for enterprise report development.
• Strong SQL skills for querying Oracle Cloud Fusion HCM data models.
• Demonstrated experience designing and supporting interactive dashboards using Oracle Transactional Business Intelligence (OTBI) and Smart View.
• Experience designing dashboards with KPIs, prompts, drill-downs, filters, and visualizations.
• Understanding of Oracle Cloud data security and role-based access controls.
• Ability to translate functional business requirements into scalable and maintainable reports and dashboards.

Preferred Qualifications

• Experience in a higher education or public sector environment.
• Familiarity with FERPA, HIPAA, SOC 2, or similar regulatory requirements.
• Experience with AI reporting or Python is a nice-to-have.
• Familiarity with Oracle EPM integrations.

Key Responsibilities

• Design, develop, administer, and support HCM reports and dashboards using Oracle BI Publisher (BIP) and OTBI.
• Build interactive OTBI dashboards for HR, Payroll, Talent Acquisition, and executive leadership.
• Develop complex SQL queries, data templates, and RTF layouts to support operational and analytical HCM reporting.
• Create role-based dashboards with drilldowns, prompts, KPIs, and visualizations aligned to business needs.
• Develop and manage scheduled, burst, and ad hoc reports, ensuring accurate and timely delivery.
• Collaborate with functional analysts to gather and document reporting and dashboard requirements.
• Troubleshoot data accuracy, performance, and visualization issues in reports and dashboards.
• Support testing and validation of reports and dashboards during Oracle quarterly updates and HCM enhancements.
• Provide production support through ticketing systems and incident response.
• Maintain a reporting catalog, including metric definitions, data sources, and security roles.