Alpha Omega Integration is seeking an ETL Data Engineer to support a prime Federal project with a hybrid setup based out of Vienna, VA. This role focuses on building and maintaining downstream API services, file ingestion and ETL workflows, AWS-based file-transfer automation, and supporting legacy data-processing systems through modernization and day-to-day production troubleshooting.

Work is centered on reliable data movement, integration, and operational support across development, QA, and production environments, with collaboration spanning application owners, operations, security, and data stakeholders.

What you’ll do

Develop and support REST APIs and backend services, including authentication, database connectivity, configuration, and API documentation.
Build and maintain file-ingestion and ETL workflows to parse, transform, validate, and load data into databases.
Maintain automated file transfers using AWS S3, SFTP, shell scripts, and environment-specific configurations.
Support legacy applications and batch processes, including ETL jobs, Java and C# components, SQL stored procedures, and reporting-system integrations.
Troubleshoot production issues and improve monitoring, logging, error handling, notifications, and operational recovery procedures.
Deploy and support applications across development, QA, and production environments, including Cloud Foundry and related services.
Collaborate with application owners and operational, security, and data stakeholders to deliver reliable changes and resolve incidents.
Document system behavior, support procedures, interfaces, and technical decisions, and look for opportunities to improve reliability and maintainability.

Required qualifications

U.S. citizenship and ability to pass the client-required criminal and financial background investigation.
5+ years of experience developing or supporting production software and data-processing systems.
Proficiency with SQL and relational databases.
Experience with APIs, data integration, batch processing, or ETL.
Ability to troubleshoot across application code, databases, file workflows, and deployment environments.
Familiarity with secure development practices, source control, testing, and technical documentation.
Strong communication skills and the ability to work with both modern and legacy systems.

Technologies you may work with

REST APIs, SQL, relational databases
AWS S3, SFTP, shell scripts, AWS CLI
Java, C#, SQL stored procedures
Cloud Foundry, Node.js, TypeScript, Express, OpenAPI
MySQL, IBM DataStage

Public Trust clearance

Clearance required: Public Trust

Location

Hybrid, Vienna, VA.

Project work is for a prime Federal engagement in Arlington, VA (Hybrid; Vienna, VA).

Preferred qualifications

Experience with Node.js, TypeScript, Express, and OpenAPI.
Experience with MySQL, AWS S3, AWS CLI, SFTP, and shell scripting.
Familiarity with Cloud Foundry deployments and service bindings.
Experience with IBM DataStage or similar ETL platforms.
Experience maintaining Java, C#, and SQL stored procedure workloads.
Background supporting regulated, financial, or reporting-oriented systems.

Compensation and benefits

Salary range: USD 90,000 - 130,000 per year
PTO including paid parental, military, and bereavement leave
Eleven (11) paid Federal holidays, five of which are floating holidays
Health and Dental Insurance (including 100% employer-paid premiums for employee coverage under the HDHP health plan)
Life Insurance, STD/LTD term disability coverage, with employer paid premiums
401(k) plan with a match that is 100% vested after two years of service
FSA/DFSA/HSA flexible benefit plans
Annual Tuition & Professional Development Reimbursement benefit

This salary range is likely for the position and is not a guarantee of compensation.

Application deadline

12/31/2026

ETL Data Engineer

Job Description