BI Data Modeller

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

  • Power BI Data Analyst

    10 hours ago

    Johannesburg, Gauteng, South Africa Recru-it Full time

    Our client is seeking a skilled and experienced Power BI Data Analyst to join their team. The successful candidate will be responsible for developing and managing business intelligence solutions using Microsoft Power BI. This role involves working closely with stakeholders to understand their data needs, developing dashboards and reports, and ensuring data...

  • Data Lead, Data Architect

    2 weeks ago

    Johannesburg, South Africa PBT Group Full time

    PBT Group has an urgent opportunity for a Data Lead, Data Architect & Data Modeller. **Duties**: - Main responsibilities - Data Architecture & Data Modelling - Create and implement comprehensive logical and physical data models. - Perform detailed data analysis in order to develop the data warehouse’s / BI solution’s data model. - Involved in the...

  • BI Data Analyst

    2 weeks ago

    Johannesburg North, South Africa ClarkHouse Human Capital Full time

    Gauteng, Johannesburg North Our client is looking to onboard an entry level BI Data Analyst on a 3 month contract. Relevant Qualification. Focus on building dashboards. Experienced with mainly PowerBI for building dashboards as well as using R and/or python for initial data analysis as well as model building. - For more information please contact: -...

  • BI Data Architect

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

  • BI Developer

    2 days ago

    Johannesburg, Gauteng, South Africa Recru-it Full time

    Our client is seeking a skilled and experienced Power BI Developer to join their team. The successful candidate will be responsible for designing, developing, and maintaining business intelligence solutions using Microsoft Power BI. This role involves working closely with stakeholders to understand their data needs, developing dashboards and reports and...

  • BI Developer

    2 weeks ago

    Johannesburg, Gauteng, South Africa Network Recruitment Full time

    Qualifications:Relevant BI / data warehousing technologiesBachelors Degree in Computer Science / IT or a related fieldMasters Degree is preferred MatricRequirements:4 to 5 years' experience in a BI development role with a strong focus on data modelling ETL development and report / dashboard creationSQLData modelling tools such as ERWin / ErStudio as well as...

  • BI Developer

    3 days ago

    Johannesburg, Gauteng, South Africa Network Recruitment Full time

    Qualifications: Relevant BI / data warehousing technologies Bachelors Degree in Computer Science / IT or a related field Masters Degree is preferred Matric Requirements: 4 to 5 years' experience in a BI development role with a strong focus on data modelling ETL development and report / dashboard creation SQL Data modelling tools such as ERWin / ErStudio...

  • BI Analyst

    2 weeks 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 Specialist

    2 weeks ago

    Johannesburg, Gauteng, South Africa Network Recruitment Full time

    Key ResponsibilitiesDesign, develop, and maintain BI solutions using [Specify Tech Stack e.g., SQL, Power BI, Tableau, SSIS, SSRS, SSAS]Build interactive dashboards, reports, and data models to support business strategyCollaborate with stakeholders to understand data needs and provide actionable insightsEnsure data accuracy, integrity, and governance across...

  • BI Specialist

    2 days ago

    Johannesburg, Gauteng, South Africa Network Recruitment Full time

    Key Responsibilities Design, develop, and maintain BI solutions using (Specify Tech Stack e.g., SQL, Power BI, Tableau, SSIS, SSRS, SSAS) Build interactive dashboards, reports, and data models to support business strategy Collaborate with stakeholders to understand data needs and provide actionable insights Ensure data accuracy, integrity, and governance...

  • BI Developer

    4 weeks ago

    Johannesburg, Gauteng, South Africa Staff Unlimited Recruitment Pty Ltd TA MPC Recruitment Group EC Full time

    Our client is seeking a BI Developer to join their team, based in Johannesburg.Successful candidate will be responsible for end to end BI development, support, monitoring, analysis and maintenance within the BI and Data Warehouse environment/s, as well as general BI functions to assist the BI team in day-to-day operations and ad-hoc tasks when...

  • BI Developer

    2 weeks ago

    Johannesburg, Gauteng, South Africa Staff Unlimited Recruitment Pty Ltd TA MPC Recruitment Group EC Full time

    Our client is seeking a BI Developer to join their team, based in Johannesburg.Successful candidate will be responsible for end to end BI development, support, monitoring, analysis and maintenance within the BI and Data Warehouse environment/s, as well as general BI functions to assist the BI team in day-to-day operations and ad-hoc tasks when...

  • BI Analyst

    3 weeks ago

    Johannesburg North, South Africa Communicate Recruitment Full time

    An exciting opportunity for a Business Intelligence (BI) Developer in the Insurance industry! Are you a talented and driven Business Intelligence Developer looking for a new challenge in a dynamic and innovative environment? We have an exceptional opportunity for a skilled individual to join a renowned organization in a BI Developer role. This is your...

  • BI Developer

    2 weeks ago

    Johannesburg, Gauteng, South Africa Network Recruitment Full time

    Qualifications:Relevant BI / Data warehousing technologiesBachelors degree in Computer Science / IT or related fieldMasters degree is preferred Matric Requirements:4 to 5 years experience in a BI Development role with a strong focus on data modelling ETL Development and report / dashboard creationSQLData modelling tools such as ERWin / ErStudio as well as...

  • BI Solutions Architect

    2 weeks 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...

  • Power BI Specialist

    2 weeks ago

    Johannesburg, South Africa Whizants Full time

    **Role**: Power BI Specialist) **Rate**: Negotiable **Industry**: Banking **Purpose**:The resource would need to update current data with new content, visualize the data, and be able to show financial data to indicate financial status. **Minimum Requirements**: - Proven experience in working with Power BI data modelling - Knowledge and experience of...

  • BI Developer

    4 weeks ago

    Johannesburg, South Africa Staff Unlimited Recruitment Pty Ltd TA MPC Recruitment Group EC Full time

    Our client is seeking a BI Developer to join their team, based in Johannesburg. Successful candidate will be responsible for end to end BI development, support, monitoring, analysis and maintenance within the BI and Data Warehouse environment/s, as well as general BI functions to assist the BI team in day-to-day operations and ad-hoc tasks when required. ...

  • BI Developer

    4 weeks ago

    Johannesburg, South Africa Staff Unlimited Recruitment Pty Ltd TA MPC Recruitment Group EC Full time

    Our client is seeking a BI Developer to join their team, based in Johannesburg.Successful candidate will be responsible for end to end BI development, support, monitoring, analysis and maintenance within the BI and Data Warehouse environment/s, as well as general BI functions to assist the BI team in day-to-day operations and ad-hoc tasks when...

  • BI Specialist

    3 weeks ago

    Johannesburg, South Africa Goldman Tech Resourcing Full time

    **Job Information** - Location- Johannesburg- Salary- R400 000 - R600 000 p/a- Job Type- Permanent- Education- Degree/Diploma- Experience- 5+ years- Reference- BI2021- - it.careers(at)goldmantech.co.za- Fax- 0866688041We have an amazing opportunity for a BI Specialist in Johannesburg! - MS BI certification - Degree in IT an advantage - 2+ Years work...

  • BI Developer

    1 week ago

    Johannesburg, Gauteng, South Africa Human Accent Full time

    Our well-established client in the pharmaceutical industry has a vacancy available for a BI Developer based in Parktown.Main Purpose of Job:The BI Developer is responsible for end-to-end BI development, support, monitoring, analysis and maintenance within the BI and Data Warehouse environment/s, as well as general BI functions to assist the BI team in...