Facets Migration Lead

We are seeking an experienced Facets Migration Lead to oversee large-scale data migration and transformation initiatives within the healthcare payer space. This role will lead the execution of data conversion strategies, including mapping, validation, and reconciliation, ensuring accurate, compliant, and auditable migration of CMS program data into the Facets platform.

Key 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

Required Qualifications:

• 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