ECS Federal, LLC - ETL Engineer

Client: ECS Federal, LLC

Location: Remote

Job Description

ECS is seeking a highly skilled ETL Engineer to work remotely in support of the Department of Veterans Affairs (VA) Office of Information Technology (OIT) Corporate Data Warehouse (CDW) infrastructure. The role involves supporting ETL operations and maintenance across various legacy VA IT health and benefits systems, including VistA. Responsibilities include managing data models, optimizing storage and retrieval processes, transforming complex unstructured data into standardized healthcare constructs, leading database architecture efforts, resolving advanced data issues, and driving performance enhancements across analytics and reporting platforms.

Responsibilities

• ETL Development & Data Modeling
• Develop, test, and maintain ETL pipelines to 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 multiple data use cases with an emphasis on scalability and performance.
• Standardization & Value Set Mapping
• Collaborate with development teams to define data hierarchies required for measure definitions.
• Overcome challenges associated with inconsistent data formats and non-standardized healthcare data models.
• Support ongoing definition, validation, and enhancement of clinical quality measures through clean, standardized datasets.
• Reporting & Business Intelligence Integration
• Ensure ETL processes support accurate data delivery for business intelligence tools such as SSRS, SSAS Cubes, and Excel Templates integrated with SSAS Cubes.
• Assist report developers in troubleshooting data quality or mapping issues arising from backend pipelines.
• Cross-collaboration with Functional Teams
• Partner with developers using VueJS and libraries such as Bootstrap, Font Awesome, Raphael, Google Charts, jQuery, and UnderscoreJS.
• Ensure data pipelines align with UI requirements and performance needs of interactive dashboards or data visualization tools.
• Quality Assurance, Documentation, and Optimization
• Write and maintain detailed technical documentation of ETL processes, mappings, and transformations.
• Conduct regular performance tuning and optimization of SQL queries and ETL jobs.
• Participate in code reviews and quality assurance checks to maintain high standards of data integrity and process reliability.

Requirements

• Bachelor’s degree with 10+ years of experience (or commensurate experience)
• Demonstrated advanced understanding of SQL and relational databases.
• Hands-on experience with cloud platforms (AWS and Azure).

Salary and Benefits

Salary Range: $100,000 - $130,000

General Description of Benefits: More information can be found at ECS Benefits.