Hybrid ETL Data Engineer — Build Robust Data Pipelines

Alpha Omega Integration; Vienna (VA); Ibrido; USD 90.000 - 130.000; Tempo pieno

Vantaggi offerti da questo lavoro

PTO including paid parental, military,

Medical and dental insurance

13 paid Federal holidays

Descrizione del lavoro

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

Competenze

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

Mansioni

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

Conoscenze

SQL

Relational databases

APIs

ETL

REST APIs

Strumenti

AWS S3

SFTP

shell scripts

AWS CLI

OpenAPI

MySQL

IBM DataStage

Cloud Foundry

Node.js

TypeScript

Express

Descrizione del lavoro

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