Pay Growth
?
out of 5
Not enough data
Not enough info to score pay or growth
Data Architect
Job
Aerstone
Springfield, VA (In Person)
Full-Time
Review key factors to help you decide if the role fits your goals.
Job Security
?
out of 5
Not enough data
Calculating job security score...
Total Score
75
out of 100
Average of individual scores
Skill Insights
Compare your current skills to what this opportunity needs—we'll show you what you already have and what could strengthen your application.
Job Description
Data Architect at Aerstone Data Architect at Aerstone in Springfield, Virginia Posted in 1 day ago.
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 OverviewAerstone 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 DoDesign, 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 StackSQL (RDS, Redshift, MS SQL Server), AWS (Lambda, Glue, S3, EC2), Docker, Python, PowerShell, CI/CD pipelines, Agile/ScrumRequired QualificationsActive 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. recblid jg3inarho5owdub2epcznpocsgu4e4
Type:
full-timeJob Description:
Data ArchitectLocation:
On-site at the National Geospatial-Intelligence Agency (NGA)Springfield, VAClearance Required:
Active TS/SCIEmployment Type:
Full-TimeAbout AerstoneAerstone 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 OverviewAerstone 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 DoDesign, 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 StackSQL (RDS, Redshift, MS SQL Server), AWS (Lambda, Glue, S3, EC2), Docker, Python, PowerShell, CI/CD pipelines, Agile/ScrumRequired QualificationsActive 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. recblid jg3inarho5owdub2epcznpocsgu4e4