Type your keywords in the search box above

Advertisement

Data Modeler

Advertisement

Job Description: 

About the Role:

  • Create and implement comprehensive conceptual logical and physical data models.
  • Perform detailed data analysis to develop the data warehouse’s / BI solution’s data model.
  • Participate in the business requirements definition activities in a secondary role, for which a good understanding of business rules is essential.
  • Review models designed by other DBA’s and related the activities of other modelling efforts to the model under review.
  • Model and understand the overall business architecture.
  • Translate this business architecture to a conceptual data model.
  • Structure of the enterprise data model so that it aligns with and enables the operational and analytics capabilities.
  • This person must be able to market or sell the EDM to obtain buy-in and support from all levels within the organisation.

About you:

  • Knowledge about existing corporate data models, as well as knowledge of the business, is extremely important.
  • Strong conventional (normalised) data modelling skills are beneficial, as the Data Modeler often must 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, multi-dimensional models, data vault models, big data models etc.
  • Experience in other enterprise data modelling initiatives
  • Understand the data requirements of front-end (reporting, dashboarding and analysis tools.)
  • Ideally have data architecture experience
  • Data warehouse design methodology training.
  • Normalised and dimensional data modelling training.
  • Must have worked with industry-standard data modelling tools.
  • Strong experience working with a range of DBMS’s.
  • Strong experience with SQL query and DBMS tuning.

 

Location: 

Cape Town, South Africa,

Company: 

PBT Group

Education: 

No education

Job Category: 

Information Technology (IT),Insurance,Retail

Working Experience: 

7 to 20 years

Contract Type: 

Full Time

Salary: 

Negotiable

Salary Frequency: 

Monthly

Job Reference #: 

4088763356

Advertisement

Latest Articles

If you're in a customer-facing role, you will often have to deal with people who are aggressive, abusive, unreasonable or even reasonable or

We are going to walk you through what to do before, during, and after the phone interview to make sure that you get through to the next phase of

Have you heard the term blockchain and crypto currencies used around lately and now you're wondering what are these?.

If you pay any form of remuneration to employees you are required by law to register for pay as you earn (PAYE). 

A reference refers to a former manager or supervisor that speaks about your work experience, working habits, character and skills.

Advertisement