Domain Data Modeller

SUMMARY:
A Financial Institution (One of the big five in South Africa) has a vacancy for a Domain Data Modeller, Data Delivery candidate.   Please note this is a contract position

POSITION INFO:
PLEASE NOTE THIS IS A CONTRACT POSITION
Degree:   Bachelor in Information Technology - IT Engineer or Information Management

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 of the Company
The job holder must be aware of the external data legislation such as POPI and best practice in terms of Data Management (DAMA,) both of which are catered for by operating within the Company''s policies detailed below.The job holder may liaise with external vendors or service providers and will participate in relevant data management forums.
The job holder operates within the following internal policies:
Data Modelling Policy
Information Management Policy
Information Security Policy
IT Governance Policy
Data Governance Policy
The job holder must adhere to internal Systems Design Quality Standards (programming and development best practices) and the approved Data Product Life Cycle (DPLC)

The job holder will liaise with various internal departments:
Other Data Delivery Shared Services functions
Retail and Banking Data Delivery
Subject Domain Modellers in the value streams
Technology
SMEs across the bank
The Domain Data Modeller sits in the modelling function between the Enterprise Data Modeller and Subject Data Modeller and will have subject matter expertise in a particular area, for example risk and master data, working 70% on modelling and 30% governance. 
Domain Data Modelling subject matter expert.
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) to ensure alignment with the EDM and conformity to standards
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).
Maintain up to date knowledge of latest developments in the Data Modelling domain, including reading, continuous professional development courses, seminars and conferences where appropriate.
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
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
Data quality
Master data management
Metadata
Knowledge of database concepts, objects and data modelling
techniques and design principles.
Expert knowledge of data modelling principles/methods including conceptual, logical & physical Data Models
Knowledge of the entire process behind software development
including design and deployment
Relational modelling
Dimensional modelling
Data normalisation
Data modelling patterns e.g. party role
Broad understanding of Data Management (DMBOK), systems development lifecycle methodologies and IT Architecture

Canonical Data Modelling
Banking and financial services environments
BI tools and technologies as well as the optimization of underlying databases
How to clearly communicate complex technical ideas, regardless of the technical capacity of the audience
Knowledge of the mathematical foundations of data normalisation

NB! This job is now closed. You can apply for other jobs by uploading your CV.