Data modeller
Description
A Data Modeller is responsible for creating a graphical model or a data model of how data will be stored. A data model is a way of structuring and organising the data that will be stored in a database. The model will also show how each piece of data should relate to every other piece of data.
The data model will also show a number of rules regarding the data. These rules will place constraints on the data to ensure there is integrity in the way the data is stored and displayed to users. The model ensures that each piece of data has an identity, it also establishes whether each piece of data is either a unique identity or if there can be multiple instances of data. For example, a database that holds information about clients needs to ensure that each client is unique, so therefore the data model will show that the client is a unique piece of data.
The data modeller will work closely with key stakeholders from the business to determine the data requirements. This is generally completed as part of the database or information system design project.
A data modeller exhibits a combination of capabilities from the Skills Framework for the Information Age (SFIA) and from the Leadership competencies for Queensland.
SFIA profile
Within the SFIA profile, the data modeller has level 3 and 4 capabilities, i.e. applies and enables the skills outlined below.
Refer to the framework for descriptions of the seven levels of responsibility and accountability.
 SFIA skill | SFIA skill code | SFIA skill level of responsibility | SFIA skills level descriptor |
|---|---|---|---|
| Systems software administration | SYSP | 4 | Monitors system software metrics and adjusts configurations for optimum availability and performance. Applies technical expertise to investigates and resolve complex system software issues, requesting action from supplier if required. Analyses system software updates and determines which ones require actions. Develops comprehensive software implementation procedures with robust contingency plans |
| Data modelling and design | DTAN | 4 | Investigates enterprise data requirements where there is some complexity and ambiguity. Plans data modelling and design activities, selecting appropriate techniques and levels of detail to meet objectives. Provides advice and guidance to others using the data structures and associated components. |
Leadership skills
Leadership competencies for Queensland describes what highly effective, everyday leadership looks like in the sector. In simple, action-oriented language, it provides a common understanding of the foundations for success across all roles. The profile describes three performance dimensions (vision, results and accountability) and 11 leadership competencies required against five leadership streams.
Leadership streams are not connected to a level or classification, but rather reflect the balance between leadership and technical skills required of an individual. Individuals can consider the value proposition of roles rather than the traditional lens of hierarchical structures or classification levels. The five leadership streams are:
- Individual contributor (Leads self and does not supervise others)
- Team leader (leads a team and typically reports to a program leader)
- Program leader (leads team leaders and/or multiple areas of work)
- Executive (leads program leaders or other executives)
- Chief executive (leads the organisation).
When developing a role description, identify the role type and then focus on the most important attributes and create a balance between SFIA skills and leadership skills.
Entry points
To have a career as a data modeller a bachelor level degree in areas such as information technology, information systems or business is required.