Oracle HCM Benefits Analyst

Oracle HCM Benefits Analyst

6-month Contract to hire (W2 Only)

Location: Open to relocation for any of given location- Akron, OH., Reading, PA., Greensburg, PA or Holmdel NJ, Fairmont, WV, Williamsport, MD

Do you have the right skills and experience for this role Read on to find out, and make your application.

Must-Have Skills

• Oracle HCM Benefits
• Oracle HCM Core HR
• Open Enrollment
• Eligibility Profiles
• Organizational Hierarchies
• OTBI Reporting
• HDL (HCM Data Loader)
• Fast Formula Interpretation
• Data Querying / Analysis
• Benefits Administration

Position Overview

Client is seeking an experienced Oracle HCM Benefits Analyst to support a highly complex Oracle HCM environment with an immediate focus on Open Enrollment activities. This role will serve as a subject matter expert for Oracle HCM Benefits administration, configuration, troubleshooting, and ongoing optimization.

The organization supports a highly complex benefits landscape that includes approximately 15 union groups, retiree populations, and thousands of unique benefit plans and rate combinations. The ideal candidate will have deep expertise in Oracle HCM Benefits configuration, eligibility rules, hierarchy structures, open enrollment processes, and data analysis.

This position requires a hands-on professional who can independently navigate data, write queries, troubleshoot issues, and support complex benefit rules and plan designs.

Required Qualifications

• 5+ years of hands-on Oracle HCM experience with a strong focus on Benefits
• Deep expertise with Oracle HCM Benefits configuration and administration
• Extensive Open Enrollment experience in complex enterprise environments
• Experience configuring and maintaining:
• Eligibility Profiles
• Life Events
• Benefits Rates and Coverages
• Benefit Plan Design
• Retiree Benefits Programs
• Union-Specific Benefit Rules
• Strong understanding of organizational hierarchy structures and hierarchy-related benefits processing
• Ability to create and execute data queries to analyze and troubleshoot benefits data
• Experience using OTBI (Oracle Transactional Business Intelligence)
• Ability to read and interpret Oracle Fast Formulas
• Experience with Oracle HCM Data Loader (HDL)
• Strong troubleshooting and problem-solving skills
• Ability to manage multiple priorities and customer issues in a fast-paced environment

Preferred Qualifications

• Experience writing Oracle Fast Formulas
• Advanced SQL skills
• Experience supporting large-scale Oracle HCM implementations
• Experience working with highly complex benefits environments involving multiple unions, retirees, and numerous benefit plans

Key Responsibilities

• Serve as the Oracle HCM Benefits subject matter expert.
• Lead support for Open Enrollment activities and annual benefits administration.
• Configure and maintain eligibility profiles, life events, rates, coverages, and enrollment rules.
• Support a highly complex benefits structure involving retirees, union populations, and thousands of benefit rate and plan combinations.
• Analyze organizational hierarchies and ensure proper benefits eligibility and enrollment processing.
• Utilize OTBI and data queries to research, troubleshoot, and resolve benefits-related issues.
• Read, analyze, and troubleshoot Fast Formulas used within Oracle HCM Benefits.
• Leverage HDL to support data loads, updates, and maintenance activities.
• Partner with HR, Benefits, and technical teams to resolve issues and enhance system functionality.
• Provide production support for benefits-related incidents, integrations, and enrollment activities.
• Maintain system accuracy and ensure benefits configurations align with business requirements.

Environment Complexity

The successful candidate will be comfortable supporting:

• Annual Open Enrollment processing
• Approximately 15 union groups
• Retiree benefit plans
• Complex eligibility and enrollment rules
• 3,000-5,000 benefit plans, rates, and coverage combinations
• Large-scale Oracle HCM Benefits environments

Screening questions: (Must obtain during lock up)

• What Oracle HCM Module is your strongest?
• What is your top 2 strongest Skills within Oracle HCM
• On a scale of 1 to 10 (10 being best) how would you rank your Oracle HCM benefits configuration experience?
• Are you more interested in doing implementation or Post Go-live Support and Configurations?
• What are two three examples related to Benefits that you recently completed? Provide the why, how and result
• What is your Open enrollment experience? How many Open enrollments have you set up in Oracle Cloud?
• Can you define benefit Hierarchy? xhyhwjd
• What experience do you have working with Redwood across HCM?
• What would you say the most common issue a company would have after implementing Oracle HCM / Post Go live work
• Are you willing to convert full-time? if so what salary would you need