What are the responsibilities and job description for the Data/ETL Engineer position at KaiHonua?
Galapagos Federal Systems LLC is seeking a qualified Data/ETL Engineer to support a mission-critical Department of Defense (DoD) database system managed by the Defense Manpower Data Center (DMDC). The system serves as a centralized case-level database supporting DoD policy oversight and Congressional reporting, with capabilities for data entry, system interfaces, case management, and enhanced reporting.
The Data/ETL Engineer will design, develop, and maintain ETL data pipelines supporting daily data exchanges between core system modules and the Enhanced Reporting Capability (ERC) platform. These processes ensure that more than 6,500 users across the DoD enterprise have access to accurate and timely data for case management, analysis, and mandated reporting.
Working closely with database administrators, developers, and analysts, the engineer will support data governance, automate data quality monitoring, and assist with cloud migration initiatives. The ideal candidate will have experience with Oracle databases, SQL development, data warehousing, and modern ETL tools, with a strong focus on data integrity and DoD security compliance.
Key Responsibilities
The Data/ETL Engineer Will
Design, develop, and maintain ETL data pipelines supporting daily data transfers between the core application and the Enhanced Reporting Capability (ERC) module.
Perform secure data exchanges using SFTP between internal and external interfacing systems, supporting up to 300 data exchanges annually
Develop, maintain, and automate system interfaces and data transfer processes, including implementation of modern API-based data exchanges
Build reusable processes to connect to multiple data sources across cloud environments and integrate them into the enterprise architecture
Provide data management and governance services, including data ingestion, validation, storage, management, and quality assurance in accordance with Government-approved standards
Create data flow diagrams, perform data standardization, and support enterprise data modeling activities
Manage incoming data streams and develop mechanisms that allow users and applications to modify, access, and extract data efficiently
Identify, analyze, and resolve data quality issues, and design and implement automated data quality monitoring and control mechanisms
Conduct ongoing data quality analysis, documentation, and reporting to assess overall data health and integrity
Develop and maintain data quality dashboards and reports, including system metrics and validation checks between system data and interfacing Service systems
Automate data anomaly detection and monitoring to proactively identify inconsistencies or errors
Support database performance optimization, data recovery, and system integrity, including configuration and maintenance of database instances
Modify database structures to support application modernization efforts, including database migrations, conversions, and schema updates
Manage the migration of program updates, database changes, reference data, and configuration changes across the development lifecycle
Generate transaction analysis reports for external interfaces, including data exchange volumes, error rates, and issue tracking
Support enhanced reporting capabilities that enable congressionally mandated reporting, trend analysis, data validation, and ad hoc reporting requests
Develop business intelligence (BI) reports and dashboards as requested by the DHRA Data Governance Board and DMDC Data Stewardship Council
Integrate data from additional DoD environments such as Advana and Oracle Cloud Infrastructure (OCI) to support enterprise reporting initiatives
Requirements
Skills and Experience
The Data/ETL Engineer Must Have
DoW Clearance not Required. Ability to obtain and maintain a Tier 3 (T3) background investigation for Noncritical-Sensitive position; Tier 5 (T5) required for privileged access role
Prior experience supporting DMDC or DHRA systems
Experience with ETL development, data integration, and automated data pipeline design
Strong proficiency with Oracle databases, SQL development, and data warehousing concepts
Experience implementing secure data exchanges using SFTP and API-based integrations
Knowledge of data quality management, monitoring frameworks, and data governance practices
Experience developing BI dashboards and reports using tools such as Power BI, Tableau, Qlik, or MicroStrategy
Familiarity with cloud environments, including AWS GovCloud, Oracle Cloud Infrastructure (OCI), or other DoD-approved cloud platforms
Understanding of DoD Risk Management Framework (RMF) processes and data security requirements
Experience working within Agile or Scrum development environments
Familiarity with enterprise reporting platforms such as MicroStrategy
Education and Certifications
Required
The Data/ETL Engineer must meet the following:
U.S. Citizenship
CompTIA Security CE (DoW 8140/8570 compliant)
Preferred
Bachelor's degree in Computer Science, Data Engineering, Information Systems, Information Technology, or a related technical discipline
DoW 8140 cybersecurity workforce certifications
Benefits
Medical, dental, vision, disability, and life insurance
Flexible Spending Accounts
401(k)
PTO
Paid Parental Leave
Tuition reimbursement
Paid federal holidays
Security Clearance
Must be a U.S. Citizen. A high-level Department of Defense active security clearance is/may be required. Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to government information.
Physical Requirements
Work may involve sitting or standing for extended periods of time and typing and reading from a computer screen. The candidate must have enough mobility, including bending, reaching, and kneeling, to complete daily duties in a prompt and efficient manner, and that may include lifting up to thirty pounds, as necessary.
Company Summary
Headquartered in Hawaii, Galapagos Federal Systems, LLC, is an SBA-Certified NHO-owned 8(a) Small Business specializing in global information technology solutions. We deliver professional services in IT Design & Installation, Cybersecurity Engineering & Support, Application Integration & Development, Software & Hardware Engineering, Network & Systems Management, Information Systems Security, and Business Management Services.
Leveraging over 30 years of providing IT services to the federal & commercial market with projects found around the world, our team has innovative expertise in the development of a wide range of technological solutions. Galapagos Federal Systems, LLC is an equal opportunity employer.
Our service commitment is simple - "Quality IT Solutions... On Time & On Budget."
Company Employment Statement
Galapagos Federal Systems, LLC reserves the right to change or modify job duties and assignments at any time. The above job description is not all encompassing as positions, functions, and qualifications may vary depending on business needs. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Galapagos Federal Systems, LLC is an equal opportunity employer and does not discriminate against applicants based on race, color, creed, religion, medical condition, legally protected genetic information, national origin, sex (including pregnancy, childbirth, or related medical condition), sexual orientation, gender identity and expression, age, disability, or Vietnam era, or other eligible veteran status or legally protected characteristics.
Posted Salary Range
USD $118,000.00 - USD $124,000.00 /Yr.Please Apply at: [https://www.aplitrak.com/?adid=YmJnZW5lcmljLjYwMzE4Ljg3NjBAaG9udXNlcnZpY2VzY29tcC5hcGxpdHJhay5jb20](https://www.aplitrak.com/?adid=YmJnZW5lcmljLjYwMzE4Ljg3NjBAaG9udXNl
The Data/ETL Engineer will design, develop, and maintain ETL data pipelines supporting daily data exchanges between core system modules and the Enhanced Reporting Capability (ERC) platform. These processes ensure that more than 6,500 users across the DoD enterprise have access to accurate and timely data for case management, analysis, and mandated reporting.
Working closely with database administrators, developers, and analysts, the engineer will support data governance, automate data quality monitoring, and assist with cloud migration initiatives. The ideal candidate will have experience with Oracle databases, SQL development, data warehousing, and modern ETL tools, with a strong focus on data integrity and DoD security compliance.
Key Responsibilities
The Data/ETL Engineer Will
Design, develop, and maintain ETL data pipelines supporting daily data transfers between the core application and the Enhanced Reporting Capability (ERC) module.
Perform secure data exchanges using SFTP between internal and external interfacing systems, supporting up to 300 data exchanges annually
Develop, maintain, and automate system interfaces and data transfer processes, including implementation of modern API-based data exchanges
Build reusable processes to connect to multiple data sources across cloud environments and integrate them into the enterprise architecture
Provide data management and governance services, including data ingestion, validation, storage, management, and quality assurance in accordance with Government-approved standards
Create data flow diagrams, perform data standardization, and support enterprise data modeling activities
Manage incoming data streams and develop mechanisms that allow users and applications to modify, access, and extract data efficiently
Identify, analyze, and resolve data quality issues, and design and implement automated data quality monitoring and control mechanisms
Conduct ongoing data quality analysis, documentation, and reporting to assess overall data health and integrity
Develop and maintain data quality dashboards and reports, including system metrics and validation checks between system data and interfacing Service systems
Automate data anomaly detection and monitoring to proactively identify inconsistencies or errors
Support database performance optimization, data recovery, and system integrity, including configuration and maintenance of database instances
Modify database structures to support application modernization efforts, including database migrations, conversions, and schema updates
Manage the migration of program updates, database changes, reference data, and configuration changes across the development lifecycle
Generate transaction analysis reports for external interfaces, including data exchange volumes, error rates, and issue tracking
Support enhanced reporting capabilities that enable congressionally mandated reporting, trend analysis, data validation, and ad hoc reporting requests
Develop business intelligence (BI) reports and dashboards as requested by the DHRA Data Governance Board and DMDC Data Stewardship Council
Integrate data from additional DoD environments such as Advana and Oracle Cloud Infrastructure (OCI) to support enterprise reporting initiatives
Requirements
Skills and Experience
The Data/ETL Engineer Must Have
DoW Clearance not Required. Ability to obtain and maintain a Tier 3 (T3) background investigation for Noncritical-Sensitive position; Tier 5 (T5) required for privileged access role
Prior experience supporting DMDC or DHRA systems
Experience with ETL development, data integration, and automated data pipeline design
Strong proficiency with Oracle databases, SQL development, and data warehousing concepts
Experience implementing secure data exchanges using SFTP and API-based integrations
Knowledge of data quality management, monitoring frameworks, and data governance practices
Experience developing BI dashboards and reports using tools such as Power BI, Tableau, Qlik, or MicroStrategy
Familiarity with cloud environments, including AWS GovCloud, Oracle Cloud Infrastructure (OCI), or other DoD-approved cloud platforms
Understanding of DoD Risk Management Framework (RMF) processes and data security requirements
Experience working within Agile or Scrum development environments
Familiarity with enterprise reporting platforms such as MicroStrategy
Education and Certifications
Required
The Data/ETL Engineer must meet the following:
U.S. Citizenship
CompTIA Security CE (DoW 8140/8570 compliant)
Preferred
Bachelor's degree in Computer Science, Data Engineering, Information Systems, Information Technology, or a related technical discipline
DoW 8140 cybersecurity workforce certifications
Benefits
Medical, dental, vision, disability, and life insurance
Flexible Spending Accounts
401(k)
PTO
Paid Parental Leave
Tuition reimbursement
Paid federal holidays
Security Clearance
Must be a U.S. Citizen. A high-level Department of Defense active security clearance is/may be required. Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to government information.
Physical Requirements
Work may involve sitting or standing for extended periods of time and typing and reading from a computer screen. The candidate must have enough mobility, including bending, reaching, and kneeling, to complete daily duties in a prompt and efficient manner, and that may include lifting up to thirty pounds, as necessary.
Company Summary
Headquartered in Hawaii, Galapagos Federal Systems, LLC, is an SBA-Certified NHO-owned 8(a) Small Business specializing in global information technology solutions. We deliver professional services in IT Design & Installation, Cybersecurity Engineering & Support, Application Integration & Development, Software & Hardware Engineering, Network & Systems Management, Information Systems Security, and Business Management Services.
Leveraging over 30 years of providing IT services to the federal & commercial market with projects found around the world, our team has innovative expertise in the development of a wide range of technological solutions. Galapagos Federal Systems, LLC is an equal opportunity employer.
Our service commitment is simple - "Quality IT Solutions... On Time & On Budget."
Company Employment Statement
Galapagos Federal Systems, LLC reserves the right to change or modify job duties and assignments at any time. The above job description is not all encompassing as positions, functions, and qualifications may vary depending on business needs. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Galapagos Federal Systems, LLC is an equal opportunity employer and does not discriminate against applicants based on race, color, creed, religion, medical condition, legally protected genetic information, national origin, sex (including pregnancy, childbirth, or related medical condition), sexual orientation, gender identity and expression, age, disability, or Vietnam era, or other eligible veteran status or legally protected characteristics.
Posted Salary Range
USD $118,000.00 - USD $124,000.00 /Yr.Please Apply at: [https://www.aplitrak.com/?adid=YmJnZW5lcmljLjYwMzE4Ljg3NjBAaG9udXNlcnZpY2VzY29tcC5hcGxpdHJhay5jb20](https://www.aplitrak.com/?adid=YmJnZW5lcmljLjYwMzE4Ljg3NjBAaG9udXNl
Salary : $118,000 - $124,000