Data Architect in Springfield

Energy Jobline is the largest and fastest growing global Energy Job Board and Energy Hub. We have an audience reach of over 7 million energy professionals, 400,000+ monthly advertised global energy and engineering jobs, and work with the leading energy companies worldwide.

We focus on the Oil & Gas, Renewables, Engineering, Power, and Nuclear markets as well as emerging technologies in EV, Battery, and Fusion. We are committed to ensuring that we offer the most exciting career opportunities from around the world for our jobseekers.

Job DescriptionJob DescriptionSalary:

Job Description

Data Architect

Location: On-site at the 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 security objectives.

Position Overview

Aerstone is seeking an experienced Data Architect to support a mission-critical software development effort for the 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- 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 security.
• Work on modern, cloud- 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.

If you are interested in applying for this job please press the Apply Button and follow the application process. Energy Jobline wishes you the very best of luck in your next career move.