Data Modeller

PURPOSE STATEMENT

To design and implement data modelling solutions and design bespoke databases to enable data as an asset, translating business intent into concrete blueprints for the data environment.

To design and maintain optimal data models/structures at both an enterprise level as well as conceptual, logical & physical levels which meet the business and architectural objectives.

KEY TASKS & ACCOUNTABILITIES

Apply data modelling and design standards, tools, best practices, and related development methodologies

Work closely with data architects to design bespoke databases using a mixture of conceptual, physical, and logical data models.

Perform data modelling for the Enterprise and data architecture – translate the data architecture in the data model.

Responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).

Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices.

Design data models that meet the business requirements and align to the agreed architecture framework.

Ensure data modelling deliverables are delivered according to project plan and budget to meet commitment to stakeholders.

Apply the approved tooling to create the data modelling deliverables.

Help to create and maintain the Enterprise Logical Data Model as a standard for data model designs to leverage best practice and fast track data modelling efforts.

Monitor and guide all modelling activities (e.g. with Data Engineers)

Advise database designers and other application development team members on the details of data structures and associated components.

Apply data analysis, data modelling, and quality assurance techniques, together with an understanding of business processes to establish, modify or maintain data structures and associated components (entity descriptions, relationship descriptions, attribute definitions).

Data modelling -

Create data model designs in accordance with the enterprise data model

Engage and collaborate with team members such as data architects, data engineers and business to translate business requirements into data requirements i.e. walk through requirements and provide target patterns.

Analyse and profile the source data to understand data quality issues, relationships, patterns and rules in the data.

Structure data requirements into logical data constructs based on the Enterprise Data Model, including ERD models, dimensional models to ensure optimal implementation.

Target Mapping Specifications, complete the description or business rules for the mapping.

Ensure complete and correct data by identifying definitive or authoritative source of data, analysing source data and identifying gaps

Enable physical implementation of the data structure by generating the first cut physical data model from the logical data model.

Facilitate dataflow understanding by collating dataflow diagrams outlining the flow of data across systems and interfaces.

Data modelling standards and quality control

Implement standards for document naming, security, and lifecycle & retention architecture.

Make recommendations for standardization and proper data usage.

Highlight data integration issues and drive initiatives for prompt data clean up.

Ensure and govern all data modelling activities and deliverables are aligned to the development methodology and to the data modelling principles and standards

Identify areas where data can be used to improve business activities

KNOWLEDGE

Minimum -

Data Modelling tools e.g. Sparx Enterprise Architect, Erwin & SAP Power Designer, ER/Studio, IBM data architect

Entity Relationship Modelling

Physical Database Design

Data warehousing

Data Integration