Data Engineer for AI-Driven Legacy & Cloud Pipelines

Gswell; McLean (VA); Hybrid; USD 90,000 - 175,000; Full time

Benefits offered by this job

401K

Healthcare

Tuition reimbursement

Job summary

Groundswell is seeking an experienced Data Engineer in the McLean, VA area to design and operate batch and streaming ETL/ELT pipelines, ingesting data from diverse sources into secure cloud platforms. The role emphasizes provenance, access controls, and governance to enable decision-ready applications and AI-enabled capabilities in controlled environments.

You will collaborate across disciplines, onboard legacy data, and implement data-quality checks with monitoring.

Qualifications

• Bachelor’s degree in Computer Science, Computer Engineering, Mathematics, Statistics, or a related technical field.
• 5+ years of professional data engineering experience, including production pipeline development and operations.
• Proficiency in Python, Java, R, or other programming language used for data engineering.
• Experience with legacy systems that utilize SOAP APIs for data interaction.
• Experience implementing data-quality frameworks, validation processes, monitoring, and alerting for production pipelines.
• Working knowledge of data security, access controls, encryption, auditability, and governance in a regulated, restricted, or compliance-oriented environment.
• Experience working with APIs (SOAP/REST) and structured data formats such as JSON, XML, CSV, and Parquet.
• Ability to document technical decisions and collaborate with multidisciplinary teams and customer stakeholders.
• Must be a U.S. Citizen per contract requirements.
• Must be able to obtain and maintain a Public Trust Clearance in accordance with contract requirements.

Responsibilities

• Design, develop, and operate batch and streaming ETL/ELT pipelines that ingest data from multiple structured and semi-structured sources into secure cloud data platforms.
• Onboard legacy data sources by reviewing schemas, mappings, interfaces, validation rules, ownership, and operational support procedures.
• Build automated data-quality checks for completeness, accuracy, consistency, timeliness, and referential integrity, with actionable monitoring and alerting.
• Automate deployments and pipeline operations using SOAP APIs, workflow orchestration, and environment-specific configurations.
• Troubleshoot failures across distributed data systems using logs, metrics, lineage, and operational signals; communicate root causes and recovery plans clearly.
• Collaborate with software engineers, cloud engineers, data scientists, security teams, architects, and customer stakeholders to translate mission needs into measurable data products.

Skills

Python

SQL

Jupyter Notebook

Cloud data engineering

Data governance

APIs (SOAP/REST)

Data security

Documentation

Communication

Education

Bachelor’s degree in Computer Science or related field

Tools

SOAP APIs

JSON

XML

Parquet

Pandas

Numpy

AWS

Job description

Groundswell is seeking an experienced Data Engineer in the McLean, VA area to design and operate batch and streaming ETL/ELT pipelines, ingesting data from diverse sources into secure cloud platforms. The role emphasizes provenance, access controls, and governance to enable decision-ready applications and AI-enabled capabilities in controlled environments.

You will collaborate across disciplines, onboard legacy data, and implement data-quality checks with monitoring.