logo for information-management-architect.com
leftimage for information-management-architect.com

Data Modeler Roles And Responsibilities

Improve accountability with David Bowman’s information management guidelines for data modeler roles and responsibilities

This site is designed for Information Technology professionals who need  to improve accountability and require guidance and direction to establish information management roles.

It provides information management guidelines for data modeler roles and responsibilities.

What is a data modeler?

An data modeler is responsible for creating, and maintaining, conceptual, logical and physical data models defining information requirements for management and business intelligence purposes.

They are involved in the following tasks:

Enterprise conceptual model

An enterprise conceptual model should be created as part of the information management strategy. This is part of the business model and shows what classes of information are required to support management and business intelligence purposes.

Creation of the model requires a senior data modeler with extensive business experience. The modeler must be capable of facilitating data modeling sessions involving senior level business owners.

This is usually a “one-time” effort, as a properly designed conceptual model should only change if and when the business changes direction.

Enterprise logical model

An enterprise logical model (EDM) should be created as part of the information management framework. This model should eventually contain all entities and their relationships and a complete set of documentation. The EDM is a key part of the business model.

Creation of this model requires a senior data modeler with extensive business experience. The modeler must be capable of facilitating data discovery sessions involving business subject matter experts.

This is usually an on-going effort and data modelers will normally be involved with model maintenance.

Project logical models

An application logical model is created during the requirements analysis phase. This should be based on the enterprise logical data model created as part of the information management framework.

Creation of this model requires a data modeler with extensive analysis experience and skilled at facilitating data modeling sessions.

Physical models

Physical models are created during the project architecture and design phase and include:
  • Data warehouse; and
  • Dimensional models.
Creation of the data warehouse model involves translating the logical model into a physical model and adding the appropriate physical objects needed to create the database e.g. indexes.

The dimensional model involves creation of facts and dimensions required to meet business requirements and all physical objects needed to generate the database schema.

These tasks require a data modeler experienced with physical data model design. Most of the interaction is with the requirements analysis team and the database administrator.

Other physical data modeling tasks

The data modeler should also be experienced with:
  • Maintaining a model repository;
  • Generating data definition language (DDL) used to create the database schema;
  • Creating a model to correspond to each environment;
  • Synchronizing models to ensure that database structures match models; and
  • Testing all DDL before deployment.
What qualifications are required for data modeler jobs?

Data modelers are senior business systems analysts--they need extensive analysis experience combined with the ability to lead data modeling sessions.

They typically have experience as a business modeler, systems modeler and application designer. Data-warehousing experience is critical to the success of information management projects.

Can this work be done part time?

The creation of enterprise conceptual and logical models requires on-site group facilitation--It is a short-time frame effort and requires someone full-time for the duration.

The creation of project logical models should occur during the requirements analysis phase—After the model is created and approved, the data modeler can be assigned part time to provide on-going continuity to the architecture, design and development team.

The physical model is created in the architecture and design phase. This can be done remote or offshore.

Much of the work during the development phase involves model maintenance and responding to developer requests for new physical attributes—This can be done via telecommuting, offshore and part-time.

It may not be necessary to have a modeler assigned full time during the development and quality assurance testing phases.

Summary…

Information management projects are data centric and require highly skilled specialists for data modeler roles and responsibilities.

A data modeler plays a key role during the requirements analysis, architecture and design and development phases and some of this work may be performed off-site or part time.

This site provided information management guidelines for data modeler roles and responsibilities.