Data​/ETL Engineer

Overview

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.

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

• DoW Clearance not Required. Ability to obtain and maintain a Tier 3 (T3) background investigation for a Noncritical‑Sensitive position;
  Tier 5 (T5) required for a 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.
• Knowledg…