
Senior Snowflake & Data Vault Data Engineer - Remote / Telecommute
Quick overview
Job description
Job Title: Senior Snowflake & Data Vault Data Engineer - Remote / Telecommute
Job Location: Mountlake Terrace, WA
Job Type: Contract
Pay Range: $65.00hr - $70.00hr
Job Overview:
Our client is seeking a Data Vault 2.0 Data Modeler and Snowflake & dbt Data Engineer with 7+ years of experience in Data Warehousing and Data Modeling, featuring strong hands-on experience implementing Data Vault 2.0 solutions.
Key Responsibilities & Requirements:
- Design and implement Data Vault 2.0 models, including Hubs, Links, Satellites, Raw Vault, Business Vault, Point-in-Time (PIT) tables, Bridge tables, and Information Marts.
- Translate business requirements and source-system structures into conceptual, logical, and physical Data Vault models, identifying business keys, relationships, dependencies, and historization requirements.
- Develop and maintain Snowflake SQL and dbt models, including incremental transformations, Jinja macros, reusable model configurations, and automated Data Vault loading patterns.
- Implement Data Vault transformations using AutomateDV, datavault4dbt, or equivalent dbt-based frameworks, including hash key generation, hashdiff calculations, CDC processing, and historical tracking.
- Perform source-to-target mapping, data profiling, source-system analysis, data integration, reconciliation, and validation of historical data changes.
- Optimize Snowflake queries and dbt transformation pipelines for performance, scalability, data quality, and cost efficiency.
- Collaborate with Data Vault architects, business analysts, and engineering teams to enforce modeling standards, document business rules, and support enterprise data warehouse implementation.
Mandatory Skills:
0, Snowflake SQL, dbt, Data Modeling, ELT/ETL, SQL, Business Keys, CDC, Incremental Loading, and Historical Data Management.
Preferred Skills:
0 certification (CDVP2), AutomateDV, datavault4dbt, Python, Git, CI/CD, Data Quality Frameworks, and Enterprise Data Warehousing.
Expected Deliverables:
Logical and physical Data Vault models, source-to-target mappings, Snowflake tables, dbt transformation models, automated loading logic, data quality tests, and technical documentation.
== ==
- Medical, Dental, and Vision Insurance
- 401(k) Retirement Plan
- Health Savings Account (HSA)
- Disability Insurance (Short-Term and Long-Term)
- Life and AD&D Insurance
- Paid Sick Leave (where required by applicable state or local law)
- Supplemental Insurance Plans
- Identity Theft Protection
- Pet Insurance
- Employee Wellness Programs
- Employee Assistance Program (EAP)
- Career Growth and Professional Development Opportunities
About Cynet Systems
Founded in 2010 and headquartered in the Washington, DC metro area, Cynet Systems Inc. is a leading technology staffing and workforce solutions company serving Fortune 500 companies, government agencies, and enterprise organizations across the United States and Canada. We deliver agile, scalable talent solutions across IT, engineering, life sciences, clinical, and professional staffing, powered by a high-performing recruitment engine operating across North America and Asia.
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- MR

Director of Data Engineering & Strategy | Addison, TX
Motion Recruitment Partners, LLC · Dallas, TX · Hybrid 🇺🇸
ETLSnowflakeSalary not listed - LT

Data Engineer with Security ClearanceRecently posted
L3Harris Technologies · Salt Lake City, UT · Hybrid · Posted 18 Nov 2026 🇺🇸
DockerMySQLSQL+21TechnologySalary not listed - CG
Senior Database Administrator with Security ClearanceRecently posted
Contact Government Services, LLC · Miami, FL · Hybrid · Posted 18 Nov 2026 🇺🇸
SQLAWSVMware+4Technology$89.3k - $121.2k/yr - ES
Senior Data Engineer- SQL ServerRecently posted
eSolutionsFirst, LLC · Philadelphia, PA · Remote · Posted 18 Nov 2026 🇺🇸
SQLT-SQLGit+6TechnologySalary not listed - CC

Snowflake ETL/ELT Data Engineer (Hybrid - Must be local to Denver CO)Recently posted
Cleo Consulting Inc. · United States · Hybrid · Posted 18 Nov 2026 🇺🇸
SQLGitETL+6TechnologySalary not listed - RI

Sr. Data EngineerRecently posted
Rivian · Atlanta, GA · Hybrid · Posted 18 Nov 2026 🇺🇸
PythonGenerative AIAgile+1Technology$111k - $138.7k/yr - BA

Data Engineer
Booz Allen Hamilton · Honolulu, HI · On-site 🇺🇸
AWSIoTLLM+4Technology$99k - $225k/yr - CI

Data Engineer - Vice President - CitiRecently posted
Citi · Tampa, FL · Hybrid · Posted 19 Nov 2026 🇺🇸
DockerSQLScala+16Technology$113.8k - $170.8k/yr - AM

Data Engineer - SME (Team 09) with Security ClearanceRecently posted
Amentum · Washington, DC · On-site · Posted 18 Nov 2026 🇺🇸
SQLAWSConfluence+5Technology$200k - $225k/yr - RH

Sr. Data EngineerRecently posted
Robert Half · Bloomington, MN · Hybrid · Posted 19 Nov 2026 🇺🇸
SQLApache SparkETL+14TechnologySalary not listed - RE

AI & Data EngineerRecently posted
Recruitment.ai · San Jose, CA · Hybrid · Posted 19 Nov 2026 🇺🇸
FastAPISQLAWS+8TechnologySalary not listed - SP

Data Infrastructure Operations Specialist II (Starlink)
SpaceX · Redmond, WA · Hybrid 🇺🇸
Continuous ImprovementProcurementSupply Chain Management+2Operations & Project Management$95k - $120k/yr