Data Warehousing / Data Modeler

Recruiter:

EQ Plus

Job Ref:

GTG006260/LR

Date posted:

Wednesday, June 15, 2022

Location:

Centurion, South Africa

SUMMARY:
Data Warehousing/ Data Modeler required for a project on a 12 months extendable contract.
Need someone with excellent knowledge and exposure to Star Schema (Kimball) Methodologies, who is excellent at the Architecture of designing documentation and with a mind for designing and reverse engineering.

JOB DESCRIPTION:

Main Requirements:

Creating a design from scratch using star schema (Kimball) methodologies
Must have a firm understanding of the grain of a fact and how it affects query joins and performance (snowflaking)
Working with and integrating ambiguous datasets
Conformed Dimensions, Surrogate keys and basic indexing standards, (Columnstore indexing added advantage)
Initial and Delta loading concepts
Architecture design documentation
Able to do data profiling and quick POC’s

Advanced:

Designing with partitioning and archiving in mind
Metadata to track data lineage
Incorporating a Data dictionary
Reverse engineering designs
Performance optimization and future Data / storage growth

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

Similar jobs you might be interested in:

Data Architect
Location: Johannesburg
Salary:
We are recruiting for a data Architect.
11 days ago

Sales Administrator
Location: Centurion
Salary: R 12 000 Monthly
Our client is a well-established medical group of companies in Irene, Centurion. They are looking for a Sales Administrator to join their dynamic team.
10 days ago

Data Engineer (AWS and Redshift) - Johannesburg – up to R1mil
Location: Johannesburg
Salary: 1000000
data Engineer (AWS and Redshift) - Johannesburg – up to R1mil
10 days ago

Business Analyst - Intermediate to Senior - Contract
Location: Sandton
Salary: R500 - 520 per hour
Business Analyst - Contract
11 days ago

Business Analyst - Intermediate to Senior - Contract
Location: Sandton
Salary: R500 - 520 per hour
Business Analyst - Contract
11 days ago

Senior Business Analyst - Contract
Location: Sandton
Salary: R500 - 565 per hour
Senior Business Analyst - Contract
11 days ago

Warehousing & Distribution Manager
Location: Johannesburg
Salary: 850000 Annually
My client is a leading SC/Logistics company and they are looking for a competent Warehouse and Distribution Manager for their operations in Johannesburg. Proven experience is essential particularly in managing a multi-site operation. CIPS and/or CSCP is desirable with a related Diploma/Degree.
12 days ago

Debriefing Supervisor (Mix) - Riverfields
Location: Johannesburg
Salary: Monthly
Our National Listed client within the Logistics / Supply Chain sector is looking to appoint an experienced Debriefing Supervisor. This is for their branch in Rivervields / Kempton Park.
12 days ago

Zone Controller
Location: Kempton Park
Salary:
16 days ago

Data Warehouse Developer
Location: Johannesburg
Salary:
17 days ago

Data Warehousing / Data Modeler

Similar jobs you might be interested in:

Create a free job alert for Data Warehousing / Data Modeler in Centurion

Jobseekers

Recruiter

General