Data Modeler with Data Vault

2 weeks ago


Cape Town, South Africa PBT Group Full time

We seek a motivated and skilled Data Modeller to join our dynamic team. This role involves designing, developing, and maintaining data models for cloud-based data platforms, primarily on AWS. The Data Modeller will play a critical role in shaping high-quality data structures that drive effective data solutions for business needs.

 

About the Client:
Our client is a leading IT company in the financial services sector, specialising in delivering innovative technology solutions on a global scale. With a strong focus on AWS, the company leverages cutting-edge cloud technologies to provide scalable, secure, and efficient data-driven solutions.

 

Key Responsibilities:

  • Data Modelling and Standards:
    • Apply data modelling and design standards, tools, and best practices.
    • Collaborate closely with data architects to design customised databases using conceptual and logical models.
    • Develop conceptual, logical, and physical data models; implement RDBMS, operational data stores (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).
    • Ensure data models align with business requirements and architecture frameworks.
    • Utilise approved tools to create high-quality data modelling deliverables.
    • Maintain the Enterprise Logical Data Model as a standard to streamline data modelling efforts.
    • Oversee modelling activities to ensure consistency with the Enterprise Data Model (EDM).
  • Data Analysis and Mapping:
    • Collaborate with team members to translate business requirements into data requirements.
    • Profile source data to assess data quality, relationships, patterns, and rules.
    • Structure data requirements based on the Enterprise Data Model, including ERD and dimensional models.
    • Identify definitive data sources, analyse data quality, and address gaps.
    • Generate physical data models to enable efficient data structure implementation.
  • Data Flow and Standards Compliance:
    • Document data flows across systems and interfaces to facilitate data flow understanding.
    • Implement standards for document naming, security, and data lifecycle management.
    • Identify opportunities for data-driven improvements in business processes.

 

Behavioural Competencies:

  • Stakeholder Engagement: Collaboration, influencing, and effective communication.
  • Decision Making: Analytical mindset and strong problem-solving skills.
  • Action-Oriented: Results-focused, deadline-driven, with a commitment to excellence.
  • Intellectual Curiosity: Continuous learning, adaptability, and innovation.
  • Analytical Thinking: Meticulous attention to detail and output quality.
  • Team Player: Collaborative, supportive, and a strong communicator.
  • Personal Mastery: Lifelong learning and skill enhancement.

 

Qualifications:

  • Bachelor's degree in IT, Engineering, or Business Analysis-related fields.
  • AWS Certified Cloud Practitioner or similar certification is advantageous.

 

Minimum Requirements:

  • Proficiency in Data Modelling tools such as Sparx Enterprise Architect, Erwin, SAP Power Designer, ER/Studio, or IBM Data Architect.
  • Expertise in Entity Relationship Modelling, Physical Database Design, Data Warehousing, Data Integration, and Data Quality.
  • Strong understanding of Master Data Management, Metadata, and database concepts.
  • Knowledgeable in conceptual, logical, and physical data modelling principles.
  • Familiarity with data models, relational and dimensional modelling, and data normalisation.
  • Broad knowledge of Data Management (DMBOK), SDLC, and IT Architecture.

 

Ideal Experience and Skills:

  • Experience with Canonical Data Modelling.
  • Background in banking or financial services environments.
  • Familiarity with BI tools and database optimisation.
  • Strong ability to communicate complex technical ideas to varied audiences.
  • Experience with semi-structured databases is a plus.

 

Experience:

  • Minimum of 7+ years of relevant data modelling experience.

 

