Data Architect
Job Description
Job Description
Salary:
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 accountabilityfocused on outcomes that matter.
At Aerstone, youll 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 Youll 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.
- Bachelors 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.
Recommended Jobs
Braze/Soldering Tech
Braze/Soldering Tech Experienced Brazer? Join a Team That Values Precision and Craftsmanship. Company Profile Formed in 1923 when it was incorporated in Newark, New Jersey. This client was f…
Entry Level Fundraiser
Join Our Team as a Fundraiser & Make an Impact! Outgoing? Love meeting new people? Want to make a difference? We’re looking for energetic, social, and motivated individuals to join our team…
Ping Identity SME - Active TS/SCI
As an Identity and Access Management (IAM) specialist, you have the skills and experience to keep hackers from taking data and breaking processes. As a Ping Identity Subject Matter Expert , you’ll pla…
Software Development Engineer II - Front End
Overview In this position, you will develop visualization software to understand data where proximity and location matter. Your work will help developer communities re-imagine the capabilities of loc…
Senior Associate, Controls Tester
Overview Senior Associate, Controls Tester Capital One’s Card Risk organization is responsible for core areas that span Strategy, Operations, Technology, Analytics and Risk Management. This or…
HVAC
Job Description: HVAC Technician in Ashburn Are you a skilled HVAC Technician looking for a new opportunity in Ashburn? Join our dynamic team and play a critical role in ensuring the comfort and s…
Sates Territory Rep - Medical Device
We are a leading Medical Device and Equipment company focused on 5 innovative segments of the U.S Healthcare market. We are a fully integrated company with internal resources dedicated to the develop…
Structural Steel Welder (1st Shift)
Structural Steel Welder (1st Shift ) Pay: $18-23/hr. (based off of weld test results) Shift: 5am-3:30pm M-F Description: ~ A successful candidate should have a welding certification in D1.1 …
Cashier - Big Buns
Overview: Are you ready to welcome guests with a warm smile and provide exceptional service at the heart of our dining experience? As a Cashier at Big Buns , you'll be the friendly face that gree…
Houseparents, Full-Time - Relocation to Hershey, PA Required (Manassas)
Description: Located in Hershey, PA, Milton Hershey School (MHS) is a top-notch home and school where over 2,200 pre-K through 12th grade students from disadvantaged backgrounds are provided an extr…