ETL Data Engineer

Alpha Omega Integration • Vienna, VA

2d • Hybrid

About The Position

Alpha Omega is seeking an ETL Data Engineer for a federal project. The role develops, maintains, and supports a downstream API, a file-ingestion and ETL application, AWS-based file-transfer automation, and legacy applications and data-processing systems. It combines software development, data integration, operational support, and modernization across multiple technology generations. The position is hybrid and requires Public Trust clearance.

Requirements

• U.S. citizenship and ability to pass the client-required criminal and financial background investigation.
• At least 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 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 structured-file 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, 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 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 short- and long-term disability coverage, with employer-paid premiums.
• 401(k) plan with a match that is 100% vested after two years of service.
• FSA, DFSA, and HSA flexible benefit plans.
• Annual tuition and professional development reimbursement.
• Opportunity for a monetary bonus through the quarterly H.E.A.R.T. Awards Program.

What This Job Offers

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