waypointjobs

Peraton

Database Architecture, SME

herndon, VA

Check who can apply and the requirements below before continuing.

Availability awaiting confirmation

We are waiting for a fresh update from the source. This page preserves the last received job details; current availability is not confirmed.

Job description

Responsibilities

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.

KEY RESPONSIBILITIES

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 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

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

Peraton Overview

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 do the can't be done by solving the most daunting challenges facing our customers. Visit peraton.com to learn how we're keeping people around the world safe and secure.

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.

EEO

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

#J-18808-Ljbffr

Worksite address

herndon, VA, 22070, US

Who can apply

Review the original listing for work authorization, qualifications and employer requirements.

Explore related searches

Current related jobs

SBIOSD

WhatJobs

Neurosurgeon – Endovascular Trained

san diego, CA

compensation: $600,000 - $750,000

Opportunity Overview A busy, established neurosurgical private practice in San Diego, California is seeking a fellowship-trained, endovascular …

Listing review due 2026-10-07View job

CompHealth

WhatJobs

A Locums Dermatologist Is Wanted in Maryland

annapolis, MD

From $225.00 to $300.00 Hourly

When it comes to finding the perfect locums assignment, sometimes it is all about who you know. CompHealth has been around for a long time and ha…

Listing review due 2026-10-07View job

Watson Clinic

WhatJobs

Urologist Opportunity

lakeland, FL

Salary not specified

OWN YOUR PRACTICE- without the start-up costs! Thriving PHYSICIAN OWNED AND OPERATED multi-specialty group is seeking a Urologist to join busy pr…

Listing review due 2026-10-07View job

Allegheny Health Network

WhatJobs

Reproductive Endocrine and Infertility

pittsburgh, PA

Salary not specified

Allegheny Health Network's Department of OB/Gyn is recruiting a fellowship trained REI/IVF physician to join our team in Pittsburgh PA! Job Du…

Listing review due 2026-10-07View job