Database Architecture, SME
Peraton · UNAVAILABLE, UNAVAILABLE, US
About this role
## Responsibilities - Lead data migration and deduplication workstreams for the Fraud Prevention System 2 (FPS2) program at CMS. - Design and execute end-to-end data migration pipelines to move legacy fraud-related data into a cloud data warehouse (Snowflake). - Perform deduplication and record consolidation across multiple CMS source systems (e.g., provider, beneficiary, and case/referral records). - Develop and maintain ETL/ELT workflows using modern tooling (e.g., DBT, Apache Airflow, SnapLogic) for continuous ingestion and transformation. - Conduct data profiling, quality analysis, and validation across source and target environments to ensure accuracy and completeness. - Define and implement matching/resolution logic to identify and merge duplicate records across consolidated systems. - Collaborate with CMS stakeholders, data architects, and fraud analysts to understand source data models and define target-state mappings. - Create data lineage documentation and migration runbooks to support 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 experience requirements: - 16+ years with BS/BA; or - 14+ years with MS/MA; or - 10+ years with Ph.D. - Demonstrated experience executing large-scale data migrations. - Proficiency in SQL and at least one scripting language (Python preferred). - Hands-on experience with ETL/ELT tools (e.g., DBT, Apache Airflow, Informatica, SSIS, SnapLogic). - Experience with data quality validation, reconciliation testing, and migration verification in complex, multi-source environments. - Familiarity with CMS or federal government data environments, including data governance and security requirements. - Ability to obtain or maintain a Public Trust suitability determination. ## Nice-to-Have - Direct experience on a CMS program. - Experience with deduplication or entity resolution techniques. - Familiarity with CMS claims, provider enrollment, or beneficiary data structures. - Experience with master data management (MDM) tools/frameworks. - Familiarity with fraud, waste, and abuse (FWA) detection workflows and data models. - Experience delivering in Agile/Scrum environments (e.g., Jira, Confluence). ## Salary - **$135,000 – $216,000** (typical range). Final compensation depends on factors such as scope, experience, education, skills, location, and contract considerations. ## Company Peraton is a next-generation national security company and enterprise IT provider delivering mission-focused solutions for government agencies.
Listing freshness
CronJobs last confirmed this listing 1h ago. If its source stops confirming the opening for seven days, this page is removed from active inventory.