Senior Data Vault Builder (Remote – EST Hours)
Compensation: $160,000 – $175,000
Location: Fully Remote (U.S. – Eastern Time Zone)
Category: Information Technology
About the Opportunity
We’re seeking an experienced Senior Data Vault Builder to design, implement, and maintain enterprise-scale Data Vault solutions supporting analytical and operational data needs. This is a hands-on technical position focused on architecting and optimizing Raw Vault, Business Vault, and Info Mart layers using Data Vault 2.0 methodologies.
This opportunity is ideal for a seasoned data professional with deep expertise in VaultSpeed (or WhereScape 3D), strong SQL skills, and a solid understanding of data modeling, lineage, and performance optimization—particularly within Snowflake environments.
Key Responsibilities
-
Design, build, and maintain Raw Vault components (hubs, links, satellites) using VaultSpeed or similar tooling.
-
Develop and optimize Business Vault and Info Mart layers to support analytics and reporting.
-
Implement efficient ETL/ELT pipelines using SQL, views, stored procedures, and VaultSpeed-generated code.
-
Translate mapping documents and business rules into scalable Data Vault models.
-
Apply CDC (Change Data Capture) and SCD Type 2 logic for historical tracking.
-
Monitor, troubleshoot, and tune data pipeline performance across all vault layers.
-
Profile and validate source data for design alignment and accuracy.
-
Create clear technical documentation and data flow diagrams from source through vault layers.
-
Ensure compliance with data governance and metadata standards.
-
Collaborate closely with data architects, business SMEs, and analytics teams to ensure business alignment.
Required Skills & Experience
-
8+ years of professional experience in data engineering or data warehousing.
-
Proven expertise building and maintaining all layers of the Data Vault (Raw, Business, and Info Mart).
-
Proficiency with VaultSpeed or WhereScape 3D (and willingness to complete VaultSpeed training).
-
Advanced SQL development and performance tuning skills.
-
Experience designing and implementing Star Schema / Dimensional Models.
-
Strong understanding of data lineage, governance, and metadata management.
-
Hands-on experience in Snowflake environments.
-
Proficiency in erwin or similar data modeling tools.
-
Ability to provide occasional off-hours support as required.
Preferred Qualifications
-
Data Vault Certified Professional (DVCP) 2.1 certification.
-
Experience integrating with BI or self-service analytics tools.
-
Familiarity with Agile/Scrum development methodologies.
-
Strong communication skills and ability to document complex data flows for both technical and business audiences.
Education
-
Bachelor’s degree in Computer Science, Information Systems, or a related field.
Compensation & Employment Details
-
Salary Range: $160,000 – $175,000 (based on experience, certifications, and technical proficiency).
-
Schedule: Full-time, remote (must be available to work EST business hours).
-
Work Authorization: U.S. work authorization required; sponsorship not available.