ETL Data Engineer
Alpha Omega
Summary
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.
Job description
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.
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.
Benefits
- Paid time off
- Paid parental leave
- Paid military leave
- Bereavement leave
- Paid federal holidays
- Health insurance
- Dental insurance
- Life insurance
- Short-term disability coverage
- Long-term disability coverage
- 401(k) plan
- Flexible spending account
- Dependent care flexible spending account
- Health savings account
- Tuition reimbursement
- Professional development reimbursement
Company overview
Alpha Omega is a pioneering medical device company specializing in advanced neurosurgical and neuroscience equipment, with a particular focus on Deep Brain Stimulation (DBS) technology. Founded in 1993 in Nazareth, Israel, the company has established itself as a global leader in brain electrophysiology systems for both clinical applications and research. Alpha Omega develops sophisticated hardware and software solutions that enable precise brain mapping and navigation during DBS procedures, helping neurosurgeons accurately target specific brain regions for treating Parkinson's disease, essential tremor, dystonia, and other neurological disorders. The company's flagship products include the Neuro Omega and Neuro Smart systems, HaGuide software, and various navigation tools that simplify DBS procedures while improving patient outcomes. With operations spanning Israel, the United States, Germany, and China, Alpha Omega serves hundreds of hospitals and research institutions worldwide, providing innovative solutions that bridge the gap between neuroscience research and clinical practice in functional neurosurgery.