This job was posted by https://www.azjobconnection.gov : For more
information, please see: https://www.azjobconnection.gov/jobs/7392973
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
Responsibilities
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
