Healthcare Configuration Consultant​/Analyst; Facets & SQL

Healthcare Systems Configuration Analyst (FACETS, SQL)

Location: Mason, OH 45040 (
Hybrid – 3 days per week onsite - Mason, OH
)

Duration: 6 Months with Possible extension

Work Hours: 8:00 AM – 5:00 PM (1-hour break)

Weekly

Hours:

40 hours

Experience & Education

• Experience
  
  Required:
  
  6+ years
• Education: Bachelor’s degree or equivalent work experience (flexible)

• Serve as a Sr. Configuration Analyst on the Business Configuration Solutions team
  , responsible for enabling member benefit configuration strategies by designing, implementing, and executing configuration solutions
  .
• This role is 60% hands-on configuration and 40% cross-functional collaboration
  , including leading meetings
  , capturing business requirements
  , testing execution
  , and troubleshooting Medicaid product implementations
  .
• The analyst will act as a Subject Matter Expert (SME) interfacing with cross-functional teams to deliver system and process solutions using FACETS and supporting automation tools.

• Serve as a Subject Matter Expert representing the Configuration workstream for large Government Implementations (
  Medicaid, Medicare, Med/Surgical
  ).
• Design, build, troubleshoot, and prototype Medicaid products using FACETS
  .
• Lead and represent cross-functional meetings to gather and document business requirements.
• Capture and document business requirements
  , process flows
  , and functional specifications
  .
• Execute testing
  , claims validation
  , and troubleshooting for configuration enhancements.
• Perform data analysis and validation by removing duplicates, errors, and outliers.
• Build SQL queries to extract backend data supporting configuration and testing needs.
• Conduct Fit/Gap Analysis for new client plans and provide configuration feedback.
• Collaborate with leadership on the Configuration roadmap and automation initiatives.
• Self-manage workload to meet SLAs and KPIs for project delivery.
• Maintain strong working relationships with stakeholders across all levels of leadership.

• FACETS (Healthcare Claims & Benefit Configuration)
• Healthcare claims understanding / benefit configuration
• SQL / Database experience
• Medicaid product configuration experience
• Strong analytical and problem-solving skills
• Ability to lead and represent cross-functional meetings
• Business requirements gathering & documentation
• Testing execution & claims validation

• FACETS (Claims testing & configuration)
• Oracle SQL (Data extraction & validation)
• Automation tools (Informatica-based, homegrown)
• Windows OS

• 4+ years of FACETS platform experience
• Experience with Medical Plan Benefit Configuration
• Provider Network & Agreement Configuration
• Strong understanding of Medicare / Medicaid
• Excellent communication and stakeholder management skills
• Ability to learn quickly and operate independently in complex environments