Database Architecture, SME

Peraton; United States; On-site; USD 135,000 - 216,000; Full time

Benefits offered by this job

Medical benefits

401(k)

Paid time off

Job summary

Peraton is seeking a Senior Data Engineer to support the FPS2 program for CMS. You will lead data migration and deduplication, consolidating legacy data into a cloud data warehouse and building robust ETL/ELT pipelines with modern tools.

The role requires deep experience in SQL, Python, and data governance, with familiarity in CMS data environments and security controls. A strong track record in large-scale migrations is essential.

Qualifications

• Experience executing large-scale data migrations across complex environments.
• Experience with data quality validation, reconciliation testing, and migration verification.
• Familiarity with CMS or federal government data environments and security requirements.

Responsibilities

• Design and implement end-to-end data migration pipelines to Snowflake.
• Lead deduplication and record consolidation across CMS sources.
• Develop and maintain ETL/ELT workflows with DBT, Airflow, SnapLogic.
• Profile data quality and validate migration accuracy.
• Define matching/resolution logic for entity resolution across systems.

Skills

SQL

Python

Data migrations

ETL/ELT

Data governance

CMS data environments

Cloud data pipelines

Education

BS/BA

MS/MA

Ph.D.

Tools

DBT

Apache Airflow

Informatica

SSIS

SnapLogic

Job description

About Peraton

Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world's leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces. Each day, our employees solve the most daunting challenges that our customers face. Visit peraton.com to learn how we're keeping people around the world safe and secure.

About Peraton

Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world's leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces. Each day, our employees solve the most daunting challenges that our customers face. Visit peraton.com to learn how we're keeping people around the world safe and secure.

About The Role

POSITION OVERVIEW

Peraton is seeking a Senior Data Engineer to support the Fraud Prevention System 2 (FPS2) program at the Centers for Medicare & Medicaid Services (CMS). This role will lead data migration and deduplication workstreams, ensuring that legacy system data is accurately consolidated, cleansed, and harmonized into the target data platform.

• 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 multiple 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 optimize 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

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

Nice-to-have Qualifications

• 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

Details

Target Salary Range: $135,000 - $216,000. This represents the typical salary range for this position. Salary is determined by various factors, including but not limited to, the scope and responsibilities of the position, the individual's experience, education, knowledge, skills, and competencies, as well as geographic location and business and contract considerations. Depending on the position, employees may be eligible for overtime, shift differential, and a discretionary bonus in addition to base pay.

Benefits Statement: Peraton offers eligible employees a variety of benefits including medical, dental, vision, life, health savings account, short/long term disability, EAP, parental leave, 401(k), paid time off (PTO) for vacation, and company paid holidays. A full listing of available benefits can be viewed at https://www.careers.peraton.com/benefits.

EEO: Equal opportunity employer, including disability and protected veterans, or other characteristics protected by law.