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:

Intermediate Cloud Data Engineer – Johannesburg – up to R600k per annum
Location: Johannesburg
Salary: 600 000
Intermediate Cloud data Engineer – Johannesburg – up to R600k per annum
Today

Warehouse Specialist
Location: Midrand
Salary:
A leading player in the FMCG sector is seeking a Warehouse Layout & Process Optimisation Specialist to drive space utilisation, efficiency, and operational excellence across their South African depots. You are an analytical and proactive professional with strong communication skills, a deep understanding of warehouse optimisation principles, and the ability to manage multiple priorities in a f...
1 day ago

BI Developer
Location: Johannesburg
Salary:
Join our dynamic BI team as a Business Intelligence Developer, where you will play a key role in ensuring data quality, integrity, and alignment with source systems. You will design, build, and optimize BI solutions while supporting and enhancing existing reports to meet business needs.
1 day ago

Parts Technical Support Representative
Location: Johannesburg
Salary:
A leading organization in the agricultural and engineering sector is seeking a dedicated Parts Technical Support Representative to join its high-performing technical support team. The ideal candidate will have a strong mechanical background and a proven ability to manage complex customer service and parts-related issues in a dynamic environment.
5 days ago

Data Analyst
Location: Johannesburg
Salary: 500000
On the hunt for a data Analyst in Johannesburg!
6 days ago

Scrum Master (Azure Data Management) - 6 month project
Location: Johannesburg
Salary: R800+ per hour
Scrum Master (Azure data Management)
7 days ago

Technical Team Lead: Azure Data Management - 6 month contract
Location: Johannesburg
Salary: R700 per hour plus
Technical Team Lead (Azure data Management)
7 days ago

Data Engineer (Azure) - 6 month contract
Location: Johannesburg
Salary: R450 - R800/hour depending on experience
Azure data Engineer
7 days ago

Principal Enterprise Architect
Location: Midrand
Salary:
8 days ago

Junior System Engineer
Location: Johannesburg
Salary: R240K-R280K CTC
Johannesburg
8 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