Data Engineer - TS/SCI Clearance (Chantilly)

Castalia Systems; Chantilly (VA); On-site; USD 175,000 - 185,000; Full time

Benefits offered by this job

Medical, dental, vision

401k matching

Paid time off

Public holidays

Professional training

Pet insurance

Job summary

Castalia Systems is seeking a mid-level Data Engineer to support a government customer in Chantilly, Virginia. The role emphasizes data modeling, ETL design, and cloud-based data infrastructure to enable mission-critical analytics.

You will work with Python, AWS, and various data stores, delivering scalable data solutions while collaborating with diverse teams in an Agile environment.

Qualifications

• BS in STEM with 5–10 years of data science/engineering experience.
• Experience automating data processes and presenting results to upper management.
• Statistical analysis knowledge: regression, anomaly detection, clustering.
• Experience packaging data: databases, technical reports, interactive visuals.
• Excellent communication to convey findings to technical and non-technical stakeholders.
• Integrate diverse data sources (Open Source, PAO, CAI, intel records).
• Understanding of ETL pipelines, data flow, and processing workflows.
• AWS/cloud infrastructure knowledge, cloud networking and security.
• Python proficiency for data processing and automation.
• Familiarity with REST APIs and system integrations.
• Basic understanding of Agile methodologies.
• Experience handling multi-terabyte datasets (ETL)

Responsibilities

• Analyze large data sets using statistical techniques.
• Automate data extraction, cleaning, processing, and analysis.
• Develop, validate data models to answer analytical questions.
• Develop novel statistical approaches for complex issues.
• Prepare reports detailing methodologies, results, and mission impacts.
• Assist with provisioning and securing AWS/cloud infrastructure.
• Design and optimize ETL pipelines, data flows, and dependencies.
• Collaborate with engineering and project teams using Agile methodologies.
• Develop and implement technical solutions supporting mission requirements.

Skills

Python programming

ETL pipelines

AWS cloud

SQL databases

Data analysis

REST APIs

Education

Bachelor of Science in STEM

Master's degree (preferred)

Tools

SPSS

SAS

S-PLUS

R

Job description

Castalia Systems is seeking a mid-level Data Engineer to support a government customer in Chantilly, Virginia. The role emphasizes data modeling, ETL design, and cloud-based data infrastructure to enable mission-critical analytics.

You will work with Python, AWS, and various data stores, delivering scalable data solutions while collaborating with diverse teams in an Agile environment.