Data Modeller | Permanent | Hybrid (Johannesburg northern suburbs)
Job purpose
To design and maintain optimal data models/structures at both an enterprise and system / application level that meet the business and architectural objectives of the organisation. To create structures that enable data to be persisted in a structured way to enable the value of the data to be unlocked. To create appropriate data and class structures that enable the flow of data between providers and consumers.
Job responsibilities
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.
Ensure all data modelling activities and deliverables are aligned to the development methodology and to the data modelling principles and standards
Apply the company’s approved tooling to create the data modelling deliverables.
Adopt the Enterprise Data Model (which is based on the IFW) as a standard for data model designs to leverage best practice and fast track data modelling efforts.
Translate business requirements into data requirements.
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, and UML class models to ensure optimal implementation.
Compile Source to Target Mapping Specifications including the appropriate Transformation Rules
Identifying definitive or authoritative source of data; analysing source data; and identifying gaps to target structures
Enable physical implementation of the data structure by generating the first cut physical data model from the logical data model.
Facilitate data flow understanding by collating data flow diagrams outlining the flow of data across systems and interfaces.
Reduce nonvalue adding work by identifying opportunity for re-use of the Enterprise Data Model
Maintain up to date knowledge of latest developments in the Data Modelling domain, including reading; continuous professional development courses; seminars and conferences.
Contribute and provide input to the data modelling standards by participating in annual and ad hoc reviews.
Advise stakeholders on application of data modelling practices through consultation.
Identify opportunities to improve or enhance processes
Support the achievement of the business strategy, objectives and values
Contribute to the company’s Data Culture building initiatives (e.g. staff surveys etc.).
Participate and support corporate responsibility initiatives for the achievement of business strategy
Job responsibilities continued
Able to demonstrate practical experience in relational and dimensional modelling techniques, OO modelling experience also an advantage
Experience using Infosphere Data Architect or any other Data Modelling Tool
Experience with industry models such as IFW BFMDW
Broad understanding of Data Management (DMBOK), systems development lifecycle methodologies and IT Architecture
Relevant regulatory knowledge, and understanding of banking and financial services
Experience in NOSql and other forms of database modelling advantageous
Essential Qualifications - NQF Level
Matric / Grade 12 / National Senior Certificate
Advanced Diplomas/National 1st Degrees
Preferred Qualification
Bachelor of Commerce, Bachelor of Science: Information Systems / Computer Science
Essential Certifications
TOGAF
Minimum Experience Level
3-6yrs IT related experience with 2yrs+ in a Data Modelling role
Technical / Professional Knowledge
Data modelling tool
Data analysis
Data modelling tooling landscape
Data and Business analysis
Database Restore and Recoveries
Data Warehousing
Information management
Database Management
Agile Concepts
Quality control
Behavioural Competencies
Work Standards
Communication
Decision Making
Initiating Action
Hyper-Collaboration
Technical/professional knowledge
Able to demonstrate practical experience in relational and dimensional modelling techniques, OO modelling experience also an advantage
Experience using Infosphere Data Architect or any other Data Modelling Tool
Experience with industry models such as IFW BFMDW
Broad understanding of Data Management (DMBOK), systems development lifecycle methodologies and IT Architecture
Relevant regulatory knowledge, and understanding of banking and financial services
Experience in NOSql and other forms of database modelling advantageous