Senior Cloud Data Architect - Databricks Lakehouse

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

Benefits offered by this job

Medical

Dental

Vision

Life Insurance

Health Savings Account

Disability insurance

Employee Assistance Program

Parental leave

401(k)

Paid time off

Job summary

Peraton is seeking a Senior Cloud Data Architect SME to lead the data engineering foundation for a federal data migration program. Remote work is available, focused on designing end-to-end data lakehouse architectures using Databricks and Delta Live Tables within a FedRAMP-compliant AWS cloud environment.

The role emphasizes ETL design, schema harmonization, data quality frameworks, and metadata management to ensure a unified ESA dataset across multiple agencies.

Qualifications

• U.S. Citizenship required; must have ability to obtain Public Trust clearance.
• Extensive experience in cloud data architecture with Databricks and Delta Lake/Delta Live Tables.
• Experience designing data lakehouse architectures for large-scale data migration programs.
• Experience with schema harmonization, ETL pipeline design, and data quality frameworks.
• Strong knowledge of FedRAMP, FISMA, and federal cloud compliance.
• Experience with metadata management and authoritative source registry design.

Responsibilities

• Lead the cloud data lakehouse architecture design for federal species data ingestion.
• Design the Delta Live Tables ETL pipeline topology, data flow, transformations, and error handling.
• Lead schema harmonization and mapping documentation.
• Define metadata standards for ingested datasets and source attribution.
• Design the Metadata and Authoritative Source Registry structure.
• Oversee ETL pipeline development and deployment with version control and peer reviews.
• Design data quality validation frameworks within ETL pipelines.
• Produce the Data Model Harmonization Report for government review.
• Lead operational handoff and documentation for routine data refresh and monitoring.
• Provide cloud data architecture guidance for FedRAMP-compliant deployment.

Skills

Databricks

Delta Lake

Delta Live Tables

ETL pipelines

Data quality

FedRAMP compliance

Education

Bachelor's degree or higher

Master's degree

Associates degree

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.

Program Overview

The program is an IDIQ contract for an AWS-based cloud hosting system. Currently, Peraton is supporting the Cloud Security, IoT, and AIML use cases for the environment in a hybrid work environment with Federal employees. Peraton also support the following applications as part of the environment: Dremio, Tableau, Globus, Posit/RStudio, Atlassian, ThingLogix, Alteryx and CloudCheckr.

About The Role

Peraton's Department of the Interior (DOI), U.S. Fish and Wildlife Service (FWS), and NOAA's National Marine Fisheries Service (NMFS) have identified a critical gap in the federal government's ability to conduct comprehensive Endangered Species Act (ESA) research. While FWS operates an authoritative web-based platform for managing data for terrestrial and freshwater species, it does not currently include NMFS marine and anadromous species data forcing agencies to rely on separate, manual processes. This program closes that gap by integrating marine and anadromous species data into the existing FWS platform, creating a single, unified experience for all ESA-listed species. Peraton is seeking a Senior Cloud Data Architect SME with expertise in Databricks and cloud data lakehouse architectures to lead the data engineering foundation for a federal data migration program. You will design and oversee the implementation of ETL pipelines, schema harmonization, and data quality frameworks within a FedRAMP-compliant hybrid AWS cloud environment.

Work Location

Remote

Roles And Responsibilities

• Lead the design and implementation of the cloud data lakehouse architecture for federal species data ingestion, ensuring compatibility with existing infrastructure and platform constraints
• Design the Delta Live Tables ETL pipeline architecture, defining pipeline topology, data flow patterns, transformation stages, and error-handling frameworks
• Lead schema harmonization activities, conducting gap analysis between source schemas and the target data model and producing field-level mapping documentation
• Define metadata standards for all ingested datasets including naming conventions, data types, null handling, and authoritative source attribution
• Design the Metadata and Authoritative Source Registry structure and population methodology
• Oversee ETL pipeline development and deployment, ensuring all pipelines are version-controlled and peer-reviewed
• Design data quality validation frameworks within ETL pipelines, defining completeness, accuracy, consistency, and spatial integrity quality criteria
• Produce the Data Model Harmonization Report, documenting gap analysis findings between source schemas and the target data model, field-level mapping decisions, and metadata standard definitions for government review and approval
• Lead the operational handoff of ETL pipeline architecture, producing documentation for routine data refresh, pipeline monitoring, and maintenance procedures
• Provide cloud data architecture guidance for FedRAMP-compliant production deployment

Basic Qualifications

• Bachelors degree and 12 years professional experience or a Masters degree and 10 years professional experience or an Associates degree and 14 years professional experience; or a high school diploma/equivalent and 16 years' professional experience.
• U.S. Citizenship required; must have the ability to obtain and maintain a Public Trust clearance
• Extensive years of experience in cloud data architecture with expertise in Databricks and Delta Lake/Delta Live Tables
• Demonstrated experience designing data lakehouse architectures for large-scale data migration programs
• Experience with schema harmonization, ETL pipeline design, and data quality frameworks
• Strong knowledge of FedRAMP, FISMA, and federal cloud compliance requirements
• Experience with metadata management and authoritative source registry design

Preferred Qualifications

• Databricks Certified Data Engineer or equivalent certification
• AWS Certified Solutions Architect or AWS Certified Data Engineer certification
• Experience with federal environmental or geospatial data systems
• Familiarity with spatial data integration and GIS data pipelines
• Active Public Trust Clearance

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

• medical
• dental
• vision
• life
• health savings account
• short/long term disability
• EAP
• parental leave
• 401(k)
• paid time off (PTO) for vacation
• company paid holidays.

EEO

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