Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Cynet Systems

NewBe an early applicant

Senior Snowflake & Data Vault Data Engineer - Remote / Telecommute

Posted Updated

Description

We are looking for Senior Snowflake & Data Vault Data Engineer - Remote / Telecommute for our client in Mountlake Terrace, WA

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.

====

Benefits
Our Benefits Include:
  • 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
Disclaimer: Benefits eligibility, accrual rates, and usage limits may vary based on employment status, length of service, and work location. Paid Sick Leave is provided in strict accordance with applicable state and municipal mandates. Cynet Systems Inc. reserves the right to modify, amend, or terminate any benefit plans at any time in accordance with applicable laws.

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.
As a nationally and locally certified Minority Business Enterprise (MBE), Cynet Systems is committed to helping organizations build high-performing teams while empowering professionals to grow rewarding careers. Our organization is certified to ISO 9001, ISO 14001, ISO 27001, and SOC 2 Type II standards, reflecting our commitment to quality, security, operational excellence, and customer success.

Skills

What Senior Data Engineering jobs ask for — and how much of it you have →
Apply

See also

Data Engineering jobs by country — openings, pay and top skills →