Understanding the roles and responsibilities needed for a data administration team is critical to the meta data repository's initial success and ongoing maintenance. There are nine key roles that require specific, qualified resources assigned to them in order for the team it to be successful. These roles are:

  • Project champion
  • Data administrator (project manager)
  • Repository architect
  • Data modeler
  • Business analyst
  • Data acquisition developer (back-end)
  • Data delivery developer (front-end)
  • Middleware developer
  • Infrastructure developer

This two-part series will present a detailed discussion on the functions performed by each of these roles and their key areas of responsibility. Meta data repository efforts differ in size and scope depending on the requirements of the corporation. In typical installations certain roles can be grouped together and served by the same resource. Table 1 presents the typical role combinations that have been effective in contributing to successful repository projects. Keep in mind it is best to not assign more than two roles to the same resource.

Typical Role Combinations

Data Administrator
Project Architect

Repository Architect
Data Modeler

Data Administrator
Business Analyst

Data Modeler
Data Acquisition (back-end)

Data Modeler
Data Delivery (front-end)

Middleware Developer
Infrastructure Architect

Table 1 : Typical Role Combinations

In larger implementations each role will require a dedicated, full-time resource, and multiple resources will typically be needed for the developer roles. Some of these roles are commonly filled by a central information technology (IT) infrastructure group, specifically the middleware developer and the infrastructure architect.

Project Champion

Any major, cross-departmental IT effort, whether it's a decision support system (DSS) or the implementation of a hot new enterprise resource planning (ERP) package, needs executive management support. Their involvement is imperative in breaking down the barriers and gaining access to the "ivory towers" found in all of our companies. Given their position, these executives have the ability to rally the various departments within a corporation behind enterprise-level goals of the project. Any substantial project lacking executive management participation has a high probability of failure.

Data Administrator (Project Manager)

The data administrator's responsibilities include project planning, staff assembly/configuration and setting the vision and strategy for the repository. This person needs experience leading successful meta data repository implementation efforts. They need strong communication skills and the ability to grow and develop their staff. It's important to realize that the project manager's job is not to make a "star" out of everyone. Instead the data administrator's role is to assign each resource into a role that best fits their skill sets and goals, thereby getting the most out of each employee. This person understands how to manage end-user expectations, conduct end-user training and understand how to manage vendors (software and consulting).

The data administrator has a strong grasp on how to define standards that the other IT teams will adhere to. It's critical to thoroughly communicate these standards and keep them easy to abide by and understand. If these standards are not kept simple, the data administration team will be looked upon as a bottleneck ­ once this occurs it is only a matter of time before the project fails. There is an old data administration joke (actually I believe it is the ONLY existing data administration joke that addresses this problem: What is the difference between a data administrator and a terrorist? You can negotiate with a terrorist!

Repository Architect

The repository architect is responsible for the technical architecture upon which the physical meta data repository, and the access to it, are based. In addition, the architect must have experience architecting successful meta data repository efforts as this person will define and enforce the construction standards each developer (data acquisition and data delivery) will use during implementation.

The repository architect needs to know how to evaluate the physical data model used to store the business and technical meta data. In addition, the architect must follow the trends in the meta data industry, especially the battle for meta model standards between Microsoft and Oracle. Also, this person must have a deep understanding for what meta data software tools do and don't do.

Data Modeler

The data modeler's responsibilities include the design and construction of the meta model (physical data model) that will hold the meta data (both business and technical meta data). This person does not necessarily need experience modeling meta data. A very good, experienced data modeler that understands multidimensional and third normal form modeling can be quite successful when working with an experienced data administrator and repository architect.

The data modeler needs to understand the database technology used for the physical table implementation and the indexing strategies needed to speed access. This person also needs good communication skills to work with the business/technical end users and business analysts.

It is difficult finding experienced people for some of these roles ­ especially those of the data administrator and repository architect. If it is necessary to bring in an outside consultant, make sure the consultant is highly skilled in knowledge transfer and mentoring.

Next month we will examine the remaining meta data repository project roles and responsibilities.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access