Senior Data Engineer - Cloud Lakehouse Architect

Leidos LLC; Gaithersburg (MD); On-site; USD 131,000 - 237,000; Full time

Job summary

Leidos LLC in Gaithersburg, MD is seeking an experienced Senior Data Engineer to lead the design and implementation of a scalable, cloud-native data architecture for large-scale operational and analytical workloads. You will drive hybrid lakehouse solutions, data ingestion, modeling, and governance in a fast-paced Agile environment.

The role requires active Top Secret/SCI clearance with polygraph, and 12+ years in data engineering or architecture.

Qualifications

• US citizenship required by contract.
• 12+ years of relevant software, data engineering, or data architecture experience.
• Expert-level experience designing large-scale data architectures, lakehouses, or analytical data platforms.
• Strong hands-on experience with SQL and Python.
• Strong experience with PostgreSQL and/or Amazon Aurora PostgreSQL.
• Experience with Amazon S3 and object-storage-based data architectures.
• Hands-on experience with lakehouse technologies such as Apache Iceberg, Databricks/Delta Lake, Snowflake, Redshift, or equivalent.
• Experience designing hybrid architecture spanning relational, columnar, object-storage, and distributed analytical systems.
• Experience with distributed query engines such as Trino/Presto or equivalent.
• Experience building batch and/or streaming data pipelines with Kafka, Spark, Flink, Airflow, Dagster, dbt, or equivalents.
• 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 for large-scale data.
• Design and implement modern data lakehouse architectures using object storage, relational databases, and distributed analytics tools.
• Develop scalable batch and streaming data pipelines for ingestion, transformation, enrichment, and delivery of data.
• Design data models, partitioning strategies, indexing, catalogs, and query architectures for large datasets.
• Integrate PostgreSQL/Aurora transactional data with analytical/object-storage platforms.
• Design and optimize distributed query capabilities with Trino/Presto or equivalents.
• Develop solutions using Amazon S3, Apache Iceberg, Redshift, and other cloud data services.
• Support data governance, metadata management, lineage, access controls, and security requirements.
• Design and deploy containerized data services in cloud-native environments.
• Provide technical leadership, architecture guidance, reviews, and mentoring for the data platform.

Skills

SQL

Python

PostgreSQL/Aurora

AWS S3

Iceberg

Trino/Presto

Data modeling

Docker/Kubernetes

Tools

Apache Iceberg

Databricks/Delta Lake

Redshift

Kubernetes

Job description

Leidos LLC in Gaithersburg, MD is seeking an experienced Senior Data Engineer to lead the design and implementation of a scalable, cloud-native data architecture for large-scale operational and analytical workloads. You will drive hybrid lakehouse solutions, data ingestion, modeling, and governance in a fast-paced Agile environment.

The role requires active Top Secret/SCI clearance with polygraph, and 12+ years in data engineering or architecture.