The Data Engineer is responsible for designing, building, and maintaining the company’s data infrastructure — from raw data ingestion through to production-ready datasets that serve both operational systems and AI workloads. A core focus of this role is building a comprehensive metadata and semantic layer that clearly describes every dataset, table, and field, enabling AI systems to scan, analyze, and generate reports autonomously.
Responsibilities
Design and build automated ETL/ELT pipelines to ingest data from multiple sources (Call Center, DMS, Social Platform, third-party APIs)
Develop scheduling, monitoring, and alerting mechanisms to ensure pipeline reliability and SLA compliance
Implement incremental processing, deduplication, and change data capture (CDC) strategies for high-volume data flows
Maintain and optimize existing pipelines for performance, cost, and maintainability
Build and maintain a comprehensive metadata catalog with clear descriptions for every table and column across all datasets
Support a newly awarded program for a federal health agency by building and maintaining reliable data pipelines, transformations, and integration structures.
Locations (2)
Washington, District of Columbia, United States
Bethesda, Maryland, United States
Responsibilities
Profile source data, database schemas, interfaces, and data movement to document lineage and dependencies.
Design and implement repeatable extraction, transformation, and loading processes with validation and reconciliation controls.
Develop SQL and transformation logic to support application integration, operational reporting, and approved data products.
Implement data quality checks, error handling, logging, and recoverable processing for scheduled or event‑driven pipelines.
Support database and application migrations through mapping, test loads, reconciliation, and controlled cutover.
Lead Data Engineer II on the GPS AI & Data team, responsible for operating, maintaining, and improving ArcGIS Enterprise environments and designing data pipelines.
Compensation
A reasonable estimate of the current range is $151,500 to $252,500.
Responsibilities
Lead the operation, maintenance, and continuous improvement of five ArcGIS Enterprise environments
Plan and lead platform upgrades, migrations, patching, and incident resolution while coordinating GIS developers and technical team members
Translate client and business needs into data engineering requirements, user stories, acceptance criteria, work plans, and work assignments
Guide the design and delivery of ArcGIS-integrated data pipelines, PostgreSQL data models, and data quality controls
Lead client discussions, communicate delivery status and risks, prioritize work, and oversee deliverables against requirements, quality standards, and timelines
Build proofs of concept for AI, data and software ideas in R&D China, working closely with business users and vendors to validate concepts before production.
Responsibilities
Build proofs of concept
Agree written success criteria with product owner
Choose simplest approach to answer question
Demonstrate results to users and leaders
Collect user feedback and adjust quickly
Requirements
Bachelor's degree or above in a STEM discipline
Nice to have: Master's degree or PhD in a STEM discipline
Nice to have: Experience in pharma, biotech, CRO or regulated industry
Nice to have: Exposure to clinical, laboratory, regulatory or bioinformatics systems
Nice to have: Experience as a forward deployed engineer or solutions engineer