BI Data Architect in Carmel at Vaco

Date Posted: 11/22/2019

Job Snapshot

Job Description

Data Architect

The primary function of the BI Data Architect is to provide architectural guidance, technological recommendations and transition strategies that support the development and implementation of data hub, data lake and data mart development and analytical reporting initiatives.


  • Review current state of BI data environment
  • Make recommendations for future state responsible for design, performance, security and availability
  • Determine conceptual designs, logical databases, external data interface specifications, data loading plans, data maintenance plans and data security policies (encompasses both cloud and on-premise)
  • Develop and maintain data model, designed to scale as business evolves and grows
  • Maintain formal description of the data and data structures (includes data definitions, data models, data flow diagrams)
  • Develop, document and maintain data model related standards
  • Share/define best practices and implementation plans
  • Participate in data sourcing analysis, data mapping, documenting requirements, setting up recurring data loads and testing
  • Catalog and curate our information solution across the enterprise by developing an enterprise data catalog for use by analysts. Developers, and power users
  • Responsible for assuring metadata accuracy and validity, establishes methods and procedures for tracking data integrity and quality, completeness, redundancy and improvement
  • Defines master data structures for the organization, participates in efforts to standardize data management for business processes, develops and maintains conceptual / logical / physical data models, and participates in data warehouse design and implementation
  • Identifies and develops opportunities for data reuse, migration, archiving, integration between systems and obsolescence
  • Create schemas, data types, primary & foreign keys, default values and maintain metadata for the data models
  • Leads reviews of logical and physical data models
  • Interaction with 3rd party vendors


  • 5 years' experience as an Architect in a complex data warehouse or data vault environment
  • BS in Computer Science or Information Systems or equivalent work experience
  • Working experience of Data Warehousing/Data modeling methodologies
  • Conceptual, logical and physical data modeling experience
  • Experience in database design in support of business initiatives requiring reporting and analytics
  • Proven experience developing a data infrastructure with structured management of master data, metadata, data quality, data governance, data structure, data architecture, and data security
  • Advanced development capabilities in Azure platform
  • Hands-on experience with enterprise repository tools, data modeling tools, data vault, data mapping tools and data profiling tools.

TERMS - This is a full-time opportunity with a salary range based on experience. Base+quarterly bonus

PREFERRED - Experience with Azure SQL, Azure Data Factory, SSIS, SSAS (Tabular and MDM), Agile Software Delivery, Azure Dev Ops, Azure Data Bricks

Job Requirements

BI data architect modeling warehouse marts logical physical scalability performance metadata schemas factory Azure SSIS SSAS bricks current future state