FREE ACCESS
5,000–10,000 jobs/day
See all jobs on JobTailor
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Senior Data Warehouse Specialist, ETL Developer
VivSoftSenior Data Warehouse Specialist/ETL Developer responsible for data pipelines at VivSoft. Collaborating to achieve high-quality data processing and integration solutions for USDA projects.
Tech Stack
Tools & technologiesAmazon RedshiftAWSCloudETLOraclePostgresSDLCSQLSSIS
About the role
Key responsibilities & impact- 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
What you’ll need- 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
Comp & perks- 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
ATS Keywords
✓ Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
ETLELTSQLdata modelingdata extractiondata transformationdata cleansingdata loadingperformance tuningdata quality
Soft Skills
communicationcollaborationtroubleshootinganalytical skillstechnical leadership