Job#: 3019067 Job Description: Oracle Cloud HCM BI, Reporting & Dashboard Analyst
Location: Remote - client located in Denton, TX
Employment Type: Contract
Candidates must be able to work on Apex's W2 without sponsorship both now and in the future.There are no C2C / 1099 options.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.
This employer is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.
Apex uses a virtual recruiter as part of the application process. Click for more details.
If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Benefits Department at or .
Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico. Apex uses a virtual recruiter as part of the application process. Click for more details.
Apex Benefits Overview: Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Apex team member can provide.