Sign upLog in

Senior Data Warehouse Specialist/ETL Developer

VivSoft Technologies

Herndon, VA(remote)

Apply
JOB DETAILS
JOB TYPE
Full-time
SKILLS
Agile Programming Methodologies, Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Analysis Skills, Artificial Intelligence (AI), Automation, Best Practices, Blockchain, Business Analysis, Business Intelligence, Cloud Computing, Communication Skills, Data Analysis, Data Management, Data Mart, Data Modeling, Data Processing, Data Profiling, Data Quality, Data Science, Data Warehousing, Database Extract Transform and Load (ETL), Database Programming, Dental Insurance, DevOps, Documentation, Emerging Technology, FISMA - Federal Information Security Management Act, Federal Compliance Regulations, Federal Laws and Regulations, Health Plan, Healthcare, IBM WebSphere DataStage, Identify Issues, Information/Data Security (InfoSec), Knowledge Transfer, Large-Scale Systems, Maintain Compliance, Metadata, Microservices, Microsoft SQL Server, Oracle Database, Organizational Development/Management, Performance Tuning/Optimization, PostgreSQL, Problem Solving Skills, Production Support, Quality Assurance, Query Optimization, SQL (Structured Query Language), SQL Databases, SQL Server Integration Services (SSIS), Software Design, Software Development Lifecycle (SDLC), Standard Operating Procedures (SOP), Team Player, Technical Leadership, U.S. National Institute of Standards and Technology (NIST), Unit Test, United States Department of Agriculture (USDA), United States Department of Defense (DoD), Validation Testing, Vision Plan
LOCATION
Herndon, VA
POSTED
1 day ago
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, and implement fixes/enhancements
  • Ensure compliance with data governance, security, and federal regulations (FISMA, NIST, FedRAMP)
  • Contribute to documentation, SOPs, and knowledge transfer activities
  • Provide technical leadership and enforce best practices

Skills Required:
  • Strong expertise in ETL/ELT tools (Databricks, DataStage, SSIS, AWS Glue, etc.)
  • Advanced proficiency in SQL and database development
  • Experience with data warehouse architecture and data modeling
  • Hands-on experience with cloud platforms (AWS, Databricks, Redshift, S3)
  • Knowledge of database platforms (Oracle, SQL Server, PostgreSQL, etc.)
  • Familiarity with job scheduling tools (Control-M or equivalent)
  • Experience in data quality, governance, and metadata management
  • Understanding of SDLC, Agile methodologies, and DevOps practices
  • Strong troubleshooting, performance tuning, and analytical skills
  • Knowledge of federal security and compliance standards (NIST, FISMA, FedRAMP)
  • Excellent communication and collaboration skills

Benefits:  
  • Comprehensive Medical, Dental, and Vision Plans (Healthcare benefits are 100% employer-paid for employees only)  
  • Life Insurance  
  • Paid Time Off (Flexible/Combined PTO, Bereavement Leave, 11 Company Paid Holidays)  
  • 401K Retirement Plan with employer match  
  • Professional Development Training Reimbursement.

Powered by JazzHR

About the Company

V

VivSoft Technologies

Resume Resources

Free Resume TemplatesFree Resume Builder