Data Vault Architect

  • ICC,
  • Columbus, OH
data architect, data vault, data modeling, erwin, SQL,
Full Time
Depends On Experience
Telecommuting not available Travel not required

Job Description

Data Vault Architect

ICC

Columbus, OH

Experience Level: 8+ years of professional experience

 

Information Control Company (ICC) is the largest privately held IT services provider in Ohio.  Currently, we employ over 500 team members, all of whom are equipped to deliver exceptional solutions to our clients.  Our growing size coupled with our extraordinary Consultants allow us to provide services in multiple practices, including Application Development & Integration, Business Intelligence, Collaboration Services, Core Infrastructure, and User Experience & Design.

ICC Consultants go through intensive training programs, which make them uniquely qualified to adhere to our strict standards of excellence.  Our employees understand what excellence in delivery means; they take charge of their own careers and enthusiastically talk about our solutions to colleagues and clients.  As we enter a new era driven by technology, ICC looks forward to using our expertise to help organizations lay the foundation for a profitable future. 

For more details on our consultants, our solutions, and ICC in general, visit our website.

GENERAL DESCRIPTION

The Data Vault Architect will use the 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.  Leads 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. 

 

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
  • Experience as a Business Analyst - excellent inquiry/listening skills - comfortable talking with both IT and the business at all levels of the organization. Business Analyst mentoring
  • Strong facilitation/presentation skills
  • 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

 

 The following certifications are interesting for the role:

  • Certified Data Vault 2.0 Practitioner (CDVP2) - datavaultcertification.com

 

Desired experience

  • Data Vault
  • Agile BI
  • Dimensional Modeling
  • ETL
  • Data Warehouse Automation

 

Position Benefits:

This position offers a comprehensive benefits package including:

  • Medical, Dental and Vision Insurance
  • 401K program
  • Life Insurance
  • Short-Term Disability, Long-Term Disability
  • Flexible Spending Plan
  • Tuition Reimbursement, Certification Reimbursement and Training
  • Paid Holidays, Paid Time Off (PTO) – includes vacation and sick time
  • Relocation Assistance
  • Referral Bonuses (Sales/Employee)
  • Other Incentives

 

Interested candidates should send a resume to recruiters@icct.com or call 614-523-3070.

Posted By

Sarah Solarz

2500 Corporate Exchg Dr, Suite 310 Columbus, OH, 43231

Contact
Dice Id : INCONTRL
Position Id : 573184
Have a Job? Post it

Similar Positions

Data Modeler @@ Location:- Columbus, OH
  • Sriven Systems Inc.
  • Columbus, OH
Data Modeler / Analyst
  • Collabera
  • Columbus, OH
Data Architect/Modeler
  • Solu Technology Partners
  • Columbus, OH
Data modeler
  • Deemsys Inc
  • Columbus, OH
data Modeler
  • Nityo Infotech Corporation
  • Columbus, OH
Data Vault Architect
  • Orgspire
  • Columbus
Data Engineer
  • Fusion IT Inc
  • Dublin, OH
Data Modeler
  • E*Pro, Inc.
  • Columbus, OH
Data Quality Developer - SQL/Python
  • TEKsystems, Inc.
  • Dublin, OH
9063 Data Analyst
  • ReqRoute, Inc
  • Columbus, OH
Big Data Software Engineer
  • The Judge Group
  • Worthington, OH
ETL / Data Warehouse Tester
  • Fast Switch, Ltd.
  • Columbus, OH
Data Quality Engineer
  • Ivy Tech Solutions Inc
  • Columbus, OH
Informatica Cloud Consultant-ICRT & ICS Exp Required
  • VHL Technologies
  • Worthington, OH