Data Modeler

Data Modeler required for a vacancy at PBT Group.

Duties:

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

Required Skills:

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