Data Warehousing / Data Modeler

Recruiter:

EQ Plus

Job Ref:

GTG006260/LR

Date posted:

Wednesday, June 15, 2022

Location:

Centurion, South Africa

JOB 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.
26 days ago

Intermediate Full Stack Developer
Location: Centurion
Salary:
Are you a seasoned software development professional looking for an exciting opportunity to join a leading technology solutions company? Our client is looking for an Intermediate Full Stack Developer to become a key player in their dynamic team.
3 days ago

Chief Operations Officer (Cape Town) Manufacturing Operations
Location: South Africa
Salary: 2 300 000 Annually
Our Client, an International Personal Care and Dermology brand, is looking for a Head of Supply Chain / Chief Operations Officer to join their team in Cape Town.Qualification and Experience: Bachelor's degree in Engineering (Electrical/Chemical/Mechanical)Manufacturing in the personal care industry10 years of practical and hands-on experience at a Senior Management levelExperience in successfully ...
4 days ago

Senior BI Developer – Johannesburg – up to R1.2mil per annum
Location: Johannesburg
Salary: 1 200 000
Senior BI Developer – Johannesburg – up to R1.2mil per annum
7 days ago

Senior Full Stack Business Intelligence Developer – Johannesburg – up to R1.1mil
Location: Johannesburg
Salary: 1 100 000
Senior Full Stack Business Intelligence Developer – Johannesburg – up to R1.1mil
7 days ago

Senior Specialist: Data Integration & Operational Analytics
Location: Johannesburg
Salary: Monthly
An urgent need has arisen within the telecommunications sector for a highly experienced data INTEGRATION & OPERATIONAL ANALYTICS.
11 days ago

Operations Manager (Expat)
Location: Johannesburg
Salary: Market related
Our client is looking for a highly efficient and experienced Operations Manager to oversee the wareh
13 days ago

Warehouse Manager
Location: Johannesburg
Salary: R700 000 Annually
To lead inventory and warehouse management strategy and efficient execution. Examine existing procedures / processes and streamline activities in such a way that customer requirements are met on time in full and at lowest possible cost. Identify process improvement opportunities and implement alternate methods to increase efficiencies, product and process quality, reduce costs and improve overall ...
14 days ago

AWS Data Engineers Required - Project Based - Contractual-to start asap-JHB - Hybrid
Location: Midrand
Salary: Market related
AWS, data, Engineers, Required, Project, Based, Contractual, to, start, asap, JHB, Hybrid
14 days ago

Data Engineer (AWS and Redshift) - Johannesburg – up to R1mil
Location: Johannesburg
Salary: 1000000
data Engineer (AWS and Redshift) - Johannesburg – up to R1mil
25 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