PerformanceG2, Inc.

Data Vault Architect - Virtual - can work remote

All jobs Print Apply
English

Job

Active since 03-01-2017 Job category Advice / consultancy
Location Virtual - can work remote Level Professional
Educational level Bachelor / Graduate Employment type -
Hours 0 Salary -
GENERAL DESCRIPTION
• 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


KEY RESPONSIBILITIES
• 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


KEY SKILLS
• 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) - scrumalliance.org
• Professional Scrum Master (PSM) - scrum.org
• Certified Data Vault 2.0 Practitioner (CDVP2) - datavaultcertification.com


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

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

Location

Apply