Senior Data Architect—Cloud Lakehouse & Big Data

Leidos Inc; Gaithersburg (MD); On-site; USD 140,000 - 180,000; Full time

Job summary

Leidos seeks an experienced Senior Data Engineer to lead a hybrid analytical query platform for large-scale operational data. You will architect data lakehouse solutions using S3, Iceberg, and distributed engines while ensuring governance and security.

The role requires deep SQL/Python skills and DoD-grade security awareness. The candidate will design scalable pipelines, integrate Aurora/PostgreSQL data, and mentor engineers within a fast-paced Agile environment.

Qualifications

• US citizenship is required per contract.
• 12+ years of relevant software, data engineering, or data architecture experience.
• Expert-level experience designing and implementing large-scale data architectures, lakehouses, or analytical data platforms.
• Strong hands-on experience with SQL and Python.
• Experience with PostgreSQL and/or Amazon Aurora PostgreSQL.
• Experience with Amazon S3 and object-storage-based data architectures.
• Hands-on experience with modern lakehouse technologies such as Apache Iceberg, Databricks/Delta Lake, Snowflake, Redshift, or equivalent.
• Experience with Trino/Presto or equivalent.
• Experience building batch and/or streaming data pipelines using Kafka, Spark, Flink, Airflow, Dagster, dbt, or equivalent.
• Strong understanding of data modeling, partitioning, indexing, cataloging, schema evolution, and query optimization.
• Experience with Docker/containerized services and modern cloud-native architectures.
• Experience with Infrastructure as Code and Git-based CI/CD.
• Strong understanding of data security, access controls, governance, and protecting sensitive data.

Responsibilities

• Lead the architecture and implementation of a hybrid analytical query platform supporting large-scale operational and analytical data.
• Design and implement modern data lakehouse architectures using object storage, relational databases, and distributed analytical technologies.
• Develop scalable batch and streaming data pipelines for ingestion, transformation, enrichment, and delivery of data.
• Design data models, partitioning strategies, indexing approaches, catalogs, and query architectures optimized for large datasets.
• Integrate PostgreSQL/Aurora transactional data with analytical and object-storage platforms.
• Design and optimize distributed query capabilities using technologies such as Trino/Presto or equivalent.
• Develop solutions using Amazon S3, Apache Iceberg, Redshift, and other modern cloud data services.
• Support data governance, metadata management, lineage, access controls, and security requirements.
• Design and deploy containerized data services within cloud-native environments.
• Provide technical leadership, architecture guidance, design reviews, and mentoring engineers to implementing the data platform.
• Troubleshoot complex data, database, query-performance, infrastructure, and integration issues.

Skills

SQL

Python

PostgreSQL

Aurora PostgreSQL

Amazon S3

Iceberg

Trino/Presto

Data modeling

Query optimization

Docker

Kubernetes

IaC

Git CI/CD

Data governance

Tools

Amazon S3

Databricks

Snowflake

OpenMetadata

Job description

Leidos seeks an experienced Senior Data Engineer to lead a hybrid analytical query platform for large-scale operational data. You will architect data lakehouse solutions using S3, Iceberg, and distributed engines while ensuring governance and security.

The role requires deep SQL/Python skills and DoD-grade security awareness. The candidate will design scalable pipelines, integrate Aurora/PostgreSQL data, and mentor engineers within a fast-paced Agile environment.