Data Engineer – Mid with Security Clearance

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

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401k matching

PTO and holidays

Professional training

Pet insurance

Job summary

Castalia Systems in Chantilly, Virginia, is seeking a Data Engineer-Mid to support a government customer. The role involves data analysis, ETL design, and AWS cloud operations to empower mission-critical decisions.

The candidate will work in an Agile environment, applying statistics, data processing, and programming to develop scalable data solutions and deliver actionable insights for stakeholders.

Qualifications

• Bachelor's degree in STEM required.
• 5–10 years of progressive related experience in data science/engineering.
• Experience automating data processes and presenting to upper management.
• Strong knowledge of ETL pipelines and data integration workflows.
• Experience with AWS cloud infrastructure and security best practices.
• Familiarity with MASINT and DoD/Federal government environments.

Responsibilities

• Analyze and extract information from large datasets using statistical techniques.
• Automate data extraction, cleaning, processing, and analysis functions.
• Develop and implement data models to solve complex analytical questions.
• Design and optimize ETL pipelines and data flows.
• Support cloud infrastructure provisioning, security, and upgrades.
• Collaborate with Agile teams to deliver technical solutions for mission needs.

Skills

Python programming

ETL pipelines

AWS cloud

Data analysis

SQL databases

REST APIs

Education

Bachelor of Science in STEM

Master's degree in science field

Tools

SAS

R

Tableau/Power BI

Job description

Job Type: Full- Time Clearance: TS/SCI with a CI Poly Must be a U.S. Citizen Job Summary Castalia Systems is seeking a Data Engineer-Mid to support one of our government customers in Chantilly, Virginia. The Data Engineer utilizes a diverse range of data-focused skills, experience, deep technical and analytical problem solving, and team-centered solutioning for complex problems to satisfy priority information enabling operations. This position requires strong attributes for problem solving, data analysis, troubleshooting, analytical thinking, and experimentation, often under time sensitive decisions. Roles and Responsibilities

