Data Engineer – Mid

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.

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.

• 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…