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)

Overview

• 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.

Responsibilities

• 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.

Mandatory Skills

• 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

Tools & Technologies

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

Desired / Preferred Qualifications

• 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