Data Architect Lead Full Time Permanent

Data Architect Lead – Johannesburg

A Data Architect Lead position is available in Johannesburg, Gauteng, South Africa.

PBT Group has an urgent opportunity for a Data Lead, Data Architect & Data Modeller in Johannesburg, South Africa.

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 system.
• Collaborate with Developers to ensure that the different parts of a solution are integrated, and appropriate technology choices are made.
• Coordinate and conduct the delivery of high-level complex solutions.

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 architecture.
• Experience in data warehouse / BI solution performance analysis, tuning and administration is required.
• A solid background in SQL, information architecture and ETL procedures is required.
• Relevant data warehouse architecture and infrastructure training is essential.
• 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.

Search all available job vacancies in South Africa →