Data Modeller

**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
- 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 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 dataflow understanding by collating dataflow diagrams outlining the flow of data across systems and interfaces
- Reduce non value 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 to the creation of a comprehensive governed framework by working with the data modelling CoE and contributing towards defining the data modelling standards.
- Perform peer review on work performed by other team members
- Identify opportunities to improve or enhance processes
- Provide Overall Data Management Guidance and alignment to Nedbank’s Data Management framework and standards
- Seek opportunities to improve business processes, models and systems though agile thinking.
- Support the achievement of the business strategy, objectives and values
- Contribute to the Nedbank Culture building initiatives (e.g., staff surveys etc.).
- Participate and support corporate responsibility initiatives for the achievement of business strategy

Job Related Experience
- Able to demonstrate practical experience in relational and dimensional modelling techniques, OO modelling experience also an advantage
- Exprience 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

Certifications
- TOGAF, DAMA

Type of Exposure
- Achieved transformation and innovation results
- Designed Workforce Planning Solutions
- Developed and Implemented Communications Strategy
- Managed Internal Processes
- Managed Self

Minimum Experience Level
- 3yrs IT related experience with 2yrs+ in a Data Modelling role

Technical / Professional Knowledge
- Data analysis
- Data Analysis and Interpretation
- Data Warehousing
- Data and Business analysis
- Data base Administration (DBA) Principles and Admin Concepts
- Data base administration
- Data modelling tool
- Database Knowledge
- SQL
- Problem solving skills

Behavioral Competencies
- Communication
- Decision Making
- Initiating Action
- Work Standards
- Technical/Professional Knowledge and Skills