Database/ETL Engineer Senior

Role overview A senior Database/ETL Engineer role supporting US Army Human Resources Command data modernization, performed fully remote with a Ft. Knox, KY base of operations. The work centers on designing and optimizing high-volume data pipelines that keep Army HR data accurate, secure, and decision-ready, using IBM InfoSphere DataStage against large SQL data warehouses.

Responsibilities - Develop, maintain, and optimize enterprise-level ETL processes in DataStage that support HRC application structures end to end. - Design complex data mapping and transformation logic, ensuring data integrity across disparate sources within the Army data warehouse. - Provide Cyber and Information Assurance database systems maintenance, ensuring ETL jobs comply with strict security and IA protocols. - Deliver technical solutions across the full development lifecycle, from initial ingestion through report generation. - Implement and manage job scheduling and monitoring tools to keep data pipelines reliable around the clock. - Produce high-quality technical documentation, including data flow diagrams in Visio, mapping specifications, and system architecture briefs.

Requirements - Active Secret clearance. - Current CompTIA Security+ or equivalent IAT Level II certification, with eligibility for IAT Level III per DoDI 8570.01-M. - B.S. in Computer Science, Engineering, or a related field. - 5–7 years of overall experience, including at least 3 years of ETL experience with Army HRC data on premises or in the cloud. - Hands-on expertise with IBM InfoSphere DataStage and ETL best practices. - Working knowledge of PostgreSQL, Oracle, or Microsoft SQL environments, including SQL tuning and schema management. - US citizenship.

Nice to have - Experience with PostgreSQL. - Familiarity with data warehousing, XML/HTML, and open-source development environments.

Benefits and work setup - Full-time remote role with salary range of $84,000–$117,000. - Paid federal holidays, health and dental insurance, 401(k) with matching, paid vacation and sick leave. - Continuing education assistance, short- and long-term disability, life insurance, and an employee assistance program. - Veterans encouraged to apply.