Oracle Cloud HCM BI, Reporting & Dashboard Analyst

Compunnel, Inc.; Denton (TX); On-site; USD 80,000 - 100,000; Full time

Job summary

A prominent tech consultancy in Denton is seeking an Oracle Cloud HCM BI, Reporting & Dashboard Analyst. This role focuses on designing and developing enterprise reporting solutions with Oracle Cloud applications, using tools like BI Publisher and OTBI. Candidates should possess 5–7 years of experience in Oracle Cloud reporting, strong SQL skills, and the ability to collaborate with teams to gather requirements and troubleshoot issues. This position offers opportunities for long-term optimization and continuous support.

Qualifications

• 5–7 years of experience in Oracle Cloud reporting development.
• Strong hands-on experience with Oracle Fusion HCM.
• Ability to design role-based dashboards with KPIs.

Responsibilities

• Design, develop, and support HCM reports and dashboards.
• Collaborate with teams to gather business reporting requirements.
• Troubleshoot data and performance issues across reports.

Skills

Oracle BI Publisher

OTBI

SQL

Data analysis

Visualizations

Education

Bachelor's degree in a related field

Tools

Oracle Cloud HCM

Smart View

Job description

Oracle Cloud HCM BI, Reporting & Dashboard Analyst

01/28/2026

Contract

Active

Job Description:

Job Summary

The Oracle Cloud HCM BI, Reporting & Dashboard Analyst is responsible for designing, developing, and supporting enterprise reporting solutions for Oracle Cloud HCM applications.

The role focuses on creating high-quality reports and dashboards using Oracle BI Publisher (BIP), OTBI, and related analytics tools.

The analyst will collaborate with functional teams to define reporting requirements, build scalable data solutions, troubleshoot issues, and support ongoing maintenance and enhancements. Initial work will prioritize clearing a backlog of reporting requests, followed by long-term optimization and support.

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 for operational and analytical reporting needs.
• Create role-based dashboards featuring KPIs, drilldowns, prompts, filters, and visualizations.
• Build and manage scheduled, burst, and ad hoc reports with high accuracy and timely delivery.
• Collaborate with functional analysts to gather business reporting requirements and document specifications.
• Troubleshoot data, accuracy, and performance issues across reports and dashboards.
• Support report testing, validation, and fixes during Oracle quarterly updates and HCM enhancements.
• Provide production support through incident management and ticketing systems.
• Maintain a reporting catalog including documentation of metrics, data sources, security mappings, and definitions.

Required Qualifications

• Bachelor’s degree in a related field (experience may substitute for education on a year-for-year basis).
• 5–7 years of experience in Oracle Cloud reporting development, with strong emphasis on BI Publisher.
• Hands-on experience supporting Oracle SaaS applications, especially Oracle Fusion HCM.
• Strong SQL skills with ability to query Oracle Cloud Fusion HCM data models.
• Experience designing dashboards using OTBI and Smart View, including KPIs, prompts, drilldowns, and visualizations.
• Understanding of Oracle Cloud data security and role-based access controls.
• Ability to translate functional requirements into scalable, maintainable reporting solutions.

Preferred Qualifications

• Experience working in higher education or public-sector environments.
• Familiarity with FERPA, HIPAA, SOC 2, or similar compliance frameworks.
• Experience with AI-driven reporting or Python-based automation.
• Familiarity with Oracle EPM integrations.