Facets Migration Lead

This is a remote position.

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