Senior Data Migration Architect (CMS FPS2)

Peraton; Herndon (VA); On-site; USD 135,000 - 216,000; Full time

Job summary

Peraton in the United States seeks a Senior Data Engineer to support the FPS2 program for CMS. You will lead data migration and deduplication across CMS source systems, ensuring legacy data is consolidated, cleansed, and harmonized into the target data platform.

The role emphasizes SQL and Python for pipeline development, experience with DBT, Apache Airflow, and other ETL tools, and designing mappings, data lineage, and cutover plans. A Public Trust suitability determination may be required.

Qualifications

• Experience executing large-scale data migrations.
• Proficiency in SQL and Python for pipeline development and automation.
• Hands-on experience with ETL/ELT tools such as DBT, Apache Airflow, Informatica, SSIS, or SnapLogic.
• Experience with data quality validation, reconciliation testing, and migration verification across complex, multi-source environments.
• Familiarity with CMS or federal government data environments, including relevant data governance and security requirements.
• Active ability to obtain or maintain a Public Trust suitability determination.

Responsibilities

• Lead deduplication and record consolidation efforts across CMS source systems, including provider, beneficiary, and case/referral records.
• Develop and maintain ETL/ELT workflows using modern tooling (e.g., DBT, Apache Airflow, SnapLogic) to support continuous data ingestion and transformation.
• Perform data profiling, quality analysis, and validation across source and target environments to ensure migration accuracy and completeness.
• Define and implement matching/resolution logic to identify and merge duplicate records across systems being consolidated.
• Collaborate with CMS stakeholders, data architects, and fraud analysts to understand source system data models and define target state mappings.
• Develop data lineage documentation and migration runbooks to support project governance and audit requirements.
• Tune and optimise Snowflake objects (tables, views, tasks, pipes, clustering keys) for performance and cost efficiency.
• Support data cutover planning and execution, including rollback procedures and validation checkpoints.

Skills

SQL

Python

Data migration

Data quality

Data modeling

Data governance

Education

BS/BA in relevant field

MS/MA

PhD

Tools

DBT

Apache Airflow

Informatica

SSIS

SnapLogic

Snowflake

Job description

Peraton in the United States seeks a Senior Data Engineer to support the FPS2 program for CMS. You will lead data migration and deduplication across CMS source systems, ensuring legacy data is consolidated, cleansed, and harmonized into the target data platform.

The role emphasizes SQL and Python for pipeline development, experience with DBT, Apache Airflow, and other ETL tools, and designing mappings, data lineage, and cutover plans. A Public Trust suitability determination may be required.