ETL Engineer

Job description

ECS is seeking a Technical PM / Business Analyst to work remotely . ECS is seeking a highly skilled ETL Engineer to support the management and maintenance of the Department of Veterans Affairs (VA) Office of Information Technology (OIT) Corporate Data Warehouse (CDW) infrastructure. As an ETL Engineer, you will support ETL operations and maintenance across a variety of legacy VA IT health and benefits systems, including the Veterans Health Information System Technology Architecture (VistA). This role also manages data models and database systems, optimizing storage, retrieval, and implementation processes. In addition to transforming complex, unstructured data into standardized healthcare constructs, you will lead database architecture efforts, resolve advanced data issues, and drive performance enhancements across our analytics and reporting platforms. Responsibilities: - ETL Development & Data Modeling - Develop, test, and maintain ETL pipelines that extract, transform, and load data from multiple healthcare systems into structured datasets. - Write complex SQL scripts to normalize and map data into healthcare constructs. - Build reusable and modular ETL components to support mul...