BI Data Modeller

4 days ago

Johannesburg, South Africa PBT Group Full time

The primary technology used is IDA (Infosphere Data Architect (Data Modelling Tool)) and Aginity Workbench DB2.

It will also be most beneficial to have knowledge of IGC (Infosphere Governance Catalogue).

**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
- 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 including the appropriate Transformation Rules
- Identifying definitive or authoritative source of data; analysing source data; and identifying gaps to target structures
- 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.
- Assists to provide a comprehensive governed framework by working with the data modelling CoE and contributing towards defining the data modelling standards.
- Ensure consistency and re-use of data models by acting as a primary advocate of date modelling activities and methodologies and by driving the adoption of enterprise data modelling across the bank.
- Ensure improved performance by providing feedback on improvements to the data modelling framework.
- Perform review on work performed by team members as well as review and govern work performed by other modelling teams
- Identify opportunities to improve or enhance processes.
- Provide Overall Data Management Guidance and alignment to the Data Management framework and standards
- Seek opportunities to improve business processes, models and systems though agile thinking.
- Support the achievement of the business strategy, objectives and values
- Participate and support corporate responsibility initiatives for the achievement of business strategy

Skills & Experience Required:

- 5 - 8 years IT related experience with 5yrs+ in a Data Modelling role
- Able to demonstrate practical experience in relational and dimensional modelling techniques as well as leading teams of data modellers
- Experience using Infosphere Data Architect or any other Data Modelling Tool
- Has demonstratable experience in developing custom data models as well as data modelling utilising Industry data models such as IFW BFMDW
- Experience in model management
- Experience in compiling and monitoring standards and developing/maturing a data modelling practice
- OO modelling experience also an advantage
- Experience using Infosphere Data Architect or any other Data Modelling Tool
- Firm understanding of Data Management (DMBOK), systems development lifecycle methodologies and IT Architecture
- Relevant regulatory knowledge, and understanding of banking and financial services
- Experience in NoSQL and other forms of database modelling advantageous

Advanced knowledge of:

- Industry Model Understanding
- Pattern Recognition, conceptual and abstract thinking
- Presenting
- Problem solving and creativity
- Language skills
- Data analysis and inference
- Data Integrity
- Data Modelling
- Data Warehouse Layers
- Metadata
- Data Quality
- Data Warehousing Overview and Architecture
- Database Model Concepts
- Data and business requirements Gathering
- Data Modelling Tools

Intermediate knowledge of:

- Using SQL in Databases
- Agile Concepts
- Banking Product Knowledge

Basic knowledge of:

- Data Governance
- Data Architecture Management
- Data Integration
- DevOps Tooling and methodologies
- Master and Reference Data Management

Qualifications/ Certification:

