Senior ETL Engineer — AWS Data Pipelines & Analytics

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

Job summary

Cornerstone Defense LLC is seeking a Software Engineer in Herndon, Virginia, who will design, develop, and maintain ETL pipelines to support data analytics needs. The role requires active TS/SCI clearance and a strong background in Linux, Object-Oriented programming, and cloud services like AWS.

The ideal candidate will have 6-8 years of experience in ETL processes, proficiency in SQL, and knowledge of data warehousing concepts. This position offers the opportunity to work on mission-critical projects while collaborating with senior stakeholders.

Qualifications

• 6-8 years of experience working in Linux, optimizing parallel processing and handling large data sets.
• 6-8 years in Object-Oriented programming, ideally with Python.
• Experience with AWS services and cloud environments.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines for analytics needs.
• Conduct data validation and quality checks.
• Support system accreditation and data governance.

Skills

Linux operating system

Object-Oriented programming

ETL processes

SQL

AWS

Data warehousing concepts

Python

Git

Bash

Education

Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field

Tools

Informatica

AWS Glue

Talend

SSIS

Azure Data Factory

Job description

Cornerstone Defense LLC is seeking a Software Engineer in Herndon, Virginia, who will design, develop, and maintain ETL pipelines to support data analytics needs. The role requires active TS/SCI clearance and a strong background in Linux, Object-Oriented programming, and cloud services like AWS.

The ideal candidate will have 6-8 years of experience in ETL processes, proficiency in SQL, and knowledge of data warehousing concepts. This position offers the opportunity to work on mission-critical projects while collaborating with senior stakeholders.