Scribd
Upload
64 views2 pages

Overview of Data Modeler Roles

Data modelers can specialize in either logical or physical data modeling. Logical data modelers interact with stakeholders to understand requirements and create conceptual data models, while physical data modelers work with logical modelers and databases teams to implement technical models and databases. Nowadays, organizations prefer data modelers who can perform both logical and physical modeling.

Uploaded by

Ravin Ravin
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
64 views2 pages

Overview of Data Modeler Roles

Data modelers can specialize in either logical or physical data modeling. Logical data modelers interact with stakeholders to understand requirements and create conceptual data models, while physical data modelers work with logical modelers and databases teams to implement technical models and databases. Nowadays, organizations prefer data modelers who can perform both logical and physical modeling.

Uploaded by

Ravin Ravin
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Data Modeler Role

Data Modelers fall into two major categories of Logical or Physical Data Modelers
depending upon the role they play in developing Logical or Physical data models. Based on
organization needs, data modelers only do logical data modeling or physical data modeling or
combination of both. Nowadays, organizations prefer to hire data modelers, who can do
logical as well as physical data modeling efficiently. Logical data modelers interact with
stake holders, business analysts, smart management experts (SME) and developers. Physical
data modelers interact with logical data modelers and the database team. For logical data
modeling, please refer Logical Data Modeling and for physical data modeling, please refer
Physical Data Modeling.

Logical Data Modeler Role:

Business Requirement Analysis:


» Interact with Business Analysts to get the functional requirements.
» Interact with end users and find out the reporting needs.
» Conduct interviews, brain storming discussions with project team to get
additional requirements.
» Gather accurate data by data analysis and functional analysis.

Development of data model:


» Create standard abbreviation document for logical, physical and dimensional data models.
» Create logical, physical and dimensional data models(data warehouse data modelling).
» Document logical, physical and dimensional data models (data warehouse data modelling).

Reports:
» Generate reports from data model.

Review:
» Review the data model with functional and technical team.

Support & Maintenance:


» Assist developers, ETL, BI team and end users to understand the data model.
» Maintain change log for each data model.

Physical Data Modeler Role:

» Create sql code from data model and co-ordinate with DBAs to create development, testing,
regression and production database.
» Check to see data models and databases are in sync.
» Adding data base objects (like indexes, partitions in oracle database) for performance.
» Generating reports.

Data Modeling standardization has been in practice for many years and the following section
highlight the needs and implementation of the data modeling standards.

You might also like