ECS is seeking an ETL Engineer 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 multiple data use cases with an emphasis on scalability and performance.
- Standardization & Value Set Mapping
- Collaborate with the development teams to define data hierarchies required for measure definitions.
- Overcome challenges associated with inconsistent data formats and non-standardized healthcare data models.
- Support the 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 (SQL Server Reporting Services); SSAS (SQL Server Analysis Services) 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 (UI layout/design); Font Awesome (icons); Raphaël (SVG drawings); Google Charts (data visualizations); and, jQuery and UnderscoreJS (utility libraries).
- 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 to minimize latency and maximize data throughput.
- Participate in code reviews and quality assurance checks to maintain high standards of data integrity and process reliability.
Salary Range: $100,000 - $130,000
General Description of Benefits
Preferred Qualifications- Bachelor's with 10+ years (or commensurate experience)
- Demonstrated advanced understanding of SQL and relational databases.
- Hands-on experience with cloud platforms (AWS and Azure)
Top Skills
What We Do
ECS, a segment of ASGN (NYSE: ASGN), delivers advanced solutions and services in cloud, cybersecurity, artificial intelligence (AI), machine learning (ML), application and IT modernization, and science and engineering. The company solves critical, complex challenges for customers across the U.S. public sector, defense, intelligence and commercial industries. ECS maintains partnerships with leading cloud, cybersecurity, and AI/ML providers and holds specialized certifications in their technologies. Headquartered in Fairfax, Virginia, ECS has more than 3,400 employees throughout the U.S. and has been recognized as a Top Workplace by The Washington Post for the last five years.
