To provide expertise, advice and support by executing data modelling standards, principles, frameworks and tools within area of accountability; under guidance and supervision designing and developing of logical and physical data models and databases to meet the needs of the organisation’s information systems and business requirements; and coordinate and proritise data modelling within business area.
- Maintain the data dictionary internal and external to the data model.
- Maintain the business glossary internal and external to the data model.
- Optimize and update logical and physical data models to support new and existing projects.
- Ensure that the source to target mapping is done in accordance with the requirement.
- Maintain business rules within the data model. Maintain all model related metadata.
- Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
- Recommend opportunities for reuse of data models in new environments.
- Work with data transformation teams to ensure that the model design and development is properly communicated.
- Review modifications to existing data modeling software to improve efficiency and performance.
- Manage the flow of information between departments using the data model design.
- Assure transformation rules are maintained, accurate and consistent.
- Validate business data objects for accuracy and completeness.
- Evaluate data models and physical databases for variances and discrepancies.
- Control expenditure and identify process improvements to contain and reduce costs.
- Participate in planned activities that are appropriate for own development.