This role offers an exciting opportunity for a skilled Data Modeller to drive impactful data solutions within a leading financial services IT team.



  • Cape Town, South Africa PBT Group Full time

    We seek a motivated and skilled Data Modeller to join our dynamic team. This role involves designing, developing, and maintaining data models for cloud-based data platforms, primarily on AWS. The Data Modeller will play a critical role in shaping high-quality data structures that drive effective data solutions for business needs. **About the Client**: Our...


  • Cape Town, South Africa PBT Group Full time

    We seek a motivated and skilled Data Modeller to join our dynamic team. This role involves designing, developing, and maintaining data models for cloud-based data platforms, primarily on AWS. The Data Modeller will play a critical role in shaping high-quality data structures that drive effective data solutions for business needs. About the Client:Our client...


  • Cape Town City Centre, South Africa Jobted ZA C2 Full time

    We seek a motivated and skilled Data Modeller to join our dynamic team. This role involves designing, developing, and maintaining data models for cloud-based data platforms, primarily on AWS. The Data Modeller will play a critical role in shaping high-quality data structures that drive effective data solutions for business needs. About the Client: Our...

  • Data Modeler

    2 months ago


    Cape Town, South Africa PBT Group Full time

    A Senior Data Modeler at PBT Group is responsible for designing and implementing data models that effectively capture, integrate, and display corporate data. The role involves working closely with key stakeholders to translate business requirements into robust scalable data architectures to support business intelligence and data warehousing...

  • Data Modeler

    4 months ago


    Cape Town, South Africa PBT Group Full time

    A Senior Data Modeler at PBT Group is responsible for designing and implementing data models that effectively capture, integrate, and display corporate data. The role involves working closely with key stakeholders to translate business requirements into robust scalable data architectures to support business intelligence and data warehousing...

  • Data Modeler

    2 months ago


    Cape Town, South Africa PBT Group Full time

    A Senior Data Modeler at PBT Group is responsible for designing and implementing data models that effectively capture, integrate, and display corporate data. The role involves working closely with key stakeholders to translate business requirements into robust scalable data architectures to support business intelligence and data warehousing...

  • Data Modeler

    2 months ago


    Cape Town, South Africa PBT Group Full time

    A Senior Data Modeler at PBT Group is responsible for designing and implementing data models that effectively capture, integrate, and display corporate data. The role involves working closely with key stakeholders to translate business requirements into robust scalable data architectures to support business intelligence and data warehousing solutions.  ...

  • Data Modeler

    1 month ago


    Cape Town, South Africa PBT Group Full time

    We seek a motivated and skilled Data Modeller to join our dynamic team. This role involves designing, developing, and maintaining data models for cloud-based data platforms, primarily on AWS. The Data Modeller will play a critical role in shaping high-quality data structures that drive effective data solutions for business needs. About the Client:Our client...

  • Data Modeler

    7 months ago


    Cape Town, South Africa PBT Group Full time

    PBT Group has an opportunity for a Data Modeler to provide expertise, advice and support by designing and developing logical and physical data models and databases to meet the needs of the organisations information systems and business requirements. The Data Modeller is responsible for data standards and procedures, warehousing, distributed data management...

  • Data Engineer

    7 months ago


    Cape Town, South Africa Dimension Data Full time

    As a Data Engineer, you'll design and build the data architecture of our products. You will use your technical knowledge to help us develop new products by taking an idea from concept to reality. You'll work on projects across multiple teams in order to achieve company goals and objectives. Your role will involve: - Analyzing business requirements; -...


  • Cape Town, Western Cape, South Africa PBT Group Full time

    Job Overview:PBT Group is seeking a highly skilled Data Modelling Specialist to lead our data modelling efforts. As a key member of our team, you will be responsible for designing and developing high-quality data models that drive effective data solutions for business needs.About PBT Group:We are a leading IT company specialising in delivering innovative...


  • Cape Town, South Africa Datonomy Solutions Full time

    We are looking for a Data Analytics Engineer, to join our team based in Cape Town(on-site).Main Responsibilities:Define a structured approach to problem solving and delivery against it.Create role specific design standards, patterns, and principles.Assist and advise the planning and management of the workload of the team.Taking a lead in analytical and...

  • Senior Data Modeller

    6 months ago


    Cape Town, South Africa IQbusiness South Africa Full time

    IQbusiness is seeking to appoint a senior data modeller, based in either Cape Town or Johannesburg, to design, implement and maintain data models that meet the business' needs ensure the integrity, accessibility and efficiency of our client's data assets. **Role overview**: - A data modeler is a systems engineer who organises raw data to make it easier to...

  • Data Modelling Expert

    1 month ago


    Cape Town, Western Cape, South Africa PBT Group Full time

    About PBT GroupPBT Group is a leading IT company in the financial services sector, specialising in delivering innovative technology solutions on a global scale.Job SummaryWe are seeking an experienced Data Modeler to join our dynamic team. This role involves designing, developing, and maintaining high-quality data models for cloud-based data platforms,...


  • Cape Town, South Africa Excellenta Full time

    **Key Responsibilities**: - **Oracle Audit Vault Management**: - Design, implement, and maintain Oracle Vault solutions to secure sensitive data. - Develop and enforce policies for database encryption, user access, and data masking within Oracle Vault. - Monitor and audit Oracle Vault activities to ensure compliance with security policies and standards. -...

  • Data Architect

    4 weeks ago


    Cape Town, Western Cape, South Africa Dimension Data Full time

    Are you a skilled Data Engineer looking to take your career to the next level?We're seeking an experienced Data Architect to join our team at Dimension Data!About the Role:We're looking for a highly skilled Data Architect to design and build the data architecture of our products. As a key member of our team, you will use your technical knowledge to help us...


  • Cape Town, Western Cape, South Africa Dimension Data Full time

    Responsibilities and ExpectationsAs a key member of our team at Dimension Data, the successful candidate for the Intermediate BI Developer position will be responsible for developing and maintaining daily, weekly and monthly MIS reports as well as data flows. Duties will include supporting clients with regard to ad-hoc reports and queries, as well as...


  • Cape Town, South Africa Datonomy Solutions Full time

    We are looking for a Data Analytics Engineer, to join our team based in Cape Town(on-site).Main Responsibilities:Define a structured approach to problem solving and delivery against it.Create role specific design standards, patterns, and principles.Assist and advise the planning and management of the workload of the team.Taking a lead in analytical and...


  • Cape Town, South Africa Datonomy Solutions Full time

    We are looking for a Data Analytics Engineer, to join our team based in Cape Town(on-site). Main Responsibilities: Define a structured approach to problem solving and delivery against it. Create role specific design standards, patterns, and principles. Assist and advise the planning and management of the workload of the team. Taking a lead in analytical and...

  • Data Modelling Expert

    3 weeks ago


    Cape Town, Western Cape, South Africa Network Recruitment Full time

    Job & Company OverviewNetwork Recruitment is seeking a highly skilled Data Modelling Expert to join our team. This role offers a competitive salary of $85,000 - $110,000 per annum, depending on experience.About the RoleWe are looking for an experienced professional with expertise in statistical tools and programming languages (R, Python, SAS, SPSS) to...