ETL Data Engineer

Alpha Omega Integration; Vienna (VA); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

PTO including paid parental, military,

Medical and dental insurance

13 paid Federal holidays

Job summary

Alpha Omega Integration is hiring an ETL Data Engineer for a Federal project. The role blends software development, data integration, operational support, modernization, and production troubleshooting in a hybrid setting based in Vienna, VA (Arlington work).

You will develop and maintain backend services and ETL workflows to parse, transform, and load data from structured files into databases. Key technologies include REST APIs, AWS S3, SFTP, shell scripts, Java, C#, SQL stored procedures, and

Qualifications

• U.S. citizenship required and able to pass background checks.
• 5+ years of experience in 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 code, databases, file workflows, and deployment environments.
• Familiarity with secure development practices, source control, testing, and documentation.
• Strong communication skills for work with modern and legacy systems.

Responsibilities

• Develop and support REST APIs and backend services including authentication and API documentation.
• Build and maintain file-ingestion and ETL workflows to load data into databases.
• Maintain automated file transfers using AWS S3, SFTP, shell scripts, and config files.
• Support legacy applications and batch processes, including Java, C#, SQL stored procedures, and reporting integrations.
• Troubleshoot production issues and enhance monitoring, logging, and recovery procedures.
• Deploy and support applications across development, QA, and production environments including Cloud Foundry.

Skills

SQL

Relational databases

APIs

ETL

REST APIs

Tools

AWS S3

SFTP

shell scripts

AWS CLI

OpenAPI

MySQL

IBM DataStage

Cloud Foundry

Node.js

TypeScript

Express

Job description

Alpha Omega Integration is hiring an ETL Data Engineer for a prime Federal project supporting downstream API services, file-ingestion and ETL workflows, AWS-based file transfer automation, and legacy data-processing systems. This hybrid role is based in Vienna, VA (with the project work in Arlington, VA) and blends software development, data integration, operational support, modernization, and production troubleshooting.

Role Focus

You will develop and maintain backend services and data pipelines that parse, transform, validate, and load structured files into databases. The work also includes automated file movement, support for batch and legacy components, and improving reliability through monitoring, logging, and production recovery practices.

Responsibilities

• 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 from structured files 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 integrations with reporting systems.
• Troubleshoot production issues and enhance 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, operations, security, and data stakeholders to deliver reliable changes and resolve incidents.
• Document system behavior, support procedures, interfaces, and technical decisions, and identify 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

• 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

Location and Work Model

• Hybrid: Vienna, VA

Clearance

• Public Trust required

Salary

• USD 90,000 - 130,000 per year
• This range is not a guarantee of compensation or salary.

Benefits

• 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 and STD/LTD term disability coverage with employer paid premiums
• 401(k) plan with a match that is 100% vested after you complete two years of service
• FSA/DFSA/HSA flexible benefit plans
• Annual Tuition and Professional Development Reimbursement benefit

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.

Application Deadline

• 12/31/2026