This site uses cookies. To find out more, see our Cookies Policy

BI Architect-Oracle -151195 in Indianapolis at Vaco

Date Posted: 8/7/2018

Job Snapshot

Job Description

Vaco Technology is assisting one of our clients in their search for a full-time BI Architect. The primary function of the position is to provide architectural guidance, technological recommendations and transition strategies that support the development and implementation of data warehousing, data vault, data mart development and analytical reporting initiatives.

The desired candidate will be responsible for the data model design and metadata repository approach for the enterprise information solution. This individual will work closely with the BI team to analyze data requirements, design logical and physical models, evolve models to meet new and changing business requirements and develop processes for capturing and maintaining metadata from all data solution components.


  • Responsible for the architecture of the BI data environment, its design, performance, availability and success
  • Develop and maintain data models, 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
  • Determine conceptual designs, logical databases, external data interface specifications, data loading plans, data maintenance plans and data security policies
  • Translate business and data requirements into technical terms, propose and recommend technical solutions
  • Create schemas, data types, primary & foreign keys, default values, and maintain metadata for the data models. Will work closely with the Database Administrator to define table spaces, partitions, etc. and to ensure that the physical data model meets performance requirements for the database.
  • 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 Business Partner Power Users
  • Review and approve database change requests to safeguard the databases and data integrity
  • Develops a strategy to classify data for its most effective and efficient use to ensure data integrity and consistency
  • 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 and integration


  • Minimum 10 years of experience in IT, at least 5 years working as an architect in a complex data warehouse or data vault environment
  • Minimum 3 years of experience working in an Oracle environment
  • B.S. in Computer Science or Information Systems or 4-year degree or equivalent relevant work experience
  • In-depth understanding and 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 in master data, metadata, data quality, data governance, data structure, data architecture and data security
  • Advanced development capabilities in Oracle
  • Hands-on experience with enterprise repository tools, data modeling tools, data vault, data mapping tools and data profiling tools. Have proven ability to communicate well verbally and in writing with all levels of the organization from the senior leadership team to the individual contributors.


  • Experience as a development team member on a team using SCRUM Agile Methodology is preferred but not required.


  • This is a newly created position and will work closely with TCC's enterprise architect and DBA
  • Currently utilizing Oracle BI but this role is not constrained to that tool - road map will expand over time
  • Selling points

- Laid back culture (jeans/shorts environment)

- Onsite gym

- Flexible work schedule with work from home capabilities

- Stable company with close to $1 billion is annual revenue

- Culture of giving back to the community - In 2013, TCC launched Culture of Good to do good in its local communities where their stores are located. All efforts of good happen on a local level by the employees who help lead what has become a grass roots movement changing lives and communities in the US. Local is what the Culture of Good is all about. Partnerships happen with local organizations by Donate a Dollar; our in-store donations that are given by customers. Each dollar given goes right back into that community to further efforts to do good. Employees are encouraged to give their time to volunteer with any local organization that quarterly donations are given to