Database Analyst - DataStage ETL

Remote
Full Time
Lawelawe Defense Inc
Experienced

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 (or ability to obtain one).

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

 

The above job description is intended to describe the general nature and level of work being performed by individuals assigned to this position. It is not intended to be an exhaustive list of all responsibilities, duties, and skills required. Candidates possessing the necessary qualifications for the position will be considered.

Lawelawe Defense Inc 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, or protected veteran status, and will not be discriminated against on the basis of disability.

Offers of employment are contingent upon satisfactory completion of a comprehensive background verification, inclusive of a criminal record check. Employment may be subject to other background checks, as required by the position.

We are committed to fair and equitable compensation practices and are transparent about our pay structures. Our pay transparency efforts are aligned with state laws and regulations to ensure compliance and promote pay equity.

Share

Apply for this position

Required*
We've received your resume. Click here to update it.
Attach resume or Paste resume
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

Voluntary Self-Identification of Disability
Voluntary Self-Identification of Disability Form CC-305
OMB Control Number 1250-0005
Expires 04/30/2026
Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Please check one of the boxes below:

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

You must enter your name and date