Senior Cloud Data Architect: Databricks Lakehouse (Remote)

Peraton

Georgia

Hybrid

USD 135,000 - 216,000

Full time

14 days+

Application generator

Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.

Get past ATS filters

Job summary

Peraton is seeking a Senior Cloud Data Architect SME to lead the data engineering foundation for a federal migration program. Remote work is available, with a focus on cloud data lakehouse design, ETL pipelines, and schema harmonization in a FedRAMP environment.

You will design and oversee Delta Live Tables pipelines, metadata standards, and an authoritative source registry, ensuring robust data quality and governable processes for government review and deployment.

Qualifications

U.S. Citizenship required; ability to obtain and maintain a 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 requirements.
Experience with metadata management and authoritative source registry design.

Responsibilities

Lead the design and implementation of the cloud data lakehouse architecture for federal species data ingestion, ensuring compatibility with existing infra.
Design the Delta Live Tables ETL pipeline architecture, topology, data flow, transformations, and error handling.
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 and metadata standard definitions for government review.
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.