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, MDMust-Have SkillsOracle HCM BenefitsOracle HCM Core HROpen EnrollmentEligibility ProfilesOrganizational HierarchiesOTBI ReportingHDL (HCM Data Loader)Fast Formula InterpretationData Querying / AnalysisBenefits AdministrationPosition OverviewClient 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 Qualifications5+ years of hands-on Oracle HCM experience with a strong focus on BenefitsDeep expertise with Oracle HCM Benefits configuration and administrationExtensive Open Enrollment experience in complex enterprise environmentsExperience configuring and maintaining:Eligibility ProfilesLife EventsBenefits Rates and CoveragesBenefit Plan DesignRetiree Benefits ProgramsUnion-Specific Benefit RulesStrong understanding of organizational hierarchy structures and hierarchy-related benefits processingAbility to create and execute data queries to analyze and troubleshoot benefits dataExperience using OTBI (Oracle Transactional Business Intelligence)Ability to read and interpret Oracle Fast FormulasExperience with Oracle HCM Data Loader (HDL)Strong troubleshooting and problem-solving skillsAbility to manage multiple priorities and customer issues in a fast-paced environmentPreferred QualificationsExperience writing Oracle Fast FormulasAdvanced SQL skillsExperience supporting large-scale Oracle HCM implementationsExperience working with highly complex benefits environments involving multiple unions, retirees, and numerous benefit plansKey ResponsibilitiesServe 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 ComplexityThe successful candidate will be comfortable supporting:Annual Open Enrollment processingApproximately 15 union groupsRetiree benefit plansComplex eligibility and enrollment rules3,000-5,000 benefit plans, rates, and coverage combinationsLarge-scale Oracle HCM Benefits environmentsScreening questions: (Must obtain during lock up)What Oracle HCM Module is your strongest?What is your top 2 strongest Skills within Oracle HCMOn 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 resultWhat is your Open enrollment experience? How many Open enrollments have you set up in Oracle Cloud?Can you define benefit Hierarchy?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 workAre you willing to convert full-time? if so what salary would you need