Data Vault Architect/Engineer

Programmers.io; Louisville (KY); On-site; USD 110,000 - 160,000; Full time

Job summary

Programmers.io is seeking an experienced Data Vault Architect/Engineer to design, develop, and optimize scalable Data Vault 2.0 data warehouse solutions. You will build Hubs, Links, Satellites, PIT, and Bridge tables, and develop robust ETL/ELT pipelines to integrate data from multiple sources while upholding Data Vault standards and governance.

The role focuses on enhancing data quality, performance, and scalability across cloud platforms to support enterprise analytics and BI initiatives.

Qualifications

• Experience with Data Vault 2.0 methodologies and modeling.
• Strong ETL/ELT development skills.

Responsibilities

• Develop and implement Data Vault 2.0 data warehouse architectures and models.
• Develop Hubs, Links, Satellites, PIT, and Bridge tables to support scalable analytics.
• Build and maintain ETL/ELT pipelines for integrating data from multiple source systems.
• Define and enforce Data Vault standards, governance, and best practices.
• Optimize data loading, performance, and scalability across cloud platforms.

Skills

Data Vault 2.0

ETL/ELT pipelines

Job description

Seeking an experienced Data Vault Architect/Engineer to design, develop, and optimize scalable Data Vault 2.0 data warehouse solutions. The role involves building and maintaining Hubs, Links, Satellites, PIT, and Bridge tables, developing robust ETL/ELT pipelines for integrating data from multiple source systems, and ensuring adherence to Data Vault standards, governance, and best practices. The candidate will be responsible for enhancing data quality, performance, and scalability across cloud platforms to support enterprise analytics and business intelligence initiatives

Key Responsibilities

• Develop and implement Data Vault 2.0 data warehouse architectures and models.
• Develop Hubs, Links, Satellites, PIT, and Bridge tables to support scalable analytics.
• Build and maintain ETL/ELT pipelines for integrating data from multiple source systems.
• Define and enforce Data Vault standards, governance, and best practices.
• Optimize data loading, performance, and scalability across cloud platforms.

Required Skills

• Data Vault 2.0
• ETL/ELT pipelines