ETL Data Engineer

Alpha Omega • Vienna, VA

8h • $90,000 - $130,000 • Hybrid

About The Position

Alpha Omega is seeking a qualified ETL Data Engineer for one of our prime Federal projects in Arlington, VA. He will develop, maintain, and support four project areas: a downstream API, a file-ingestion and ETL application, AWS-based file-transfer automation, and a portfolio of legacy applications and data-processing systems. This role combines software development, data integration, operational support, and modernization of systems across multiple technology generations.

Requirements

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

Nice To Haves

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

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 that 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 reporting-system integrations.
• Troubleshoot production issues; 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, operations, security, and data stakeholders to deliver reliable changes and resolve incidents.
• Document system behavior, support procedures, interfaces, and technical decisions; identify opportunities to improve reliability and maintainability.

Benefits

• PTO including paid parental, military, and bereavement leave
• Eleven (11) paid Federal holidays, five of which are floating holidays (as designated by the company’s holiday schedule each year)
• 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 you complete two years of service
• FSA/DFSA/HSA flexible benefit plans
• Annual Tuition & Professional Development Reimbursement benefit

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed