Data Lead, Data Architect

1 week 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 requirements definition process.
- Assist the ETL Analysts / Business Analysts with the specification of the source to target mappings.
- Participate in the business requirements definition activities in a secondary role, for which a good understanding of business rules is essential.
- Work closely with Business Analysts, ETL Analysts, Solution Architects and Database Administrators to perform all tasks.
- Review models designed by other DBA’s and relate the activities of other modeling efforts to the model under review.
- Responsible for the technical design of the data warehouse and BI Solution, including the technical infrastructure, performance considerations, storage repository selections and organisation, data schemas and security constraints required to support the data warehouse
- Collaborate with Developers to ensure that the different parts of a solution are integrated, and appropriate technology choices are
- Coordinate and conduct the delivery of high-level complex

Skills & Experience:

- Main technologies / experience
- Using Data modelling tools, e.g., Erwin
- Experience in designing and implementing Data Architecture, and related components
- SQL
- Cloud exposure - preferable but not essential. AWS will be beneficial.
- Knowledge of and experience with the systems components making up the entire Business Intelligence system
- Experience in data warehouse / BI solution performance analysis, tuning and administration is
- A solid background in SQL, information architecture and ETL procedures is
- Relevant data warehouse architecture and infrastructure training is
- Knowledge about existing corporate data models, as well as knowledge of the business, is extremely important.
- Strong conventional (normalised) data modeling skills are beneficial, as the Data Modeler often has to be able to read and understand existing data models. However, the Data Modeler should be able to break away from traditional OLTP and E/R design practices and embrace the new data warehouse design techniques such as Dimensional models or multi-dimensional models.
- Experience working on other data warehousing projects is essential (full life cycle).
- Understanding of data warehousing and data mart architectures.
- An exposure to end-user reporting tools and their capabilities is useful.
- Have a quick grasp and understanding of data models, be able to see things abstractly, for example to derive the common model and represent related business concepts generically.
- Be very meticulous, as the data warehouse data model should be exact and complete - attention to detail is a very important characteristic.
- Well versed in conceptual and logical data modeling.
- Understand advanced analytical data requirements.
- Understand the data requirements of front-end (reporting, dashboarding and analysis tools.)

Required Qualifications / Training:

- Data warehouse design methodology training.
- Normalised and dimensional data modeling training.
- Must have worked with industry standard data modeling tools.
- Strong experience working with a range of DBMS’s.
- Strong experience with SQL query and DBMS tuning.
- B.Sc. or related degree is advantageous.

  • 2022 25 Data Architect

    3 days ago

    Johannesburg, South Africa Data Centrix Full time

    **Role purpose**: The data architect will be responsible for building, optimizing, and maintaining conceptual and logical data models to ingest and curate data from source systems into an Azure data lake. The models must comply with the governance and requirements of the Central Data Platform. The architect will have a key role to interface with business...

  • Senior Data Centre Technical Architect

    1 day ago

    Johannesburg, South Africa NTT DATA Full time

    **Make an impact with NTT DATA** Join a company that is pushing the boundaries of what is possible. We are renowned for our technical excellence and leading innovations, and for making a difference to our clients and society. Our workplace embraces diversity and inclusion - it’s a place where you can grow, belong and thrive. **Your day at NTT DATA** The...

  • Data & AI Pre-Sales Lead

    6 days ago

    Johannesburg, South Africa Data Centrix Full time

    A leading IT solutions provider in Johannesburg is seeking an experienced Data/AI Pre-Sales Specialist. The role involves engaging with customers to deliver product overviews and technical discussions, leading pre-sales engagements, and mentoring junior team members. Candidates should have over 5 years of experience in a similar role, strong understanding of...

  • Data Scientist

    5 days ago

    Johannesburg, South Africa NTT DATA Full time

    **Make an impact with NTT DATA** Join a company that is pushing the boundaries of what is possible. We are renowned for our technical excellence and leading innovations, and for making a difference to our clients and society. Our workplace embraces diversity and inclusion - it’s a place where you can grow, belong and thrive. **Your day at NTT DATA** The...

  • SAP Analytics Cloud Architect

    1 day ago

    Johannesburg, South Africa NTT DATA Full time

    **Make an impact with NTT DATA** Join a company that is pushing the boundaries of what is possible. We are renowned for our technical excellence and leading innovations, and for making a difference to our clients and society. Our workplace embraces diversity and inclusion - it’s a place where you can grow, belong and thrive. **NTT is a leading global IT...

  • Aws Solutions Architect

    1 week ago

    Johannesburg, South Africa NTT Data Full time

    **Job Requirements **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...

  • Data Architect

    2 weeks ago

    Johannesburg, South Africa Ampstek Full time

    Technical Recruiter @ Ampstek | Hiring Across UK & Europe, Recruiting, HR, Communication Hi Professionals, Greetings From Ampstek!! Hope you are high in your spirits. Please stay safe. Our client is looking for a Data Architect to join a high-growth organization. If you are interested, share your resume with . Role: Data Architect Duration: Contract Job...

  • Data Governance and Privacy Lead

    3 days ago

    Johannesburg, Gauteng, South Africa NTT DATA, Inc. Full time US$80 000 - US$160 000 per year

    Make an impact with NTT DATAJoin a company that is pushing the boundaries of what is possible. We are renowned for our technical excellence and leading innovations, and for making a difference to our clients and society. Our workplace embraces diversity and inclusion – it's a place where you can grow, belong and thrive.Key Responsibilities:Collaborates...

  • Aws Infrastructure Architect

    1 week ago

    Johannesburg, South Africa NTT Data Full time

    **Job Requirements **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...

  • SharePoint Architect

    2 weeks ago

    Johannesburg, South Africa Ntt Data Full time

    A leading technology firm in South Africa is seeking a skilled SharePoint Architect to lead hybrid engagements on project-based work and managed support. The role involves architecting scalable solutions, providing technical leadership, and engaging directly with stakeholders. The ideal candidate should have extensive experience in SharePoint and Power...