Database Analyst - ETL DataStage

Posted 2 Days Ago
Be an Early Applicant
Fort Knox, KY, USA
In-Office
Expert/Leader
Legal Tech • Software
The Role
Lead design, development, maintenance, and optimization of enterprise ETL processes using IBM InfoSphere DataStage. Ensure data integrity and security across Army HR data, implement job scheduling/monitoring for 24/7 reliability, produce technical documentation, and support the full data lifecycle from ingestion to reporting in compliance with IA requirements.
Summary Generated by Built In

Who We Are

Lawelawe is a Native Hawaiian Owned Small Disadvantaged Business (NHO SDB) that specializes in providing a range of services to federal government clients, including program management, digital solutions, human capital and training. Lawelawe leverages our NHO status to secure federal contracts that not only drive business success but also support our overall mission to uplift economically disadvantaged Native Hawaiian families and preserve the Native Hawaiian heritage.

You Are

A mission-driven Senior Database Analyst with deep technical expertise in Extract, Transform, Load (ETL) operations and IBM InfoSphere DataStage. You’re the type who doesn’t just keep data moving—you modernize pipelines, harden security, and ensure the Army’s HR data is accurate, protected, and decision-ready. As a key member of the HRC support team, you will lead the modernization of complex, high-volume data integration solutions that power high-level workforce decision-making.

Key Responsibilities

  • Lead end-to-end development, maintenance, and optimization of enterprise ETL processes using IBM InfoSphere DataStage to support HRC application structures.

  • Design complex data mapping and transformation logic to ensure data integrity across disparate sources within the Army’s data warehouse environment.

  • Provide expert-level database systems maintenance aligned to Cybersecurity and Information Assurance (IA) requirements, ensuring ETL compliance with strict security protocols.

  • Review and deliver technical solutions across the full development lifecycle—from ingestion through transformation and reporting.

  • Implement and manage advanced job scheduling/monitoring to ensure 24/7 reliability of ETL pipelines.

  • Produce high-quality technical documentation including data flow diagrams (Visio), mapping specifications, and system architecture briefs.

The Team

Lawelawe Defense Inc ("LDI") is an SBA Certified 8(a) Native Hawaiian Owned (NHO) SDB. Lawelawe Defense offers an outstanding record of delivery on various projects encompassing: Program and Portfolio Management; Systems Engineering and Architecture; Network Engineering and Operations; Data Center Optimization and Operations; Desktop/Server and Application Virtualization.

Requirements

  • Advanced, hands-on experience with IBM InfoSphere DataStage and strong knowledge of ETL best practices/patterns.

  • Strong working knowledge of SQL database environments, including SQL tuning and schema management.

  • Must hold DoDI 8570.01-M IAT Level III / Technical Level III certification.

  • Proven track record supporting data warehousing, XML/HTML, and open-source development environments.

  • Exceptional verbal and written communication skills with the ability to translate complex transformations for non-technical stakeholders.

  • Must be able to work effectively in a remote environment.

  • Active Secret clearance.

  • Must be a U.S. Citizen.

Additional Qualifications and Experience

  • Master’s degree in Computer Science, Information Technology, Data Science, or related field with 10+ years of experience, OR BA/BS with 15 years of experience in lieu of a Master’s degree.

  • Experience with PostgreSQL.

Salary

Dependent on Experience (DOE). Compensation will be based on qualifications, relevant experience, and internal equity.

Benefits

We offer a competitive benefits package for eligible employees, which may include medical, dental, vision, paid time off, paid holidays, and a retirement savings plan.
 

Skills Required

  • Advanced hands-on experience with IBM InfoSphere DataStage and ETL best practices
  • Strong working knowledge of SQL database environments, including SQL tuning and schema management
  • DoDI 8570.01-M IAT Level III / Technical Level III certification
  • Proven track record supporting data warehousing, XML and HTML
  • Exceptional verbal and written communication skills
  • Ability to work effectively in a remote environment
  • Active Secret clearance
  • U.S. Citizenship
  • Master's degree with 10+ years experience OR BA/BS with 15 years experience
  • Experience with PostgreSQL
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: San Antonio, Texas
62 Employees

What We Do

Lawelawe Defense Inc ("LDI") is an SBA Certified 8(a) Native Hawaiian Owned (NHO) SDB leveraging the capability and past performance of the Lawelawe portfolio of companies. Lawelawe in Hawaiian means "TO CARE FOR OTHERS." We were created to support the parent charity's nonprofit initiatives to uplift economically disadvantaged Native Hawaiian families and preserve the Native Hawaiian heritage. We specialize in performing: Program Management and Business Transformation; Human Capital and Training; Digital Solutions; and Medical Staffing, Healthcare and Health IT. Lawelawe Defense offers an outstanding record of delivery on various projects encompassing: Program and Portfolio Management; Systems Engineering and Architecture; Network Engineering and Operations; Data Center Optimization and Operations; Desktop/Server and Application Virtualization.

Similar Jobs

Zscaler Logo Zscaler

Principal, Product Marketing - ZPA

Cloud • Information Technology • Security • Software • Cybersecurity
Easy Apply
Remote or Hybrid
USA
8697 Employees
200K-285K Annually
Remote or Hybrid
US
15100 Employees
107K-150K Annually
Remote or Hybrid
US
15100 Employees
164K-241K Annually

Samsara Logo Samsara

Senior Software Engineer

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
United States
4000 Employees
155K-208K Annually

Similar Companies Hiring

Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account