Facets Migration Lead

Seeking an experienced Facets Migration Lead to oversee large-scale data migration and transformation initiatives within the healthcare payer space, ensuring accurate, compliant, and auditable migration of CMS program data into the Facets platform.

Location: Remote

Responsibilities

• Lead end-to-end data migration efforts for Facets implementations and transformation programs
• Define and oversee data conversion strategies, including mapping, validation, and reconciliation processes
• Ensure accuracy, completeness, and auditability of migrated data in alignment with CMS requirements
• Provide subject matter expertise on Facets data tables, structures, and data movement
• Develop and review complex SQL queries for data extraction, validation, and troubleshooting
• Identify and resolve data issues, risks, and dependencies across the migration lifecycle
• Collaborate with business, technical, and vendor teams to drive successful migration outcomes
• Oversee testing activities, including system integration testing (SIT) and user acceptance testing (UAT)
• Maintain comprehensive documentation of data migration processes, rules, and results
• Mentor and guide junior analysts and migration team members

Requirements

• Minimum of 10 years of hands-on experience with the Facets platform, including at least 5 years supporting CMS programs (Medicare Advantage or Medicaid)
• Minimum of 5 years of experience leading or supporting Facets transformation projects with a focus on data migration
• Proficiency across all Facets modules
• Experience working with Facets version 25.1 or newer
• Deep knowledge of Facets data tables, data structures, and data movement processes
• Strong technical expertise in SQL and SQL Server Management Studio (SSMS)
• Proven experience overseeing data mapping, validation, and reconciliation efforts
• Excellent communication skills, with the ability to lead cross-functional teams