Job Description

At Claritev, we pride ourselves on being a dynamic team of innovative professionals. Our purpose is simple - we strive to bend the cost curve in healthcare for all. Our dedication to service excellence extends to all our stakeholders – internal and external - driving us to consistently exceed expectations. We are intentionally bold, we foster innovation, we nurture accountability, we champion diversity, and empower each other to illuminate our collective potential.

Be part of our amazing transformational journey as we optimize the opportunity towards becoming a leading technology, data, and innovation voice in healthcare. Onward and Upward!!!

We are seeking a highly technical Oracle HCM BI Publisher Reports Developer with strong hands-on experience designing, developing, optimizing, and supporting complex reporting solutions within Oracle Fusion Cloud HCM. The ideal candidate will have deep expertise in BI Publisher, OTBI, HCM Extracts, Fast Formulas, SQL/PLSQL, Oracle HCM data models, and Fusion security structures. This role also requires experience building, configuring, and enhancing dashboards within FAIDP environments, including dashboard design, subject-area configuration, security alignment, data validation, and end-user analytics enablement. The successful candidate will partner closely with HRIS, Payroll, Benefits, Compensation, Talent, Absence, Time & Labor, Security, and Integration teams to deliver scalable, accurate, secure, and performance-optimized reporting and analytics solutions.
This position is ideal for a senior technical reporting professional who understands both the functional HCM business processes and the underlying Oracle Fusion HCM technical data architecture.

JOB ROLES AND RESPONSIBILITIES:
1. Serve as the technical reporting subject matter expert for Oracle Fusion Cloud HCM, supporting the full reporting lifecycle from requirements gathering through design, development, testing, deployment, production support, documentation, and enhancement.
2. Partner with HR, Payroll, Benefits, Compensation, Finance, IT, Security, and business stakeholders to assess reporting needs and recommend appropriate solutions using BI Publisher, OTBI, HCM Extracts, FAIDP/Fusion Analytics dashboards, HDL audit outputs, and SQL-based reconciliation reports.
3. Design, develop, test, deploy, and maintain complex BI Publisher reports, data models, templates, scheduled reports, bursting logic, and secure distribution processes across Oracle Fusion HCM modules including Core HR, Payroll, Benefits, Compensation, Absence, Time and Labor, Talent, Recruiting, Learning, Workforce Structures, and Security.
4. Write, optimize, and troubleshoot advanced SQL queries using Oracle Fusion HCM tables, views, secured reporting objects, effective-dated logic, joins across complex HCM entities, legislative contexts, and enterprise-specific configuration.
5. Develop operational, audit, compliance, reconciliation, conversion, integration, payroll testing, executive, and workforce analytics reports that support ongoing HR operations, system implementations, data migrations, integrations, and post-production support.
6. Build, configure, and maintain FAIDP and Fusion Analytics dashboards, including dashboard layouts, prompts, filters, KPIs, visualizations, charts, drilldowns, analytical views, and role-based access aligned with approved HR metrics and business definitions.
7. Validate reports and dashboards against Fusion application pages, OTBI outputs, payroll results, HDL/HSDL files, HCM Extracts, downstream systems, and other source data to ensure accuracy, completeness, and consistency.
8. Analyze and resolve reporting, dashboard, data model, query performance, access, security, and data discrepancy issues; recommend corrective actions and reusable reporting patterns to improve accuracy, scalability, and efficiency.
9. Ensure reports and dashboards comply with Oracle HCM security, role-based access control, data privacy, SOX, HIPAA, GDPR, internal audit, and enterprise control requirements, including protection of sensitive HR, payroll, benefits, compensation, and personally identifiable information.
10. Support Oracle quarterly cloud updates by reviewing release notes, identifying impacts to reporting objects, subject areas, security behavior, dashboards, and scheduled processes, and performing regression testing on critical reports and analytics.
11. Support integrations, conversions, and data validation efforts by developing reconciliation reports for HDL loads, HCM Extracts, payroll interfaces, benefits carrier files, identity management files, security role assignments, and downstream system feeds.
12. Maintain version control and technical documentation for report objects, templates, data models, queries, dashboard configurations, schedules, security settings, and production support processes. Collaborate, coordinate, and communicate across disciplines and departments.
13. Ensure compliance with HIPAA regulations and requirements.
14. Demonstrate Company’s Core Competencies and values held within.
15. Please note due to the exposure of PHI sensitive data – this role is considered to be a High Risk Role.
16. The position responsibilities outlined above are in no way to be construed as all encompassing. Other duties, responsibilities, and qualifications may be required and/or assigned as necessary.

