Senior ETL Engineer - NLP, AWS, Secure Data Pipelines

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

Job summary

Cornerstone Defense LLC seeks a Software Engineer to design and maintain enterprise ETL/ELT pipelines supporting data warehouse, analytics, and applications. You will extract, transform, and load data from diverse sources into centralized storage and build search/discovery platforms for large datasets.

The role requires strong Python and SQL skills, extensive Linux experience, and hands-on AWS work. You will mentor teammates, contribute to secure architectures, and deliver actionable analytics

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or equivalent.
• 6–8 years Linux-based development and data processing at scale.
• 6–8 years object-oriented programming; Python preferred.
• 6–8 years cloud platform experience (AWS; C2S or alternatives).
• 4–6 years ETL with large structured/unstructured data; ETL tools: Informatica, Talend, SSIS, AWS Glue, or Azure Data Factory.
• Proficiency in SQL and complex queries.
• 6–8 years AWS experience including EC2.
• Strong data warehousing, data modeling, and schema design.
• Scripting: Python, Bash, PowerShell; relational and NoSQL databases; Git.

Responsibilities

• Design, build, and maintain ETL/ELT pipelines for data warehouse and analytics needs.
• Extract/transform/load data from various sources into centralized storage.
• Design search and discovery platforms for large data volumes.
• Ingest data and optimize ETL across multi-source environments.
• Provide cloud-native solutions on AWS with secure, resilient architecture.
• Lead collaboration with stakeholders to translate requirements into designs.
• Deliver dashboards and visualizations for executive insights.
• Mentor teammates and perform code reviews.

Skills

Linux

Python

SQL

NoSQL

Team leadership

Cloud computing

Data warehousing

Git

Education

Bachelor’s degree in Computer Science / Information Systems / Engineering

Tools

Informatica

Talend

SSIS

AWS Glue

Azure Data Factory

AWS (EC2, etc.)

Docker

Kubernetes

Job description

Cornerstone Defense LLC seeks a Software Engineer to design and maintain enterprise ETL/ELT pipelines supporting data warehouse, analytics, and applications. You will extract, transform, and load data from diverse sources into centralized storage and build search/discovery platforms for large datasets.

The role requires strong Python and SQL skills, extensive Linux experience, and hands-on AWS work. You will mentor teammates, contribute to secure architectures, and deliver actionable analytics