TS/SCI ETL Engineer – Data Pipelines & NLP

Cornerstone Defense LLC; Herndon (VA); On-site; USD 120,000 - 170,000; Full time

Job summary

Cornerstone Defense LLC in Herndon, VA is seeking a Software Engineer to design, build, and maintain data pipelines and NLP-enabled search/discovery systems. The role requires leading data engineering efforts, collaborating with stakeholders, and delivering production-ready analytics in agile sprints.

The ideal candidate has 6–8 years in Linux, OO programming, Python, and cloud experience (AWS/C2S), plus strong ETL and SQL skills. TS/SCI with polygraph clearance is a must to apply.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field (or equivalent).
• Minimum 6-8 years working in Linux OS with parallel processing, memory/storage understanding, data at scale.
• 6-8 years in Object Oriented programming.
• Minimum 6-8 years of demonstrated experience with applications in the Commercial Cloud Services (C2S) environment or an AWS cloud environment.
• Minimum 4-6 years of demonstrated ETL with large structured and unstructured data sets.
• Strong experience with ETL tools such as Informatica, Talend, SSIS, AWS Glue, or Azure Data Factory.
• Proficiency in SQL, including complex queries and optimization.
• 6-8 Years of experience with AWS platform including EC2, RCS instances; data warehousing concepts.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines for data warehouse and analytics needs.
• Process large data sets (hundreds of thousands of records, GBs to TBs).
• Design and enhance search and discovery platforms across large data volumes.
• Perform data ingestion, ETL, and integration across multi-source environments.
• Build cloud-native solutions (AWS) aligned to secure architectures.

Skills

Linux

Object Oriented Programming

Python

Cloud/AWS

SQL

ETL

ETL Tools

Version Control (Git)

NoSQL

Shell Scripting

Education

Bachelor's degree in CS/IS/Engineering

Tools

Informatica

Talend

SSIS

AWS Glue

Azure Data Factory

Job description

Cornerstone Defense LLC in Herndon, VA is seeking a Software Engineer to design, build, and maintain data pipelines and NLP-enabled search/discovery systems. The role requires leading data engineering efforts, collaborating with stakeholders, and delivering production-ready analytics in agile sprints.

The ideal candidate has 6–8 years in Linux, OO programming, Python, and cloud experience (AWS/C2S), plus strong ETL and SQL skills. TS/SCI with polygraph clearance is a must to apply.