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 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); Raphal (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

Required Skills

• 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)

Desired Skills

• Familiarity with Agile methodologies and project management tools.
• Certifications in relevant technologies.

#ECS1

ECS is an equal opportunity employer and does not discriminate or allow discrimination on the basis any characteristic protected by law. All qualified applicants will receive consideration for employment without regard to disability, status as a protected veteran or any other status protected by applicable federal, state, or local jurisdiction law.

ECS is a leading mid-sized provider of technology services to the United States Federal Government. We are focused on people, values and purpose. Every day, our 3200+ employees focus on providing their technical talent to support the Federal Agencies and Departments of the US Government to serve, protect and defend the American People.