Senior Data Vault Designer

#LI-Hybrid

Overview

We are seeking a skilled and experienced Business / Data Vault Architect to lead the design and implementation of business-centric data solutions using Data Vault 2.1 methodology. This role will focus on architecting and maintaining the Raw Vault, Business Vault, and Info Mart layers, while applying best practices from both Data Vault and Kimball methodologies. The ideal candidate will be adept at translating business requirements into scalable data models that drive self-service analytics and decision-making.

Core Responsibilities

• Design Data Vault Layers:
  • Raw Vault: Design hubs, links, satellites, and reference tables.
  • Business Vault: Build business-friendly structures including PITs, bridges, hybrid models, and business satellites.
  • Info Mart: Design dimensional models (facts, dimensions, and bridges) to support BI and self-service reporting.
• Data Model Modeling:
  • Create and maintain data models in Erwin (or similar data modeling tools) at conceptual, logical, and physical levels.
  • Ensure clear mappings and lineage across Raw Vault, Business Vault, and Info Mart layers.
• Business Alignment:
  • Collaborate with business SMEs to gather requirements, understand reporting needs, and define data transformation logic.
  • Interface directly with business teams to document ontologies, taxonomies, and standardized naming conventions.
• Reverse Engineering:
  • Reverse engineer physically generated Raw Vault and Business Vault objects from the Data Vault acceleration tool (such as VaultSpeed).
  • Reverse engineer database sources and organize appropriately
• Best Practices & Governance:
  • Contribute to data governance, metadata standards, and documentation quality.

Skills Qualifications

Required:

• Strong experience designing Data Vault and Kimball Star Schema models.
• Expertise in building scalable data solutions across Raw Vault, Business Vault, and Info Mart layers.
• Proficiency in Erwin or similar data modeling tools.
• Deep understanding of PITs, bridges, hybrid structures, and satellites.
• Familiarity with Data Vault acceleration platforms such as VaultSpeed.
• Agile mindset with strong communication and stakeholder collaboration skills.
• Proven ability to collect and translate business requirements into actionable data architecture

Preferred:

• 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

Compensation

The wage range for this role takes into account a broad array of factors that are considered in making compensation decisions, including but not limited to: skill sets; experience and training; licensure and certifications; and other business and organizational needs.  The range below applies as long as the work is performed in Connecticut; the Knights of Columbus reserves the right to adjust the wage range if the position is performed in another location.  At the Knights of Columbus, it is not typical for an individual to be hired at or near the top of the range for their role, and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is $104,500 - $172,400.

Education

Required:

• 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

Physical Demands