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.
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||SYSP||4||Reviews system software updates and identifies those that merit action. Tailors system software to maximise hardware functionality. Installs and tests new versions of system software. Investigates and coordinates the resolution of potential and actual service problems. Prepares and maintains operational documentation for system software. Advises on the correct and effective use of system software.|
|Data modelling and design||DTAN||4||Applies data analysis, design, modelling, and quality assurance techniques, based upon a detailed understanding of business processes, to establish, modify or maintain data structures and associated components (entity descriptions, relationship descriptions, attribute definitions). Advises database designers and other application development team members on the details of data structures and associated components.|
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.
To have a career as a data modeller a bachelor level degree in areas such as information technology, information systems or business is required.