The global skills and competency framework for the digital world

Data modelling and design DTAN

Developing models and diagrams to represent and communicate data requirements and data assets.

Guidance notes

Data modelling supports activities such as — but not limited to:

  • helping organisations understand their data assets, developing software systems, and the relationships between real-world entities
  • data engineering, integration and interoperability
  • data retrieval
  • data governance and master data management.

There is a range of different types of data models. However they typically contain the same components — entities, relationships, attributes and domains.

Types of data models include — but are not limited to — relational, object-oriented, NoSQL, time-based.

Data models are used to communicate different levels of detail — conceptual, logical and physical. 

Levels

Defined at these levels: 2 3 4 5

Data modelling and design: Level 1

This skill is not typically observed when working at this level of responsibility.

Data modelling and design: Level 2

Establishes, modifies or maintains simple data structures and associated components.

Uses specific data modelling and design techniques under guidance.

Data modelling and design: Level 3

Applies standard data modelling and design techniques based upon a detailed understanding of requirements.

Establishes, modifies and maintains data structures and associated components.

Communicates the details of data structures and associated components to others using the data structures and associated components.

Data modelling and design: Level 4

Investigates enterprise data requirements where there is some complexity and ambiguity.

Plans own data modelling and design activities, selecting appropriate techniques and the correct level of detail for meeting assigned objectives.

Provides advice and guidance to others using the data structures and associated components.

Data modelling and design: Level 5

Sets standards for data modelling and design tools and techniques, advises on their application and ensures compliance.

Manages the investigation of enterprise data requirements based upon a detailed understanding of information requirements.

Coordinates the application of analysis, design and modelling techniques to establish, modify or maintain data structures and their associated components.

Manages the iteration, review and maintenance of data requirements and data models.

Data modelling and design: Levels 6-7

This skill is not typically observed when working at these levels of responsibility.