Mid Data Engineer

Forge Group • Reston, VA

1d • Remote

About The Position

Forge requires a Mid Data Engineer to support legacy-to-modern data transformation in a secure AWS environment for a DoW customer. The role will develop batch and event-driven pipelines, automate data quality and testing, integrate with application services, and provide observable, recoverable, high-quality data flows across mission and external interfaces.

Requirements

• U.S. Citizen (Authorization to Work in the U.S. will not suffice); previous professional experience supporting the U.S. Federal Government, either as a federal employee or contractor, is required
• 4+ years of professional experience in data engineering, database development, or data-platform delivery
• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or equivalent, OR 4 additional years of relevant professional experience in lieu of a degree
• Advanced Python software-engineering skills and experience building AWS Lambda functions and PySpark data-transformation pipelines
• Experience building, testing, and operating production ETL/ELT pipelines with automated data-quality controls
• Experience with data modeling, schema migration, source-to-target mapping, lineage, reconciliation, and data-quality automation
• Experience integrating data platforms with REST APIs, application services, file exchanges, and event-driven interfaces
• Experience with Git, CI/CD, automated testing, logging, monitoring, performance tuning, and production support
• Active CompTIA Security+ or equivalent DoW-approved baseline cybersecurity certification, or ability to obtain within the first 30 days of starting
• Active Tier 2 background investigation or higher, completed or favorably adjudicated within the previous 18 months

Nice To Haves

• Experience using Palantir Foundry for data integration, transformation, lineage, governance, and operational workflows
• Active Secret security clearance preferred
• Previous professional experience supporting a DoW organization, mission, or customer is strongly preferred; experience in modernizing COBOL flat files or legacy relational data into a modern relational architecture
• Experience integrating with Appian, Python microservices, financial transactions, logistics workflows, or high-volume external interfaces
• Experience serving as a technical team lead, mentoring junior engineers, or assisting teammates across delivery tasks
• Experience with BI, analytics, archival, records-retention, or NARA-aligned data lifecycle requirements

Responsibilities

• Build secure Python and AWS ETL/ELT pipelines for ingestion, transformation, reconciliation, and delivery
• Develop and evolve relational data models, schemas, indexes, constraints, views, and access patterns for MariaDB, PostgreSQL, or comparable platforms
• Develop data workflows and interfaces using Python on AWS Lambda and PySpark for event-driven, batch, and distributed transformation workloads
• Create automated data-quality checks for accuracy, completeness, consistency, timeliness, uniqueness, and business-rule conformance
• Implement source-to-target mapping, lineage, auditability, restartability, exception handling, and controlled replay
• Develop parity tests that compare legacy and modern processing outcomes and document the disposition of intentional differences
• Tune SQL and pipeline performance for high-volume batch and near-real-time workloads while protecting transactional integrity
• Implement monitoring, logging, alerting, and operational dashboards for pipeline health, latency, failures, and data quality
• Automate CI/CD, version-controlled data changes, deployments, rollback, and operational recovery controls
• Collaborate with architects, mission SMEs, Appian developers, testers, security personnel, and interface partners

Benefits

• Complete Flextime
• 401k With Employer Matching
• Healthcare, Including Medical, Dental, and Vision
• Health Savings Account (HSA) And Pre-Tax Premium Options
• Supplementary healthcare and family support
• Extended Short-Term Disability and Long-Term Disability
• Healthcare Insurance Deductible Paydown
• Health and Wellness Programs
• Tuition Reimbursement, Student Loan Repayment, and Education & Training Stipends
• Cell Phone / Internet Stipends
• College Saving Plans with Employer Contributions
• Alternative Work Locations and Tele-Commuting
• Employee Referral Awards
• Retention, Signing & Performance Bonuses
• Commuter Benefits
• Paid Sabbatical

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level