PerformanceG2, Inc.

Data Vault Architect - Virtual - can work remote

All jobs Print Apply


Active since 03-01-2017 Job category Advice / consultancy
Location Virtual - can work remote Level Mid-Senior level
Educational level Bachelor / Graduate Employment type -
Hours 0 Salary -
• Uses Data Vault 2.0 system of business intelligence for the design of the acquisition, information, and technical architecture for the data warehouse and related analytic data sets
• Oversees the development of logical and physical data models, ETL scripts, metadata definitions and models, queries and reports, schedules, work processes, and maintenance procedures
• Responsible for the Design Architecture to extract, transform, and move data and metadata to be loaded into Staging, Data Vault Data Warehouse, and Information Marts
• Defines and documents the technical architecture of the data warehouse, including the physical components and their functionality
• Coordinates the work of technical, information, acquisition, ETL, and BI analysts
• Applies Agile BI processes and concepts to delivery faster time-to-benefit results

• Creates a robust, sustainable architecture that supports requirements and provides for expansion given budgetary constraints and availability of data and skilled resources
• Evaluates and selects various data warehousing tools and components
• Coordinates multiple analysts responsible for the development, integration, administration, and evolution of the data warehouse
• Work with business requirements analysts to identify and understand source data systems
• Map source system data to data warehouse models Designs the extraction, transformation, and load (ETL) processes
• Interviews end users to determine requirements for data, reports, analyses, metadata, training, service levels, data quality, and performance
• Designs conceptual and logical models for the data warehouse or data mart
• Communicates physical database designs to database administrator
• Evolves models to meet new and changing business requirements

• Prior experience building data warehouses using Data Vault
• Knowledge of Kimball Data Marts
• Prior experience with Enterprise Architecture
• Multi-team management
• Requirements Management
• Business Analyst mentoring
• Data Modeling data flow processing skills
• Business process modeling skills
• Corporate metadata and ontology skills
• Multi-platform environments (Hadoop mixed with relational), data flow processing.
• Strong conceptual, communications, and technical skills

Years of experience: 10+ years

The following certifications are interesting for the role:
• Certified Scrum Master (CSM) -
• Professional Scrum Master (PSM) -
• Certified Data Vault 2.0 Practitioner (CDVP2) -

Desired experience
• Data Vault
• Agile BI
• Dimensional Modeling
• Data Warehouse Automation
• Cloud BI

More information
This listing is a full-time job

Job category Advice / consultancy
Industry / Industries Consultancy
Region United States
Keywords Data Vault, CDVP2, Dimensional Modeling, Agile BI, Cloud BI, MDM

Contact information

Name Human Resources