Job Title: ETL Data EngineerClearance Required: Public Trust Work Location: Hybrid; Vienna,VAAlpha 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.
Key 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.
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.
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.
Salary and Benefit Information:The likely salary range for this position is $90,000 - $130,000. This is not, however, a guarantee of compensation or salary. There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, education and certifications as well as contract provisions regarding labor categories that are specific to the position and could fall outside of this range.
Application Deadline: 12/31/2026
Joining the Alpha Omega team entitles you to participate in all retirement benefits, plans of deferred compensation, health and insurance benefits, and other such benefits as set forth in the company's policy and benefits manuals. See below, to name a few:
- 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
We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most.
