Required Skills
Oracle Cloud HCM OTBI and BIP Report and dashboard development see JD
Not looking for : architect level. Lead level. functional consultant.
Job Description
Oracle Cloud HCM BI, Reporting & Dashboard Analyst
Location : Remote - client located in Denton, TX
Employment Type : Contract
Role Overview
We are seeking an Oracle Cloud HCM BI, Reporting, and Dashboard Analyst. This role is responsible for the design, development, management, and support of enterprise reports and dashboards for Oracle Cloud Human Capital Management (HCM) applications. The analyst will use Oracle BI Publisher (BIP), Oracle Transactional Business Intelligence (OTBI), and Oracle Cloud native analytics tools to deliver operational, analytical, and executive reports. The immediate focus will be on new report development to address a significant backlog, followed by long-term maintenance and enhancements.
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.
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.