Senior Data Engineer

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

Job summary

Leidos is seeking a Senior Systems Engineer to advance a hybrid analytical data platform for the Maru Program. The role leads design, implementation, and governance of cloud-native data architectures, integrating relational databases with lakehouse technologies and distributed query engines.

The candidate will guide architects, review designs, and mentor engineers while ensuring security and performance across large datasets. Gaithersburg, MD is a primary location.

Qualifications

• 12+ years in software, data engineering, or data architecture with senior progression.
• Expert in large-scale data architectures and lakehouse tech.
• Strong SQL and Python skills.
• Experience with PostgreSQL or Aurora PostgreSQL.
• Hands-on with S3 and object-storage architectures.
• Familiar with lakehouse tech like Iceberg, Redshift, Delta Lake, Snowflake.
• Ability to design hybrid relational/object-storage analytics.
• Experience with Trino/Presto and distributed query engines.
• Knowledge of data security and governance.

Responsibilities

• Lead architecture and implementation of a hybrid analytical query platform.
• Design modern data lakehouse architectures with object storage and databases.
• Develop scalable data pipelines for batch and streaming data.
• Create data models, partitioning strategies, catalogs, and query architectures.
• Integrate PostgreSQL/Aurora data with analytics and storage platforms.
• Design distributed query capabilities using Trino/Presto or similar.
• Develop solutions with S3, Iceberg, Redshift, and other cloud services.
• Support data governance, lineage, and access controls.
• Deploy containerized data services in cloud-native environments.
• Provide technical leadership, reviews, and mentor engineers.
• Troubleshoot complex data, DB, and performance issues.

Skills

SQL

Python

PostgreSQL/Aurora PostgreSQL

Data modeling

Query optimization

Hybrid analytics

Cloud data architectures

Leadership

Security/compliance

Tools

Amazon S3

Apache Iceberg

Redshift

Snowflake

Databricks/Delta Lake

Trino/Presto

Kafka

Spark

Airflow

Dagster

dbt

Docker

Kubernetes

Terraform / IaC

Git-based CI/CD

OpenMetadata / Glue Data Catalog

Job description

Description

Join Leidos and help shape the future of geospatial intelligence! We are seeking an experienced and innovative Senior Systems Engineer to support the Maru Program with our Intelligence Community customer. If you're passionate about solving complex technical challenges, thrive in a fast-paced Agile environment, and enjoy collaborating with high-performing teams to deliver mission-critical capabilities, this is your opportunity to make a direct impact on national security.

What You'll Do

The Senior Data Engineer will lead the design and implementation of a scalable, cloud-native data architecture supporting large-scale operational and analytical workloads. This role will provide technical leadership for the development of hybrid analytical query capability, integrating relational databases, object storage, lakehouse technologies, and distributed query engines.

The ideal candidate has deep hands-on experience designing modern data platforms and can make architecture decisions around data storage, ingestion, modeling, partitioning, cataloging, governance, and query performance.

Please note Gaithersburg, MD is the program's primary work location.

Clearance Level Required

Active Top Secret/SCI with the ability to successfully pass a Polygraph examination.

Primary 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.

Required Qualifications

US citizenship is required per contract.

• 12+ years of relevant software, data engineering, or data architecture experience, with demonstrated progression into senior technical or architecture responsibilities.
• Expert-level experience designing and implementing 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 modern 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 technologies.
• Experience building batch and/or streaming data pipelines using technologies such as Apache 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.

Preferred Qualifications

• Experience with AWS-managed data services, particularly S3, Aurora PostgreSQL, Redshift, ECS/Fargate, Lambda, and related services.
• Experience with Kubernetes and container orchestration.
• Experience with data catalogs and metadata platforms such as OpenMetadata, AWS Glue Data Catalog, or equivalent.
• Experience working with geospatial, telemetry, operational, or other high-volume datasets.
• Experience designing platforms supporting both interactive queries and large-scale analytical workloads.
• Experience supporting production data platforms in classified, DoD, Intelligence Community, or other high-security environments.
• Experience providing technical directions to multidisciplinary engineering teams.

Key Technologies

Critical: SQL, Python, PostgreSQL/Aurora PostgreSQL, Amazon S3, Apache Iceberg/lakehouse architecture, distributed analytical querying, Trino/Presto, data modeling, query optimization.

Strongly Desired: Redshift, Kafka, Spark, Airflow/Dagster/dbt, Docker, Kubernetes, AWS, Infrastructure as Code, Git-based CI/CD.

Nice to Have: OpenMetadata/Glue Data Catalog, Flink, Databricks/Delta Lake, Snowflake, geospatial data experience.

Pay Range

Pay Range $131,300.00 - $237,350.00

The Leidos pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.

About Leidos

Leidos is an industry and technology leader serving government and commercial customers with smarter, more efficient digital and mission innovations. Headquartered in Reston, Virginia, with 47,000 global employees, Leidos reported annual revenues of approximately $16.7 billion for the fiscal year ended January 3, 2025. For more information, www.Leidos.com.

Pay and Benefits

Pay and benefits are fundamental to any career decision. That's why we craft compensation packages that reflect the importance of the work we do for our customers. Employment benefits include competitive compensation, Health and Wellness programs, Income Protection, Paid Leave and Retirement. More details are available at www.leidos.com/careers/pay-benefits.

Commitment to Non-Discrimination

All qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, age, national origin, citizenship, religion, physical or mental disability, medical condition, genetic information, pregnancy, family structure, marital status, ancestry, domestic partner status, sexual orientation, gender identity or expression, veteran or military status, or any other basis prohibited by law. Leidos will also consider for employment qualified applicants with criminal histories consistent with relevant laws.

#NSBA

If you're looking for comfort, keep scrolling. At Leidos, we outthink, outbuild, and outpace the status quo - because the mission demands it. We're not hiring followers. We're recruiting the ones who disrupt, provoke, and refuse to fail. Step 10 is ancient history. We're already at step 30 - and moving faster than anyone else dares.