Data Architect

Job Description

Data Architect

Location: On-site at the National Geospatial-Intelligence Agency (NGA)
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.