- Advanced Diplomas/National 1st Degrees/equivalent NQF level 6 qualification
- Bachelor of Commerce, Bachelor of Science: Information Systems / Computer Science Honours level
- TOGAF, DAMA

  • Data Modeler

    2 days ago

    Johannesburg, South Africa iCore Full time

    Looking for a Data Modeler at one of our client locations Johannesburg Qualifications: Minimum of 4-year tertiary qualification in Engineering, Data Sciences, Computer Science, or IT Experience working with conventional relational database management systems and new Big Data Platforms and Systems. - Understanding of entity-relationship modeling...

  • Data Modelling Expert

    2 weeks ago

    Johannesburg, Gauteng, South Africa E-Merge Full time

    E-Merge is seeking a highly skilled Senior Information Support Analyst for its team in JohannesburgAbout the Role:The ideal candidate will have a strong background in data modelling, dashboard creation and business intelligence solutions.Data Modelling: Translate business needs to technical specifications and design, build and deploy BI solutions (e.g., data...

  • Power BI

    2 months ago

    Johannesburg, South Africa Jobted ZA C2 Full time

    Overview Hire Resolve’s client is looking for a talented and experienced Power BI / Data Analyst to join their data analytics team in Johannesburg, GP. In this role, you will be responsible for designing, developing, and maintaining interactive Power BI dashboards and reports to provide valuable business insights to our stakeholders. You will work closely...

  • Data Modeller Ftc

    7 months ago

    Johannesburg, South Africa Tych Business Solutions Full time

    **Job ID**: 84382**Date Posted**: Posted 6 hours ago**Location**: Johannesburg**Job Title**: DATA MODELLER FTC - JOHANNESBURG - GAUTENG - Manage the creation of data models in a structured data format to enable analysis thereof - Develop and design scalable extract, transform and loading (ETL) packages from the business source systems and the development of...

  • Data Modeller

    7 months ago

    Johannesburg, South Africa NTT Full time

    NTT is a leading global IT solutions and services organisation that brings together people, data and things to create a better and more sustainable future. In today’s ‘iNTTerconnected’ world, connections matter more now than ever. By bringing together talented people, world-class technology partners and emerging innovators, we help our clients solve...

  • BI Data Analyst I

    1 day ago

    Johannesburg, South Africa Nedbank Full time

    **Job ID** 116717 **Job Family** Information Technology **Career Stream** It Application Development **Job Purpose** Create and Maintain the Principles, Standards, Policies and Procedures for BI and works closely with all BI teams across the enterprise to ensure compliance. Explore and recommend emerging technologies, framework, methods to...

  • BI Data Architect

    5 days ago

    Johannesburg, South Africa Psybergate Full time

    **What you will be doing**: - Strong attention to detail and ability to work with a variety of clients including executive and operational - Communicate and collaborate with teams to action requirements and deliver the required Data solutions - Interact with systems analysts, architects, developers and development managers to understand source structures...

  • Intermediate Bi

    4 days ago

    Johannesburg, South Africa Asource Recruitment Full time

    **Intermediate BI Developer x 2** Remote Johannesburg x 1 /Cape Town x 1 Permanent R500k R700k As part of a growing team, we need experienced Intermediate BI Developers to join us on a journey to Understand, Design and Build the FDLC (Full Development Lifecycle) of the client BI Solutions. This role will not only enable you to collaborate with the best...

  • BI Analyst

    7 months ago

    Johannesburg, South Africa CyberPro Consulting Full time

    **Job Title: BI Business Analyst** **Location**: Johannesburg, South Africa **Position Overview**: **Key Responsibilities**: - **Requirement Gathering**: Collaborate with stakeholders to gather, analyze, and document business requirements related to BI solutions. - **Data Analysis**: Perform in-depth data analysis to identify trends, patterns, and...

  • BI Developer

    2 months ago

    Johannesburg, South Africa Network Recruitment Full time

    Key Responsibilities:BI Solutions Development: Design, develop, and implement scalable and efficient BI solutions using a variety of data tools and technologies.Data Integration & ETL: Develop and manage ETL processes to integrate data from multiple sources into a unified data warehouse.Reporting & Dashboards: Create meaningful and visually appealing reports...

  • BI Developer

    2 months ago

    Johannesburg, South Africa Network Recruitment Full time

    Key Responsibilities: BI Solutions Development: Design, develop, and implement scalable and efficient BI solutions using a variety of data tools and technologies. Data Integration & ETL: Develop and manage ETL processes to integrate data from multiple sources into a unified data warehouse. Reporting & Dashboards: Create meaningful and visually appealing...

  • BI Solutions Architect

    7 months ago

    Johannesburg, South Africa PBT Group Full time

    PBT Group has an opportunity for a BI Solutions Architect responsible for conceptualizing, designing, implementing, and supporting BI solutions. **Duties**: - Understanding the entire BI landscape to ensure sustainable implementation. - Interacting with business analysts and end-users to establish information needs. - Conducting data analysis and profiling...

  • BI Developer

    4 weeks ago

    Johannesburg, South Africa Jobted ZA C2 Full time

    KPA's: - Leverage organizational and external data to provide insights through reports and interactive BI applications. - Design, develop, and maintain visually appealing, user-friendly BI solutions using Qlik and SQL. - Collaborate with stakeholders to understand data needs and translate them into effective dashboards and visualizations. - Perform...

  • BI Data Analyst

    4 months ago

    Johannesburg, South Africa Nedbank Full time

    **Job Requisition and Talent Acquisition contact** - Role: BI Data Analyst- REQ: 136006- Talent Acquisition consultant: Lebohang Monate- Advert closing date: 26/09/2024**Job Family** - Information Technology **Career Stream** - It Application Development **Leadership Pipeline** - Manage Self: Technical **Job Purpose** - To ensure the support and maintain...

  • Power BI Consultant

    7 months ago

    Johannesburg, South Africa RecruiTech Full time

    Our client is seeking a highly skilled and experienced professional to join their team as a Power BI Developer. **Responsibilities** - Know and understand how and when to recommend the Power BI platform - Plan and implement Power BI connections to data sources - Create views and aggregate data sets within data warehouses - Data Sourcing, including data...

  • Power BI Specialist

    1 month ago

    Johannesburg, South Africa Hire Resolve Full time

    Hire Resolve's client is looking for a highly skilled Power BI Specialist to join their team in Johannesburg, GP. The ideal candidate will have strong experience in building and maintaining complex Power BI reports and dashboards. The candidate will work closely with various departments to gather requirements, design data models, and create interactive...

  • BI Analyst

    4 days ago

    Johannesburg, South Africa Stafflink Recruitment Solutions Full time

    **Qualification**: Matric/Grade 12 or Educated to A-Level or equivalent essential BS or MS in computer science or information systems along with minimum of 3 years work experience in a related field. **Experience**: Minimum of 3 years of experience in data visualization and analytics, working with businesses to shape and implement their BI strategies,...

  • Power BI Specialist

    1 month ago

    Johannesburg, South Africa Jobted ZA C2 Full time

    Overview Hire Resolve’s client is looking for a highly skilled Power BI Specialist to join their team in Johannesburg, GP. The ideal candidate will have strong experience in building and maintaining complex Power BI reports and dashboards. The candidate will work closely with various departments to gather requirements, design data models, and create...

  • BI Developer

    4 weeks ago

    Johannesburg, South Africa Network Recruitment Full time

    KPA's:Leverage organizational and external data to provide insights through reports and interactive BI applications.Design, develop, and maintain visually appealing, user-friendly BI solutions using Qlik and SQL.Collaborate with stakeholders to understand data needs and translate them into effective dashboards and visualizations.Perform scripting, data...

  • BI Developer

    4 weeks ago

    Johannesburg, South Africa Network Recruitment Full time

    KPA's: Leverage organizational and external data to provide insights through reports and interactive BI applications. Design, develop, and maintain visually appealing, user-friendly BI solutions using Qlik and SQL. Collaborate with stakeholders to understand data needs and translate them into effective dashboards and visualizations. Perform scripting, data...