Hybrid Details: Onsite 2 days/week

Job Description

• 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.

• 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.

• 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.

• Data Vault Certified Professional (DVCP) 2.1 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

• BA or BS in Computer Science, Information Systems or related field
• 8+ years experience
• Authorization to work in the United States is required
• This position is not eligible for visa sponsorship.

• Must be able to remain in a stationary position for a majority of the workday.