Senior Data Modeller

3 weeks ago

Cape Town, South Africa PBT Group Full time

PBT Group has an opportunity for Data Modellers to design and maintain optimal data models/structures at both an enterprise and system / application level that meet the business and architectural objectives of the organisation.

 

Duties:

  • 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
  • Apply the approved tooling to create the data modelling deliverables.
  • 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
  • Ensure complete and correct data by identifying definitive or authoritative source of data; analysing source data; and identifying gaps
  • 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.

 

Skills Required:

 

Data Management Domain Knowledge:

  • Data Modelling Concepts: Erwin & SAP Sybase Power Designer
  • Canonical Data Modelling
  • Entity Relationship Modelling
  • Physical Database Design
  • Configuration Management
  • Data Flow Management
  • Data warehousing,
  • Data Integration,
  • Data Mining
  • Data Quality
  • Master Data Management
  • Metadata

 

Tools- Technical Skills:

  • IBM Infosphere Information Governance Catalog - Building the Governance Catalog
  • IBM Information Analyzer Essentials v
  • IBM InfoSphere DataStage Essentials
  • IBM InfoSphere Advanced DataStage - Parallel Framework
  • IBM InfoSphere DataStage v - Advanced Data Processing
  • IBM InfoSphere QualityStage Essentials v
  • IBM InfoSphere Advanced QualityStage v
  • Collibra
  • Talend
  • Metadex -(SSIS)
  • Linux
  • SQL

 

Skill package will include knowledge in:

  • APIs, PERL, Python, SQL, XML, Java, C/C++ and others.

 

Understanding of at least some of the newest trends in the DBMS debate like:

  • NoSQL platforms such as Cassandra, MongoDB, Couchbase, Riak, Redis, FlockDB, Stig

 

Cloud Knowledge:

  • AWS, Azure, IBM etc.

 

Experience Required:

  • 3-5 years and/or relevant industry experience as well as experience in the Data Modelling discipline
  • Able to demonstrate practical experience in relational and dimensional modelling techniques, OO modelling also an advantage
  • Experience using Infosphere Data Architect or any other Data Modelling Tool
  • Experience with industry models such as IFW BDW and FSDM
  • Broad understanding of Data Management (DMBOK), systems development lifecycle methodologies and IT Architecture
  • Relevant regulatory knowledge, and understanding of banking and financial services

 

Technical Competencies:

  • Data analysis: Applies data analysis, data modelling, and quality assurance techniques, based upon a detailed understanding of business processes, to establish, modify or maintain data structures and associated components (entity descriptions, relationship descriptions, attribute definitions). Advises database designers and other application development team members on the details of data structures and associated components.
  • Data Modelling: Specialist knowledge of database concepts, object and data modelling techniques and design principles.

 

Behavioural Competencies:

  • Exercises substantial personal responsibility and autonomy. Plans own work to meet given objectives and processes in an efficient manner. Plans, schedules and monitors work to meet time and quality targets.
  • Work includes a broad range of complex technical or professional activities, in a variety of contexts. Investigates, defines and resolves complex issues.
  • Accomplishing tasks by considering all areas involved, no matter how small; showing concern for all aspects of the job; accurately checking processes and tasks; being watchful over a period of time.
  • Makes decisions which influence the success of projects and team objectives.
  • Selects appropriately from applicable standards, methods, tools and applications. Communicates fluently, orally and in writing, and can present complex information to both technical and non-technical audience.
  • Facilitates collaboration between stakeholders who share common objectives.
  • Setting high goals for personal and group accomplishment; using measurement methods to monitor progress toward goals; tenaciously working to meet or exceed goals while deriving satisfaction from that achievement and continuous improvement.
  • Participates in external activities related to data modelling
  • Takes responsibility for driving own development by actively identifying new areas for learning; regularly creating and taking advantage of learning opportunities. Rapidly absorbs new information and applies it effectively.

 

