ETL Data Engineer

Job Title: ETL Data Engineer

Clearance Required: Public Trust

Work Location: Hybrid; Vienna,VA

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.

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.

Culture and Values:

Guided by our core values-Harmony, Engagement, Accountability, Resourcefulness, and Tenacity (HEART)- we foster a culture of innovation, collaboration, and continuous learning and are committed to delivering high-impact solutions. We recognize and reward hard work.

Through our H.E.A.R.T. Awards Program, colleagues and managers can recognize each other for actions that exemplify these values. Recognized employees receive a detailed nomination highlighting their contributions, which is shared with their manager. Each quarter, select nominees have the opportunity to receive a monetary bonus as an extra thank-you for their impact.

Our Company:

Alpha Omega is an award-winning Federal IT solutions provider dedicated to delivering mission-enabling technology and strategic solutions across the National Security, Federal Financial, Healthcare, and Space & Science domains. Since our founding in 2016, we have grown to over 800 employees nationwide with $230m in revenue. With the January 2025 acquisitions of SeKON and Macro Solutions, we have expanded our capabilities to further support our customers in digital modernization, artificial intelligence, and cybersecurity.

We are committed to supporting our agency partners as they transform their operations, delivering on our purpose to ensure the safety, security, and well-being of future generations:

• National Security - Supporting agencies such as the Department of Homeland Security (DHS) and the Department of State.
• Federal Financial - We bring deep expertise in enterprise financial systems, supporting agencies like the Securities and Exchange Commission (SEC) and the Federal Deposit Insurance Corporation (FDIC).
• Healthcare - Our Health IT capabilities, enhance health outcomes for the warfighter via the Defense Health Agency (DHA) and support public health initiatives at the Centers for Disease Control and Prevention (CDC), National Institutes of Health (NIH), and the Substance Abuse and Mental Health Services Administration (SAMHSA).
• Space & Science - We leverage technology to advance agricultural sustainability, secure our nation’s food supply, and prepare for natural disasters, working with the National Oceanic and Atmospheric Administration (NOAA) and the United States Department of Agriculture (USDA).

Through strategic partnerships, intellectual property, and relentless drive for innovation, Alpha Omega is shaping the future of government technology. We are proud to be a Virginia Best Places to Work 8 times, an Inc. 5000 honoree 7 times, and a Washington Post Top Workplaces 4 times. Join us in driving transformation that secures the nation's future.

Alpha Omega Integration, LLC (Alpha Omega) is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.