Senior Data Warehouse Specialist, ETL Developer

Job not on LinkedIn

🕒 4 days ago

🇺🇸 United States – Remote

⏰ Full Time

🟠 Senior

📊 Analytics Engineer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

VivSoft

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 2011

🏛️ Government

🤖 Artificial Intelligence

🏢 Enterprise

Government • Artificial Intelligence • Enterprise

VivSoft is a federal-focused technology company that builds productized, mission-focused software and services to accelerate government efficiency. The firm combines Data/AI and human-machine teaming, cloud/DevSecOps and software factories, and digital experience (UI/UX) to deliver scalable, templated solutions for government customers. VivSoft supports government contracting vehicles (OTAs, CSOs, SBIR), partners with prime contractors, and moves prototypes into production to solve complex, repeating mission problems.

📋 Description

• 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

🎯 Requirements

• 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