← Back to jobsJob ID col-cmv8by2fj025koz01fimszknb

AerstonePosted 30+ days ago

Data Engineer

Full-time
On-site
Mid level
Competitive
Posted 30+ days ago

Aerstone is a cybersecurity and software development firm delivering secure, scalable, and mission-critical technology solutions for government and commercial partners. The Data Engineer / Database Engineer will maintain and enhance enterprise database systems, design AWS Glue data pipelines, support near real-time data ingestion, and ensure secure, reliable, and scalable data access.

Posted
30+ Days Ago
Source
Ethic Leaf recruiter
Sector
Information Technology & AI

No employer link yet — an Ethic Leaf recruiter forwards your application

Responsibilities

  • Support and maintain Microsoft SQL Server environments, with flexibility to adapt to alternative database platforms as the architecture evolves
  • Design and implement data pipelines using AWS Glue for efficient and scalable data ingestion
  • Build and maintain a near real-time data ingestion framework from Oracle databases to Microsoft SQL Server
  • Develop and manage ETL processes, including incremental/delta-based extraction of raw data from source systems
  • Build and optimize relational database schemas, ensuring performance, scalability, and data integrity
  • Implement and manage fine-grained roles and permissions in SQL Server to enforce data security and access control policies
  • Work closely with Data Analysts, Software Engineers, and other stakeholders to ensure data systems meet business requirements
  • Monitor and troubleshoot data pipelines and workflows to ensure reliability and consistency

Qualifications

  • Proven experience with Microsoft SQL Server administration and development
  • Proficiency in ETL/ELT concepts and experience with tools like AWS Glue, Apache Spark, or equivalent
  • Solid understanding of Oracle database systems and data extraction methodologies (especially delta/change data capture techniques)
  • Experience with cloud data platforms, particularly AWS (S3, Glue, RDS, etc.)
  • Strong SQL skills and experience with role-based access control in database systems
  • Familiarity with scripting or programming languages (e.g., Python, Shell) for automation and data processing
  • Ability to work independently and communicate effectively in a collaborative team environment

Preferred

  • Proficiency with Oracle GoldenGate or equivalent CDC (Change Data Capture) tools for real-time replication
  • Experience with modern data architectures (e.g., Data Vault 2.0)
  • Knowledge of CI/CD practices for data engineering
  • Exposure to data cataloging and metadata management tools
  • Change Data Capture (CDC)
  • Data Vault 2.0
  • CI/CD for Data Engineering

Required skills

Microsoft SQL ServerETL/ELTAWS GlueApache SparkOracle DatabaseAWSAmazon S3Amazon RDSSQLRole-Based Access ControlPythonShell

Full job description

Aerstone is a cybersecurity and software development firm delivering secure, scalable, and mission-critical technology solutions for government and commercial partners. The Data Engineer / Database Engineer will maintain and enhance enterprise database systems, design AWS Glue data pipelines, support near real-time data ingestion, and ensure secure, reliable, and scalable data access.

Responsibilities

  • Support and maintain Microsoft SQL Server environments, with flexibility to adapt to alternative database platforms as the architecture evolves
  • Design and implement data pipelines using AWS Glue for efficient and scalable data ingestion
  • Build and maintain a near real-time data ingestion framework from Oracle databases to Microsoft SQL Server
  • Develop and manage ETL processes, including incremental/delta-based extraction of raw data from source systems
  • Build and optimize relational database schemas, ensuring performance, scalability, and data integrity
  • Implement and manage fine-grained roles and permissions in SQL Server to enforce data security and access control policies
  • Work closely with Data Analysts, Software Engineers, and other stakeholders to ensure data systems meet business requirements
  • Monitor and troubleshoot data pipelines and workflows to ensure reliability and consistency

Preferred

  • Proficiency with Oracle GoldenGate or equivalent CDC (Change Data Capture) tools for real-time replication
  • Experience with modern data architectures (e.g., Data Vault 2.0)
  • Knowledge of CI/CD practices for data engineering
  • Exposure to data cataloging and metadata management tools
  • Oracle GoldenGate
  • Change Data Capture (CDC)
  • Real-Time Data Replication
  • Modern Data Architectures
  • Data Vault 2.0
  • CI/CD for Data Engineering
  • Data Cataloging
  • Metadata Management Tools

Company

  • Cybersecurity assessment, penetration testing, advisory, and training services
  • Springfield, Virginia, USA
  • https://aerstone.com/
  • Founded in 2003
  • 11-50 employees

Qualifications

  • Proven experience with Microsoft SQL Server administration and development
  • Proficiency in ETL/ELT concepts and experience with tools like AWS Glue, Apache Spark, or equivalent
  • Solid understanding of Oracle database systems and data extraction methodologies (especially delta/change data capture techniques)
  • Experience with cloud data platforms, particularly AWS (S3, Glue, RDS, etc.)
  • Strong SQL skills and experience with role-based access control in database systems
  • Familiarity with scripting or programming languages (e.g., Python, Shell) for automation and data processing
  • Ability to work independently and communicate effectively in a collaborative team environment
  • Proficiency with Oracle GoldenGate or equivalent CDC (Change Data Capture) tools for real-time replication
  • Experience with modern data architectures (e.g., Data Vault 2.0)
  • Knowledge of CI/CD practices for data engineering
  • Exposure to data cataloging and metadata management tools

Required skills

  • Microsoft SQL Server, ETL/ELT, AWS Glue, Apache Spark, Oracle Database, AWS, Amazon S3, Amazon RDS, SQL, Role-Based Access Control, Python, Shell

Preferred skills

  • Knowledge of CI/CD practices for data engineering, Exposure to data cataloging and metadata management tools

Experience

  • Mid level

Job details

Employment type

Full-time

Seniority level

Mid level

Date posted

Oct 4, 2026

Work mode

On-site

Job source

Ethic Leaf recruiter

Company

Aerstone

Information Technology & AI

Cybersecurity assessment, penetration testing, advisory, and training services

  • Springfield, Virginia, USA
  • Information Technology & AI
  • 11-50 employees
  • Founded 2003
  • aerstone.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs in Springfield

Modis

1d ago

New

AWS Data Engineer

TemporaryOn-siteRichmond, VACompetitive

Modis is recruiting for a client in Richmond, VA, for a contract Data Engineer role. The role focuses on developing, enhancing, and supporting large-scale data processing workflows and ETL pipelines using Spark, Scala, and AWS.

Why similarSame roleAWSRichmond

Scalence L.L.C.

1d ago

New

Development - Data Engineer

TemporaryOn-siteRichmond, VACompetitive

A confidential client is seeking a Senior Data Engineer for its Customer Data Engineering team. The role focuses on building, optimizing, and maintaining large-scale Scala and Spark ETL pipelines on AWS, including pipelines supporting new customer and…

Why similarSame roleAWS GlueRichmond

Ascyndent

1d ago

New

Senior PySpark Data Engineer

Full-timeOn-siteMcLean, VACompetitive

Ascyndent is hiring a Senior PySpark Data Engineer to develop innovative, high-quality operational engineering capabilities.

Why similarSame roleApache SparkMcLean

Get new Data Engineer jobs in Springfield by email

Create job alert

Data Engineer

Aerstone · Competitive

Apply via Ethic Leaf