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