Database/ETL Engineer Senior

Lever, Inc.; Fort Knox (KY); On-site; USD 84,000 - 117,000; Full time

Benefits offered by this job

Paid Federal Holidays

Health & dental insurance options

401k with matching

Paid vacation and sick leave

Continuing education assistance

Short Term / Long Term Disability &amp

Life Insurance

Employee Assistance Program

Job summary

PingWind is seeking an Intermediate Database Analyst to lead ETL operations using IBM InfoSphere DataStage for Army HR data modernization. You will design and optimize high-volume data pipelines, ensuring accuracy, security, and actionable insights for senior decision-makers.

You will work on end-to-end ETL architecture, data integration, and automated monitoring, while maintaining IA/security standards and documenting system architectures for ongoing projects.

Qualifications

• B.S. Degree in Computer Science, Engineering, or related field.
• Minimum 5–7 years experience; ETL experience building data pipelines for Army HR data.
• Active Secret clearance and DoDI 8570.01-M IAT Level III certification required.
• Experience with IBM InfoSphere DataStage and ETL best practices.

Responsibilities

• Assist end-to-end development, maintenance, and optimization of enterprise ETL processes using DataStage for HRC.
• Design complex data mappings and transformations ensuring data integrity across sources.
• Provide Cyber/IA database systems maintenance and ensure ETL jobs comply with security protocols.
• Review and propose technical solutions across all stages of the data development lifecycle.
• Implement and manage job scheduling/monitoring tools for 24/7 data pipeline reliability.
• Produce high-quality technical documentation (Visio data flows, mappings, architecture briefs).

Skills

DataStage Mastery

SQL Database Knowledge

Security Certification (IAT Level III)

US Citizenship

Communication Skills

Education

B.S. Degree in Computer Science, Engineering, or related degree

Tools

IBM InfoSphere DataStage

PostgreSQL

Oracle

Microsoft SQL

Job description

Location: Ft. Knox Ky, Full Time Remote
Required Clearance: Active Secret
Certifications: active CompTIA Security+ / IAT level II certification
Required Education: B.S. Degree in Computer Science, Engineering, or related degree.
Required Experience: 5-7 years of experience. Minimum of three (3) years of ETL experience in working with Army Human Resource command data on Prem or in a Cloud Environment using PostgreSQL, Oracle, or Microsoft SQL databases. Must be knowledgeable in using IBM InfoSphere DataStage leveraging industry best practices for ETL.

Position Description

Ping Wind is a seeking a mission-driven Intermediate Database Analyst with technical expertise in Extract, Transform, Load (ETL) operations and IBM InfoSphere DataStage. As a pivotal member of our team supporting the US Army Human Resources Command (HRC), you will lead the modernization of complex data pipelines. Your primary focus will be designing and optimizing high-volume data integration solutions that ensure the Army’s HR data is accurate, secure, and actionable for high-level decision-making.

Primary Responsibilities

Typical Responsibilities/Tasks:

• ETL Architecture: Assist the end-to-end development, maintenance, and optimization of enterprise-level ETL processes using DataStage to support HRC application structures.
• Data Integration & Quality: Design complex data mapping and transformation logic, ensuring data integrity across disparate sources within the Army’s data warehouse environment.
• Systems Maintenance: Provide Cyber and IA database systems maintenance, ensuring all ETL jobs comply with rigid security and Information Assurance protocols.
• Technical Lifecycle Management: Review and provide sophisticated technical solutions for data projects across all stages of the development lifecycle, from initial ingestion to report generation.
• Monitoring & Automation: Implement and manage advanced job scheduling and monitoring tools to ensure 24/7 reliability of data pipelines.
• Documentation: Produce high-quality technical documentation, including data flow diagrams (Visio), mapping specifications, and system architecture briefs.

Required Qualifications

• DataStage Mastery: hands-on experience with IBM InfoSphere DataStage and a comprehensive understanding of ETL best practices and patterns.
• Database Knowledge: Working knowledge of SQL database environments, including SQL tuning and schema Management.
• Security Certification: Must be professionally certified as Technical Level III (IAT Level III) as defined by DoDI 8570.01-M.
• Experience: Proven track record in data warehousing, XML/HTML, and open-source development environments.
• Communication: Exceptional written and verbal communication skills, with the ability to explain complex data transformations to non-technical stakeholders.
• Must be a US citizen.

Desired Qualifications

• Experience with PostgreSQL

About Pingwind

PingWind is focused on delivering outstanding services to the federal government. We have extensive experience in the fields of cybersecurity, development, IT infrastructure, supply chain management and other professional services such as system design and continuous improvement. PingWind is a VA CVE certified Service-Disabled Veteran-Owned Small Business (SDVOSB) and SBA HUBZone Certified with offices in Washington DC and Northern Virginia. www.PingWind.com

Our benefits include:

• Paid Federal Holidays
• Robust Health & Dental Insurance Options
• 401k with matching
• Paid vacation and sick leave
• Continuing education assistance
• Short Term / Long Term Disability & Life Insurance
• Employee Assistance Program through Sun Life Financial EAP Guidance Resources

Salary Range

$84k-$117K

The pay range for this job is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) job responsibilities, education, certifications, experience, as well as internal equity mapping and alignment with market data, or other applicable laws.

Veterans are encouraged to apply

PingWind, Inc. does not discriminate in employment opportunities, terms, and conditions of employment, or practices on the basis of race, age, gender, religious or political beliefs, national origin or heritage, disability, sexual orientation, or any characteristic protected by law.