Qualifications/ Certification:

  • A degree/diploma in Computer Science / Information Systems / Business Administration / Commerce or equivalent
  • Preferred Qualifications: TOGAF

 

 

  • Senior Data Modeller

    3 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 Modeler

    1 week 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

    1 week 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

    6 days ago

    Cape Town, South Africa Adzuna ZA B C2 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

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

    7 days 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.  ...

  • Senior Data Modeller

    3 weeks ago

    Cape Town, South Africa PBT Group Full time

    PBT Group has an opportunity for Data Modellers to design and maintain optimal data models/structures at both an enterprise and system / application level that meet the business and architectural objectives of the organisation. Duties:Design data models that meet the business requirements and align to the agreed architecture framework.Ensure data modelling...

  • Senior Data Modeller

    3 weeks ago

    Cape Town, South Africa Adzuna ZA B C2 Full time

    PBT Group has an opportunity for Data Modellers to design and maintain optimal data models/structures at both an enterprise and system / application level that meet the business and architectural objectives of the organisation. Duties:Design data models that meet the business requirements and align to the agreed architecture framework.Ensure data modelling...

  • Senior Data Modeller

    3 weeks ago

    Cape Town, South Africa PBT Group Full time

    PBT Group has an opportunity for Data Modellers to design and maintain optimal data models/structures at both an enterprise and system / application level that meet the business and architectural objectives of the organisation. Duties:Design data models that meet the business requirements and align to the agreed architecture framework.Ensure data modelling...

  • Data Modeler and Analyst

    5 days ago

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

    About the RolePBT Group is seeking a highly skilled Senior Data Modeler to join our team. As a Senior Data Modeler, you will be responsible for designing and implementing data models that effectively capture, integrate, and display corporate data.Key ResponsibilitiesDesign and Implement Data Models: Develop comprehensive logical and physical data models to...

  • Data Modeler

    3 months ago

    Cape Town, South Africa InfoBluePrint Services (Pty) Ltd Full time

    **Job Summary** The Data Modeller will ensure that each model produced adheres to the defined modelling standards. The Data Modeller is also expected to contribute to the Data Model standards, if and where necessary. A Business Glossary will be produced from the Entities and Attributes recorded in the logical data model. **Responsibilities** **General...

  • Data Modeler

    3 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 Modeller

    3 months ago

    Cape Town, South Africa IQbusiness South Africa Full time

    Role overview - A data modeler is a systems engineer who organizes raw data to make it easier to understand and process. The role will help data analysts understand trends, opportunities, and solutions to technical problems. This is will be accomplished through the use of modelling language or specific software. The role will be responsible for ensuring that...

  • Senior Data Architect

    5 days ago

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

    About the RolePBT Group is seeking a highly skilled Senior Data Modeler to join our team. As a Senior Data Modeler, you will be responsible for designing and implementing data models that effectively capture, integrate, and display corporate data.Key ResponsibilitiesData Modeling: Develop comprehensive logical and physical data models to support business...

  • Subject Data Modeller

    3 months ago

    Stellenbosch, Western Cape, South Africa Boardroom Appointments Full time

    **Duties and responsibilities**: - To Understand and translate business requirements into data requirements to enable stakeholders to consume data in the most effective and efficient way. - 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...

  • Data Engineer

    3 days ago

    Cape Town, Western Cape, South Africa IOCO Full time

    About the RoleWe're seeking a highly skilled Data Engineer to join our team at IOCO in Cape Town. As a Data Engineer, you will play a crucial role in modelling data to provide clean, accurate datasets for our team to work with.Key ResponsibilitiesTransform raw data into clean, tested, and reusable datasets, making it easier for analysts and stakeholders to...

  • Data Modeller

    3 months ago

    Cape Town, South Africa Paracon Full time

    One of our clients in the Winelands is looking for a Data Modeller to join their team in CT on a (Permanent) basis. As a Data Modeller you will ideally need experience in supporting as well as implementing data infrastructures, with proven analytical and problem-solving experience in a complex data environment. **Key Responsibilities**: - Data Modelling...

  • Senior Bim Modeler

    3 months ago

    Cape Town, South Africa Assegai Recruitment (Pty) Ltd Full time

    Top consulting firm is seeking a Senior BIM Modeler (Mechanical) to join their team in the Cape Town office. **Requirements**: - BIM industry experience as a Mechanical BIM Technician / Modeler - Awareness of mechanical design principles, industry standards and competency with drawing air and fluid side plans and schematics - In coordinating MEPF services...

  • Senior Data Scientist

    3 months ago

    Cape Town, South Africa Tier 1 Full time

    overview An international Data Analytics company based in South Africa is looking for Senior Data Scientist to join their team.Our client is looking for a Senior Data Scientist who will collaborate across the various teams in the solution designing in credit and non-credit industries, as well as development and deployment of solutions. description -...

  • Senior Data Scientist

    3 months ago

    Cape Town, South Africa Talent Acquisition Group Full time

    **Role**: Senior Data Scientist **Location**: Century City, Western Cape **Salary**:R90 000 - R100 000pm **Hybrid**: 1-3 Days **Exciting Opportunity: Senior Data Scientist with a Leading Data Analytics Firm** We're delighted to bring you a unique opportunity in partnership with a leading international data analytics company. They're at the forefront of...