数据库架构，专家
Database Architecture, SME
职责
职位概述
Peraton 正在寻找一名高级数据工程师，以支持美国医疗保险和医疗补助服务中心（CMS）的欺诈预防系统 2（FPS2）项目。该职位将领导数据迁移和去重工作流，确保遗留系统数据准确地整合、清洗并统一到目标数据平台中。
主要职责
· 设计并执行端到端的数据迁移流程，将与欺诈相关的遗留数据资产迁移到云数据仓库（Snowflake）
· 领导跨多个 CMS 来源系统的去重和记录合并工作，包括供应商、受益人和案件/举报记录
· 使用现代工具（如 DBT、Apache Airflow、SnapLogic）开发和维护 ETL/ELT 工作流，以支持持续的数据摄入和转换
· 在源环境和目标环境中执行数据剖析、质量分析和验证，以确保迁移的准确性与完整性
· 定义并实现匹配/解决逻辑，以识别并合并被整合系统中的重复记录
· 与 CMS 利益相关者、数据架构师和欺诈分析师合作，了解源系统数据模型并定义目标状态映射
· 编写数据血缘文档和迁移操作手册，以支持项目治理和审计要求
· 对 Snowflake 对象（表、视图、任务、管道、聚类键）进行调优和优化，以提高性能和成本效率
· 支持数据切换计划和执行，包括回滚程序和验证检查点
资格要求
最低要求：16 年经验，本科及以上学历；14 年经验，硕士及以上学历；10 年经验，博士学历
· 具备执行大规模数据迁移的实际经验
· 精通 SQL，并至少掌握一种脚本语言（Python 优先），用于流程开发和自动化
· 具有 ETL/ELT 工具（如 DBT、Apache Airflow、Informatica、SSIS 或 SnapLogic）的实际操作经验
· 具有在复杂多源环境中进行数据质量验证、对账测试和迁移验证的经验
· 熟悉 CMS 或联邦政府的数据环境，包括相关的数据治理和安全要求
· 具备获得或维持公共信任适格性认定的能力
加分项资格
· 具有 CMS 项目的直接经验
· 具有去重或实体解析技术的经验
· 了解 CMS 保险索赔数据
查看英文原文
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
· 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
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.Originally posted on Himalayas