This job was posted by https://www.azjobconnection.gov : For more information, please see: https://www.azjobconnection.gov/jobs/7410323 Overview Job Summary

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

Honu Services

New Jobs

Data/ETL Engineer - 2767_1-4953