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. #J-18808-Ljbffr