V Skill HF-D7.3-001 sector-specific 9 skills
Data modelling
Describes data and its relationships in a model with entities, attributes and keys that matches the work process.
How hrmforce measures this
- Assessment method
- Work sample test · rho 0.33 (SD 0.09)
- hrmforce instrument
- Knowledge test (client-specific), Work sample test
- Competency (50-framework)
- Conceptual thinking
- Trainability
- high
- Demand outlook 2026 to 2030
- stable
The candidate performs a representative work sample under standardised conditions.
Behavioural anchors
| Level | Behaviour at this level |
|---|---|
| N1 Guided | Extends an existing data model with new fields following the applicable naming conventions and has the work reviewed. works under supervision and follows instruction · routine, one variable at a time · own task |
| N3 Proficient | Designs a logical data model for a defined domain, normalises where needed and discusses choices with users and developers. sets own approach and seeks input proactively · several variables, some ambiguity · own team or process |
| N5 Leading | Sets the organisation's modelling standards and core data model and decides on deviations from them. sets the standard and the policy · strategic, under high uncertainty · organisation, value chain or profession |
N2 and N4 are deliberately not anchored. Raters place them between the anchors, following the O*NET convention.
Underlying skills
These skills inherit the assessment route and the behavioural anchors of this construct.
| T | Skill | Definition | Demand outlook 2026 to 2030 |
|---|---|---|---|
| V | Drawing an entity relationship diagram ERD · Entity relationship diagram | Draws entities, attributes and relationships with cardinalities in a diagram that recognisably reflects the work process. | stable |
| V | Normalising a data model Normalisation | Splits tables up to third normal form to prevent repetition and contradictory data. | stable |
| V | Defining keys and identification Primary key · Foreign key | Chooses primary and foreign keys, decides between a natural or surrogate key and records uniqueness. | stable |
| V | Designing a star schema Star schema · Dimensional modelling | Designs a fact table with dimensions for reporting and determines granularity and measures per fact. | stable |
| V | Setting up slowly changing dimensions Slowly changing dimensions | Records how history in dimensions is preserved so reports about the past remain correct. | stable |
| V | Distinguishing logical and physical models Logical data model | Develops a conceptual model into a logical and physical model and keeps both aligned. | stable |
| V | Creating a data dictionary Data dictionary | Describes meaning, format, allowed values and source per field so users interpret the data identically. | rising |
| V | Modelling semi structured data JSON schema | Models nested data from json or xml with a schema, mandatory fields and versioning of the structure. | rising |
| V | Validating a data model with users Model validation | Walks through a model with subject experts using examples and adjusts it for exceptions found. | stable |