Senior Snowflake & Data Vault Data Engineer - Remote / Telecommute
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.
Skills
Sign in to read and join the discussion.