• 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