• A qualified candidate will perform the following duties and responsibilities, but are not limited to:
• Utilize statistical techniques to analyze and extract relevant information from large amounts of data.
• Automate and optimize data extraction, cleaning, processing, and analysis functions.
• Develop, validate, and implement data models to solve problems and answer complex analytical questions.
• Develop and implement novel statistical approaches to address complex issues.
• Perform data science and engineering activities with minimal guidance and independently prepare reports detailing methodologies, results, and mission impacts.
• Support the acquisition of systems, software, and data science-related capabilities, including documenting technical accomplishments and analytical findings.
• Utilize statistical software packages such as SPSS, SAS, S-PLUS, and R to perform data analysis.
• Develop and maintain programming solutions to extract, transform, and clean multi-terabyte databases.
• Design, evaluate, and optimize Extract, Transform, Load (ETL) pipelines, including understanding data flows, component dependencies, system interactions, and outstanding implementation requirements.
• Support the organization, storage, management, and integration of data across relational and non-relational database systems.
• Assist with the provisioning, configuration, maintenance, security, and upgrading of AWS/cloud-based servers, databases, and infrastructure.
• Support cloud networking and security configurations, including Virtual Private Clouds (VPCs), subnets, routing, connectivity, security groups, network access restrictions, and firewall controls.
• Utilize Python to review existing implementations, develop prototypes, automate processes, and support evolving data engineering solutions.
• Evaluate Application Programming Interfaces (APIs) and system-to-system integrations to assess functionality, dependencies, and technical implementation progress.
• Collaborate with engineering and project teams using Agile methodologies to coordinate development activities, track technical progress, and support project deliverables.
• Apply recent data science and engineering experience to develop, evaluate, and implement technical solutions supporting mission requirements.
• Bachelor of Science degree in Science, Technology, Engineering, or Mathematics (STEM).
• 5–10 years of progressive, relevant work experience, including significant data science or engineering experience within the last two years.
• Experience developing and implementing methods for automation and optimization of data processes and products for presentation to upper management.
• Demonstrated understanding of statistical analysis, including regression, anomaly detection, and clustering.
• Experience creating data packages consisting of databases, technical reports, and interactive visualizations.
• Effective communication skills to present data science activities, technical findings, and analytical products to both technical and non-technical stakeholders.
• Ability to integrate diverse data sources, including Open Source, Publicly Available Information (PAI), Commercially Available Information (CAI), and intelligence records, to produce comprehensive technical data packages.
• Demonstrated ability to apply technical and analytical skills to solve complex problems.
• Working knowledge of ETL pipelines, including data flow, pipeline architecture, component interactions, and data processing workflows.
• Foundational understanding of relational and non-relational databases, including database management, data storage, organization, and retrieval.
• Experience or working knowledge of AWS/cloud infrastructure, including provisioning, hosting, maintaining, securing, and upgrading cloud-based servers and databases.
• Understanding of cloud networking and security principles, including VPCs, subnets, routing, network connectivity, security groups, access restrictions, service control policies, and firewall configurations.
• Working knowledge of Python programming for data processing, automation, technical analysis, and development support.
• Familiarity with REST APIs, API structures, and system-to-system integrations, including the ability to evaluate technical dependencies and integration progress.
• Basic understanding of Agile principles, development workflows, and project coordination.
• Programming skills sufficient to extract, transform, clean, and process large-scale datasets, including multi-terabyte databases.
• Hands-on experience using commercially available data exploitation and visualization tools, including Microsoft Excel, Tableau, Power BI, and Wireshark.
• Knowledge of National Intelligence Agencies and Department of Defense (DoD) organizations and mission environments.
• Advanced knowledge of statistical methodologies, including linear models and multivariate analysis.
• Experience in analytical tool development, identification, evaluation, and integration.
• Master's degree in a science-related field.
• Experience administering Linux and Windows servers, including system configuration, maintenance, patching, hardening, and security management.
• Familiarity with Identity and Access Management (IAM) and administration of headless systems through command-line interfaces.
• Experience developing automation scripts using Bash and/or PowerShell.
• Familiarity with Measurement and Signature Intelligence (MASINT), including associated data sources, analytical processes, or mission applications.
• Hands-on experience supporting AWS cloud environments, including infrastructure administration, cloud security, networking, and database hosting.
• Experience developing, troubleshooting, or optimizing ETL pipelines and data integration workflows.
• Experience using Python to develop prototypes, evaluate existing applications, and support technical solution development.
• Normal office environment.
• CONUS and OCONUS travel may be required. (10%)
• Company Description Castalia Systems is a proven business partner providing mission critical solutions to the Federal Government. We provide cutting edge solutions from Securing and Managing Data to Systems Engineering and Development. Castalia Systems is a pioneer in Artificial Intelligence Design and Application. With our vast knowledge of our customers’ needs and relevant technology, our team is able to bring successful solutions to every mission. We are one-upping our competitors by providing premium IT solutions and platforms with cutting-edge technology so it’s so evident when you compare us with anyone.
• Compensation At Castalia Systems, we provide you with opportunities and choices and support your total well-being. Our benefits include: Medical, dental, vision coverage, 401k matching, generous PTO, paid holidays, professional training opportunities, and even pet insurance to ensure your furry friends are cared for too. All regularly scheduled employees working at least 30 hours per week are eligible to participate in Castalia Systems’ benefit programs. Individuals that do not meet the threshold are only eligible for select offerings, not inclusive of health benefits. Salary at Castalia Systems is determined by various factors, including but not limited to location, position knowledge, skills, competencies, and experience, as well as contract-specific affordability and organizational requirements. The projected compensation range for this position is $175,000.00 to $185,000.00 (annualized USD). The estimate displayed represents the typical salary range for this position and is just one component of Castalia Systems’ total compensation package for employees.
• Disclaimer Castalia Systems is an equal employment opportunity and affirmative action employer and strives to comply with all applicable laws prohibiting discrimination based on race, color, creed, sex, sexual orientation, age, national origin, or ancestry, physical or mental disability, veteran status, marital status, HIV-positive status, as well as any other category protected by federal, state, or local laws. All such discrimination is unlawful, and all persons involved in the operations of the company are prohibited from engaging in this type of conduct.