Data Engineer: Legacy Systems to AI Workflows

Groundswell; Maryland; On-site; USD 90,000 - 175,000; Full time

Benefits offered by this job

Medical, dental, vision plans

4% 401K Match (immediate vesting)

Paid Time Off

Tuition reimbursement, certification

Flexible work schedule

On-site gym

Childcare option

Job summary

Groundswell, a premier technology integrator serving federal agencies, seeks an experienced Data Engineer to build secure, reliable data capabilities for mission-focused platforms. You will design workflows that preserve provenance, enforce access controls, and support AI-enabled capabilities in controlled environments.

You will design and operate ETL/ELT pipelines, onboard legacy data sources, implement data-quality checks, and collaborate with cross-disciplinary teams to deliver measurable

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.
• 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 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

Java

R

APIs (SOAP/REST)

Data quality frameworks

Security & governance

SQL

Documentation

Cloud (AWS)

Public Trust clearance

Education

Bachelor's degree in Computer Science/Engineering/Math/Statistics

Tools

Jupyter Notebook

Pandas

Numpy

Parquet

AWS

Job description

Groundswell, a premier technology integrator serving federal agencies, seeks an experienced Data Engineer to build secure, reliable data capabilities for mission-focused platforms. You will design workflows that preserve provenance, enforce access controls, and support AI-enabled capabilities in controlled environments.

You will design and operate ETL/ELT pipelines, onboard legacy data sources, implement data-quality checks, and collaborate with cross-disciplinary teams to deliver measurable