Data Modeler

Recruiter:

PBT Group

Job Ref:

357815238

Date posted:

Thursday, June 2, 2022

Location:

Cape Town, South Africa

SUMMARY:
-

JOB DESCRIPTION:

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.

NB! This job is now closed. You can apply for other jobs by uploading your CV.

Similar jobs you might be interested in:

Data Specialist / Data Engineer / Data Analyst (Junior / Intermediate / Senior)
Location: Cape Town
Salary:
Make 2026 the year you take control of your career! If data is your passion—whether you’re starting out or a seasoned expert—my clients are always looking for talent like you. Opportunities across industries, tech stacks, and work setups are waiting.
2 days ago

Data Analyst
Location: Cape Town
Salary: 550000
data Analyst needed in CPT!
2 days ago

Data Systems Engineer
Location: Cape Town
Salary:
In the heart of the world's most dynamic Carnival, every float, every dancer, every burst of confetti is a piece of moving data. Our client is seeking the architect of this spectacle—a data Systems Engineer who doesn't just build pipelines, but composes the very rhythm that drives the celebration. You will design the stage and orchestrate the flow, ensuring that every stream of data moves wi...
5 days ago

Senior Data Engineer
Location: Cape Town
Salary:
5 days ago

Data Analyst
Location: Cape Town
Salary:
The Centre for Child and Adolescent Lung Health (CHILD) at the UCT Lung Institute is recruiting a data Analyst for the Drakenstein Child Health Study (DCHS) for a full-time 12-month contract post, with the possibility of renewal. The incumbent will be based at Red Cross War Memorial Children’s Hospital and will be responsible for preparing, analysing and reporting on data related to the prim...
6 days ago

Data Analyst
Location: Cape Town
Salary: 550000
data Analyst needed in CPT!
10 days ago

Data Capturer (Remote)
Location: Woodstock
Salary:
Our client, a reputable company based in Woodstock, Cape Town, is seeking a dedicated data Capturer to join their team. This is a remote position, ideal for someone who is detail-oriented, highly organized, and confident working independently. The successful candidate must meet the following requirements: a reliable home internet connection, Matric/Grade 12, strong data-capturing accuracy, excelle...
2 days ago

DATA REPORTING ANALYST & ADMIN OFFICER - Durbanville, Western Cape 6 MONTH CONTRACT
Location: Durbanville
Salary: R25k - 35k per month
Our Client, an established Waste Management firm is in search of results orientated, task driven, re
13 days ago

Data Systems Engineer
Location: Cape Town
Salary: 700 000 Annually
Well, what do we have here? Someone who’s spent 5+ years charming pipelines, coaxing APIs, and taming misbehaving databases. If that’s you, congratulations—you might be the kind of audacious problem-solver my client wants on their team.Your skills are about to meet their grandest challenge yet.
14 days ago

Data Scientist
Location: Stellenbosch
Salary: 1 200 000 Annually
data is king—and businesses know it. If you’re passionate about turning data into insights, building scalable solutions, and working with cutting-edge tech, we’ve got opportunities that will excite you.
14 days ago

Data Modeler

Similar jobs you might be interested in:

Create a free job alert for Data Modeler in Cape Town

Jobseekers

Recruiter

General