Data Engineer – Legacy Systems & AI Workflows

Posted Yesterday
Hiring Remotely in McLean, VA, USA
In-Office or Remote
90K-175K Annually
Senior level
Information Technology • Consulting
The Role
Build and operate secure batch and streaming data pipelines across structured, semi-structured, and legacy sources. Responsibilities include data ingestion, integration, quality validation, governance, monitoring, alerting, workflow orchestration, deployment automation, troubleshooting, and provenance management. Collaborate with engineering, cloud, data science, security, architecture, and customer teams to deliver reliable data products and AI-enabled workflows in regulated environments.
Summary Generated by Built In

Who Are We? 
Groundswell is a premier technology integrator and solution provider, resolutely committed to solving the most complex challenges facing federal agencies today. Our name, Groundswell, represents our commitment to be an unstoppable, seismic change in government. Ours is a small company culture with big company reach and results.  Are you ready to be audacious, be bold and drive change at a rapid pace?  Join us, where we’ll make a greater impact together.
 


What You'll do:

Groundswell is seeking an experienced Data Engineer to build secure, reliable data capabilities for a mission-focused platform that connects authoritative sources, operational data, and analytical services. This role spans data ingestion, integration, quality, governance, and pipeline operations. You will help make complex data usable and trustworthy by designing repeatable workflows that preserve provenance, enforce access controls, and support decision-ready applications and AI-enabled capabilities in controlled environments.


What You'll Do 

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

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

Preferred Qualifications

  • Experience building preprocessing, chunking, filtering, metadata-enrichment, or evaluation pipelines for LLM and other AI/ML workflows.
  • Experience operating data platforms with segmented networks, limited connectivity, strict change control, or formal authorization requirements.
  • Strong SQL expertise, including query optimization, data modeling, joins, window functions, and analysis of large datasets. 
  • Experience with Jupyter Notebook or other equivalent tools for analyzing data.
  • Experience with Python libraries such as numpy, pandas, and other libraries like this.
  • Hands-on experience with at least one major cloud provider, with AWS experience strongly preferred.
  • Extra consideration given to those with C3.ai experience.
  • Active Public Trust Clearance.
  • Preference given to candidates local to the Washington, DC metro area

Certifications

  • AWS Data Engineer Certification, Databricks, cloud data engineering, or other relevant professional certification is preferred. 


Skills:


Certification:

Why You’ll Never Want to Leave:

  • Comprehensive medical, dental, and vision plans 
  • Flexible Spending Account 
  • 4% 401K Match (immediate vesting) 
  • Paid Time Off 
  • Tuition reimbursement, certification programs, and professional development
  • Flexible work schedule
  • On-site gym and childcare option 

The salary range for this role takes into account the wide range of factors that are considered in making compensation decisions, including but not limited to skill sets, experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for any applicable geographic differential associated with the location at which the position may be filled. At Groundswell, it is not typical for an individual to be hired at or near the top of the range for their role, and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is:

$89,886.00 - $175,444.00

NOTE: Groundswell does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Groundswell, and Groundswell will not be obligated to pay a placement fee.

Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, pregnancy, genetic information, disability, status as a protected veteran, or any other protected category under applicable federal, state, and local laws.

Read a copy of the Company’s Non-Discrimination Policy Statement.
Additional Resources:

  • EO 13496 Notification of Employee Rights under NLRA

  • Know your rights: Workplace Discrimination is Illegal
     

Disability Accessibility Accommodation: If you are an individual with a disability and would like to request a reasonable accommodation as part of the employment selection process, please contact us at [email protected] or 703-639-1777.

Skills Required

  • 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 another programming language used for data engineering
  • Experience with legacy systems using 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 regulated or restricted environments
  • Experience with SOAP or REST APIs and structured data formats including JSON, XML, CSV, and Parquet
  • Ability to document technical decisions and collaborate with multidisciplinary teams and customer stakeholders
  • U.S. citizenship
  • Ability to obtain and maintain a Public Trust clearance
  • Experience building preprocessing, chunking, filtering, metadata-enrichment, or evaluation pipelines for LLM and AI/ML workflows
  • Experience operating data platforms with segmented networks, limited connectivity, strict change control, or formal authorization requirements
  • Strong SQL expertise, including query optimization, data modeling, joins, window functions, and large-dataset analysis
  • Experience with Jupyter Notebook or equivalent data-analysis tools
  • Experience with Python libraries such as NumPy and pandas
  • Hands-on experience with a major cloud provider, preferably AWS
  • C3.ai experience
  • Active Public Trust clearance
  • AWS Data Engineer, Databricks, cloud data engineering, or other relevant professional certification
  • Washington, DC metro area locality
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Washington, DC
360 Employees
Year Founded: 2003

What We Do

Groundswell is a highly specialized systems integrator focused on bringing modern ERP, low-code solutions, and platforms to the most complex challenges facing federal agencies. Specializing in enterprise-scale transformation, Groundswell leverages its world-class talent and SaaS intellectual property to help clients achieve their goals better, faster, and cheaper. As a premier technology integrator, we work with core partners such as Appian, SAP, Workday, and UiPath. Our expertise spans a wide range of capabilities, ensuring we can help government agencies further their objectives and redefine what citizens can expect from digital government services. Groundswell embodies our commitment to creating an unstoppable, seismic change in government. We strive to set new standards for digital government through our specialized approach, leveraging our wealth of technology and experience. Discover how Groundswell is redefining expectations for digital government at www.gswell.com

Similar Jobs

PNC Bank Logo PNC Bank

Product Owner

Machine Learning • Payments • Security • Software • Financial Services
Remote or Hybrid
USA
55000 Employees
91K-203K Annually

MetLife Logo MetLife

Site Reliability Engineer

Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Remote or Hybrid
United States
43000 Employees
111K-180K Annually

Applied Systems Logo Applied Systems

Consultant

Artificial Intelligence • Cloud • Payments • Software • Business Intelligence • Generative AI • Automation
Remote or Hybrid
United States
3116 Employees
85K-105K Annually
Easy Apply
Remote or Hybrid
USA
208 Employees
200K-300K Annually

Similar Companies Hiring

Axle Health Thumbnail
Artificial Intelligence • Healthtech • Information Technology • Logistics
Santa Monica, CA
25 Employees
NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity
Sydney, AU
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account