Domain Data Modeller at Capitec Bank

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:

• 3 years + experience in the Data Modelling discipline 
• Experience using multiple data modelling tools eg. Sparx Enterprise Architect,Erwin & SAP Power Designer, ER/Studio, IBM data architect
• Experience in supporting as well as implementing data infrastructures
• Proven analytical and problem-solving experience in a complex data environment
• Experience working with relationally modelled data
• Experience working with dimensionally modelled data

Ideal:

• 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)

• Bachelor's Degree in Information Technology - IT Engineering or Information Technology

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

Ideal:

• 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
• Attention to Detail
• Problem solving skills
• Communications Skills
• Decision making skills

Competencies

• Applying Expertise and Technology
• Analysing
• Learning and Researching
• Creating and Innovating
• Delivering Results and Meeting Customer Expectations
• Deciding and Initiating Action
• Adapting and Responding to Change

Additional Information

• Clear criminal and credit record
• Willingness to work or be available overtime and / or weekends if required
• Ability and willingness to work in an open plan environment
• Willingness to travel nationally if and when required
• Willing and able to use own home as a formal office / base of operations (including space for ad hoc storage of paperwork, stock, etc.)