Aerstone Data Architect Springfield, VA · Full time Company website

Apply for Data Architect

Aerstone is proud to be a service-disabled, veteran-owned small business (SDVOSB) certified by the National Veteran Business Development Council (NVBDC) and the US Small Business Administration. With two decades of service, we have earned accreditation from the National Security Agency (NSA) as a Certified Vulnerability Assessor, providing highest-level cybersecurity expertise to federal government, military, and intelligence agencies, as well as a wide range of private industries. Our clientele spans the commercial and federal sectors, including financial services, legal, utilities, education, and non-profit organizations. We provide unparalleled support and cleared staff to federal organizations in the civilian, military, and intelligence communities. Our suite of services covers every facet of cybersecurity, encompassing architecture, systems design, software development, training, standards-based assessment, and penetration testing.

Data Architect

Location: On-site at the National Geospatial-Intelligence Agency (NGA) Springfield, VA

Clearance Required: Active TS/SCI

Employment Type: Full-Time

About Aerstone

Aerstone is a cybersecurity and software development firm delivering secure, scalable, and mission-critical technology solutions for government and commercial partners. We specialize in building trustworthy systems that support complex regulatory environments and high-stakes missions. Our teams operate with a high degree of autonomy, technical rigor, and accountability—focused on outcomes that matter.

At Aerstone, you’ll work alongside experienced engineers and security professionals in a collaborative, mission-driven environment where your expertise directly impacts national security objectives.

Position Overview

Aerstone is seeking an experienced Data Architect to support a mission-critical software development effort for the National Geospatial-Intelligence Agency (NGA). This role supports the cybersecurity risk management process by designing, managing, and optimizing data architectures that underpin browser-based applications used for compliance tracking, vulnerability management, and RMF-aligned workflows.

You will play a key role in ensuring data integrity, performance, and secure access across a modern, cloud-native technology stack hosted in AWS.

What You’ll Do

• Design, manage, and optimize data storage and access using SQL-based databases such as Amazon RDS, Redshift, and Microsoft SQL Server.
• Develop and support ETL-based data synchronization using AWS services including Lambda, Glue, S3, and EC2.
• Create, maintain, and troubleshoot complex SQL queries, views, and stored procedures in support of application requirements.
• Collaborate closely with application developers to ensure data models align with functional and performance needs.
• Participate in Agile development cycles, including sprint planning, backlog refinement, and peer code reviews.
• Contribute to the development and maintenance of DevSecOps CI/CD pipelines for data and application deployments.
• Partner with security teams to ensure data architectures and pipelines meet secure coding and deployment standards.
• Troubleshoot data issues across environments and provide root-cause analysis and remediation.

Tech Stack

SQL (RDS, Redshift, MS SQL Server), AWS (Lambda, Glue, S3, EC2), Docker, Python, PowerShell, CI/CD pipelines, Agile/Scrum

Required Qualifications

• Active TS/SCI clearance.
• Bachelor’s degree in Computer Science or a related technical field.
• 5+ years of experience in backend database development or data engineering roles.
• Expert-level SQL skills, including complex queries and performance tuning.
• Hands-on experience with AWS data transformation and integration services.
• Experience designing and maintaining data pipelines in AWS environments.
• Familiarity with Docker and containerized application environments.
• Strong understanding of secure coding practices and data security principles.
• Proven debugging, troubleshooting, and problem-solving skills.
• Experience with Python and PowerShell scripting is a plus.
• 
  

Why Aerstone?

• Contribute directly to mission-critical systems supporting national security.
• Work on modern, cloud-native architectures in a high-impact environment.
• Join a close-knit, highly skilled technical team where your work is visible and valued.
• Be part of a company that prioritizes trust, autonomy, and technical excellence.