logo for information-management-architect.com
Home
Strategy
Framework
Business Case Analysis
Project Planning
Requirements Analysis
Architecture & Design
Build Phase
Quality Assurance
Transition to Production
Management Information
Business Intelligence
Data Warehouse
Tools
Jobs
Contact David Bowman
leftimage for information-management-architect.com

What Are Data Modeler Jobs?

Need information management data modeler jobs and want some practical suggestions about responsibilities, qualifications and salaries?

An information management data modeler is responsible for creating,Data Modeler Jobs 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.

What are salaries expectations for data modeler jobs?


Data modelers are senior business system analysts. They should expect to earn $85,000-110,000 with 12-15 years of related systems analysis and data modeling experience.

What are contract employee salary expectations?

Contract employees can expect to earn anywhere from $70 to $100 per hour. However, this is the amount that is paid to a staffing company. The amount the contract employee receives will depend upon the fee demanded by the resource-staffing firm.

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 IT specialists to fill data modeler jobs.

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.



footer for Information management page