Senior Cloud Data Migration Architect
Peraton
Stand out for this role — generate a tailored resume and cover letter in about a minute.
Job summary
Peraton is seeking a Senior Data Engineer to support the FPS2 program at CMS. You will lead data migration and deduplication efforts, consolidating legacy data into the target cloud platform and ensuring accuracy.
The role requires strong SQL, Python, and experience with Snowflake, DBT, Airflow, and ETL/ELT tooling; familiarity with CMS or federal data environments and data governance is a plus.
Qualifications
- Minimum of 16 years with BS/BA; Minimum of 14 years with MS/MA; Minimum of 10 years with Ph.D.
- Demonstrated experience executing large-scale data migrations
- Proficiency in SQL and at least one scripting language (Python preferred) 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
- Direct experience on a CMS program
- Experience with deduplication or entity resolution techniques
- Knowledge of CMS claims, provider enrollment, or beneficiary data structures
- Experience with master data management (MDM) tools or frameworks
- Familiarity with fraud, waste, and abuse (FWA) detection workflows and data models
- Experience in Agile/Scrum delivery environments with tools like Jira and Confluence
Responsibilities
- Design and execute end-to-end data migration pipelines to migrate legacy fraud-related data assets into the cloud data warehouse (Snowflake)
- Lead deduplication and record consolidation efforts across CMS source systems
- Develop and maintain ETL/ELT workflows using modern tooling (DBT, Apache Airflow, SnapLogic)
- Perform data profiling, quality analysis, and validation across source and target environments
- Define and implement matching/resolution logic to identify and merge duplicate records
- Collaborate with CMS stakeholders, data architects, and fraud analysts to define target state mappings
- Develop data lineage documentation and migration runbooks for governance and audits
- Tune and optimize Snowflake objects for performance and cost efficiency
- Support data cutover planning and execution with rollback procedures
Skills
Education
Tools
Job description
Peraton is seeking a Senior Data Engineer to support the FPS2 program at CMS. You will lead data migration and deduplication efforts, consolidating legacy data into the target cloud platform and ensuring accuracy.
The role requires strong SQL, Python, and experience with Snowflake, DBT, Airflow, and ETL/ELT tooling; familiarity with CMS or federal data environments and data governance is a plus.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
