Share this Job

Subject Data Modeller

Date: 02-Aug-2022

Location: Stellenbosch, Western Cape, ZA

Company: Capitec Bank Ltd

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 of Capitec.

Experience

Minimum:

  • 1 years + experience in the Data Modelling discipline with additional 2 – 3 yrs in another data role such as Data Engineer, Data Analyst or BI Business Analyst.
  • Experience using one of the following data modelling tools e.g Sparx Enterprise Architect, Erwin, SAP PowerDesigner, ER/Studio or IBM data architect
  • Exposure to relational data models
  • Experience working with dimensionally modelled data
  • Demonstrable data profiling experience 

Ideal:

  • Experience in supporting as well as implementing data infrastructures
  • Proven analytical and problem-solving experience in a complex data environment
  • Experience with generic financial industry data models (products) 
  • Exposure to graph data models and NoSQL models
  • Relevant industry experience i.e. financial services or retail.

Qualifications (Minimum)

  • Grade 12 National Certificate / Vocational in Grade 12 National Certificate
  • Bachelor's Degree in Information Technology - IT Engineering or Information Management

Qualifications (Ideal or Preferred)

  • Certification in Data Management

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
  • Data quality
  • 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

Ideal:

  • Master data management
  • 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 

Skills

  • Analytical Skills
  • Problem solving skills
  • Attention to Detail
  • Communications Skills
  • Decision making skills

Competencies

  • Deciding and Initiating Action
  • Deciding and Initiating Action_Acting Decisively
  • Deciding and Initiating Action_Demonstrating Initiative
  • Deciding and Initiating Action_Making Accurate Judgments and Decisions
  • Relating and Networking
  • Relating and Networking_Creating and Maintaining Networks
  • Relating and Networking_Establishing Relationships
  • Relating and Networking_Interacting with People at Different Levels
  • Relating and Networking_Managing Political Situations
  • Presenting and Communicating Information
  • Presenting and Communicating Information_Communicating Effectively
  • Presenting and Communicating information_Presenting and Public Speaking
  • Applying Expertise and Technology
  • Applying Expertise and Technology_Displaying Technical Expertise
  • Applying Expertise and Technology_Using Computers and Technology
  • Analysing
  • Analysing_Critical Thinking
  • Analysing_Reading Effectively
  • Analysing_Evaluating and Implementing Ideas
  • Analysing_Solving Complex Problems
  • Analysing_Testing and Troubleshooting
  • Analysing_Thinking Broadly
  • Analysing_Using Math
  • Analysing_Working with Financial Information
  • Learning and Researching
  • Learning and researching_Acquiring Information
  • Learning and researching_Learning Quickly
  • Creating and Innovating
  • Creating and Innovating_Developing Plans
  • Creating and Innovating_Displaying Creativity
  • Planning and Organising
  • Planning and Organising_Coordinating Project Activities
  • Planning and Organising_Driving Projects to Completion
  • Planning and Organising_Managing Resources
  • Planning and Organising_Prioritising and Organising Work
  • Delivering Results and Meeting Customer Expectations
  • Delivering Results and Meeting Customer Expectations_Championing Customer Needs
  • Delivering Results and Meeting Customer Expectations_Delivering High Quality Work
  • Delivering Results and Meeting Customer Expectations_Meeting Basic Work Expectations
  • Delivering Results and Meeting Customer Expectations_Serving Customers
  • Adapting and Responding to Change
  • Adapting and Responding to Change_Acting as a Champion for Change
  • Adapting and Responding to Change_Adapting to Change
  • Adapting and Responding to Change_Supporting Change
  • Adapting and Responding to Change_Working with Ambiguity
  • Adapting and responding to change_Working with Diverse Populations
  • Coping with Pressures and Setbacks
  • Coping with Pressures and Setbacks_Demonstrating Tenacity and Perseverance
  • Coping with Pressures and Setbacks_Displaying Confidence and Composure
  • Coping with Pressures and Setbacks_Maintaining Work-Life Balance
  • Coping with Pressures and Setbacks_Managing Stress
  • Achieving Personal Work Goals and Objectives
  • Achieving Personal Work Goals and Objectives_Accepting Responsibility
  • Achieving Personal Work Goals and Objectives_Driving Continuous Improvement
  • Achieving Personal Work Goals and Objectives_Driving for Results
  • Achieving Personal Work Goals and Objectives_Pursuing Self-Development

Conditions of Employment

  • Clear criminal and credit record