JOB SCOPE:
The Oracle HCM BI Publisher Reports Developer & FAIDP Dashboard Configuration Specialist serves as a key reporting, analytics, and dashboard configuration resource responsible for developing, maintaining, and optimizing Oracle HCM BI Publisher reports and FAIDP dashboards to support accurate, timely, and actionable HR data insights. The incumbent works with a high level of independence under general direction, using sound judgment to gather requirements, design and modify reports, validate data accuracy, troubleshoot reporting issues, configure dashboard components, support security and access considerations, and recommend improvements within established standards. This role impacts HR operations, compliance reporting, workforce analytics, leadership decision-making, and overall data integrity by ensuring reports and dashboards are reliable, user-friendly, and aligned with business needs. The position regularly interacts with HR, IT, Payroll, Benefits, Compensation, Finance, business leaders, report users, and external vendor or Oracle support resources as needed, but does not have direct budget accountability or formal people management authority. The role may provide technical guidance, reporting support, training, and project collaboration through indirect working relationships, but it is not responsible for hiring, firing, discipline, or other formal HR actions.

COMPENSATION

The salary range for this position is $85k-$90k Specific offers take into account a candidate’s education, experience and skills, as well as the candidate’s work location and internal equity. This position is also eligible for health insurance, 401k and bonus opportunity.

Qualifications

JOB REQUIREMENTS (Education, Experience, and Training):
• 5+ years of experience developing reports in Oracle Fusion Cloud HCM.
• 5+ years of hands-on experience with Oracle BI Publisher report development.
• Strong SQL experience with Oracle databases, preferably within Oracle Fusion HCM Cloud.
• Hands-on experience building BI Publisher data models, SQL queries, RTF templates, Excel templates, bursting logic, scheduled reports, parameterized reports, and secured catalog objects.
• Experience developing reports across multiple Oracle HCM modules.
• Experience with FAIDP dashboard development, configuration, or administration.
• Experience configuring dashboard prompts, filters, visualizations, KPIs, role-based access, and metric definitions.
• Strong understanding of Oracle HCM Cloud data architecture and effective-dated table structures.
• Ability to troubleshoot complex report issues involving data security, joins, duplicate records, effective dating, and missing data.
• Experience working with Oracle Fusion HCM quarterly updates and regression testing.
• Experience with OTBI subject areas and analysis development.
• Experience supporting production reporting environments with scheduled reports, business-critical outputs, and executive dashboards.
• Experience with Oracle Fusion Analytics, Fusion HCM Analytics, or related analytics platforms.
• Experience with HCM Extracts, including extract definitions, records, attributes, threading, delivery options, and fast formulas.
• Experience with Oracle Fast Formulas for HCM, Payroll, Benefits, Absence, Compensation, or Time and Labor.
• Experience with HDL, HSDL, and data migration validation.
• Experience supporting payroll reporting, payroll costing, payroll results, retro pay, balance reporting, and element entry reporting.
• Experience with security reporting and Oracle role design validation.
• Experience with enterprise data warehouses, Snowflake, Azure, Power BI, Tableau, or other downstream analytics platforms.
• Experience with Oracle REST APIs, SOAP services, BI Publisher web services, or automation of report delivery.
• Experience supporting large-scale Oracle HCM implementations, migrations, or post-production optimization initiatives.
• Experience in regulated environments with strong audit, compliance, and data privacy requirements.
• Required licensures, professional certifications, and/or Board certifications as applicable
• Individual in this position must be able to work in a standard office environment which requires sitting and viewing monitor(s) for extended periods of time, operating standard office equipment such as, but not limited to, a keyboard, copier and telephone

BENEFITS

We realize that our employees are instrumental to our success, and we reward them accordingly with very competitive compensation and benefits packages, an incentive bonus program, as well as recognition and awards programs. Our work environment is friendly and supportive, and we offer flexible schedules whenever possible, as well as a wide range of live and web-based professional development and educational programs to prepare you for advancement opportunities.

Your benefits will include:

• Medical, dental and vision coverage with low deductible & copay
• Life insurance
• Short and long-term disability
• Paid Parental Leave
• 401(k) + match
• Employee Stock Purchase Plan
• Generous Paid Time Off – accrued based on years of service
• WA Candidates: the accrual rate is 4.61 hours every other week for the first two years of tenure before increasing with additional years of service
• 10 paid company holidays
• Tuition reimbursement
• Flexible Spending Account
• Employee Assistance Program
• Sick time benefits – for eligible employees, one hour of sick time for every 30 hours worked, up to a maximum accrual of 40 hours per calendar year, unless the laws of the state in which the employee is located provide for more generous sick time benefits.

EEO STATEMENT

Claritev is an Equal Opportunity Employer and complies with all applicable laws and regulations. Qualified applicants will receive consideration for employment without regard to age, race, color, religion, gender, sexual orientation, gender identity, national origin, disability or protected veteran status. If you would like more information on your EEO rights under the law, please click here

APPLICATION DEADLINE

We will generally accept applications for at least 5 calendar days from the posting date or as long as the job remains posted.

#LI-AN1