Data Architect

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.