Responsibilities

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

$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: Equal opportunity employer, including disability and protected veterans, or other characteristics protected by law.