Job Description
Job Title: Senior Data Warehouse Specialist/ETL Developer Location: Remote Position Type: Full-Time About the company: At VivSoft, we aim to solve complex federal problems using emerging and open technologies in a collaborative and rewarding environment. VivSoft is a diverse team of strategists, engineers, designers, and creators experienced in building high-performance, effective software, with a focus on impactful organisational design and software delivery dynamics. We build secure Software Factories based on DoD reference designs and NIST Frameworks for Cloud and DevSecOps. These factories deliver AI/ML Applications, Data Science Platforms, Blockchain and Microservices for DoD, Healthcare and Civilian Agencies Job Summary: The Senior Data Warehouse Specialist / ETL Developer will be responsible for designing, developing, and maintaining enterprise data pipelines, data warehouses, and data integration solutions to support analytics, reporting, and decision-making across large-scale systems. This position supports an upcoming project with the United States Department of Agriculture (USDA). This role ensures high-quality, secure, and performant data processing aligned with federal standards, data governance policies, and industry best practices. Key Responsibilities: Design, develop, and maintain ETL/ELT pipelines for data integration from multiple source systems Build and enhance data warehouses, data marts, and analytics platforms Perform data extraction, transformation, cleansing, and loading to ensure data quality and accuracy Optimize SQL queries, ETL jobs, and data processing performance Support data modeling (conceptual, logical, physical) and metadata management Develop and maintain data integration workflows and automation processes Conduct data profiling, validation, and testing (unit, integration, performance, data quality) Collaborate with data architects, BI developers, business analysts, and QA teams Provide production support, troubleshoot issues, an
