Senior Data Vault Builder/ Developer – New Haven, CT (Remote) – Fulltime

Job Description

**Job Title: Senior Data Vault Builder/ Developer**

**Location: New Haven, CT (Remote)**

**Duration: Fulltime**

**(“US citizens and Green Card Holders and those authorized to work in the US are encouraged to apply. We are unable to sponsor H1b candidates at this time.”)**

**A reasonable, good faith estimate of the minimum and maximum for this position is $130K/year to $150K/year with benefits**

Job Description:

**Overview**

We are looking for a seasoned Data Vault Developer / Builder to support the implementation of Raw Vault, Business Vault, and Info Mart layers using Data Vault methodology. This role requires hands-on experience with VaultSpeed or equivalent tools (e.g., WhereScape 3D), strong SQL development, and a good understanding of data modeling, lineage, and integration patterns. The ideal candidate will have a track record of delivering performant, scalable data solutions in enterprise data environments, especially those leveraging Snowflake.

**Core Responsibilities**

– Design, build, and maintain Raw Vault components (hubs, links, satellites) using VaultSpeed or similar tooling (e.g., WhereScape 3D).
– Develop and optimize Business Vault and Info Mart layers to support business consumption and analytics.
– Implement performant ETL/ELT pipelines using SQL, views, stored procedures, and VaultSpeed-generated code.
– Interpret mapping documents and business rules; translate them into scalable and maintainable Data Vault models.
– Apply CDC (Change Data Capture) patterns and implement SCD Type 2 logic for historical tracking and accuracy.
– Monitor and tune the performance of data pipelines across all vault layers.
– Serve as a gatekeeper for source data profiling and validation to ensure design alignment.
– Generate technical diagrams and documentation to clearly communicate end-to-end pipeline logic from source to Raw Vault, Business Vault, and Info Mart.
– Ensure consistency with data governance, metadata standards, and VaultSpeed naming conventions.
– Collaborate with data architects, business SMEs, and analytics teams to clarify requirements and ensure business alignment.

**Skills Qualifications**

**Required:**

– Hands-on experience with Data Vault across all major layers: Raw Vault, Business Vault, and Info Mart.
– Strong experience designing and implementing Star Schema / Dimensional Models.
– Proficiency in VaultSpeed (WhereScape 3D experience is acceptable with willingness to complete VaultSpeed Academy training)
– Strong SQL skills, with experience building complex queries and transformation logic.
– Proficient in understanding and working with models in erwin or similar data modeling tools.
– Solid grasp of data lineage concepts, with the ability to produce lineage views in Snowflake.
– Experience in Snowflake environments, with a deep understanding of data warehousing best practices.
– Familiarity with metadata management, data governance, and MDM principles.
– This position requires occasional off-hours support based on business needs.

**Preferred:**

– Data Vault Certified Professional (DVCP) 2.1 certification
– Snowpro Certification
– Experience integrating with BI tools or self-service reporting layers
– Familiarity with Agile delivery frameworks (e.g., Scrum)
– Strong documentation and communication skills, especially when interfacing with business and technical stakeholders

**Education**

**Required:**

– BA or BS in Computer Science, Information Systems or related field
– 8+ years’ experience