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:

Senior Data Engineer (SAS & Python) - Johannesburg – R450 to R550 per hour
Location: Johannesburg
Salary: 1056000
Senior data Engineer (SAS & Python) - Johannesburg – R450 to R550 per hour
12 days ago

Senior Data Engineering Specialist
Location: Johannesburg
Salary:
Our client in the telecommunications sector is seeking a professional Senior data Engineering Specialist on a contract duration of one year.
1 day ago

Warehouse Supervisor- JHB,Klerksdorp, Paarl, Thobontle
Location: Johannesburg
Salary: To be discussed at Interview stage
To supervise all warehouse functions including receiving, put away, inventory and dispatch. This also includes maintaining and organizing the facility according to the Quality and Health and Safety Standards set out by the company and liaising/coordinating with the customer
1 day ago

Business Intelligence Analyst
Location: Johannesburg
Salary: 450000 Annually
In need of well-versed Business Intelligence Developer skills in JHB!
2 days ago

Data Engineer
Location: Johannesburg
Salary:
2 days ago

Data Test Analyst
Location: Johannesburg
Salary:
2 days ago

Business Intelligence (BI) Analyst â Gauteng & Cape Town
Location: Johannesburg
Salary: Monthly
Are you a BI Analyst passionate about data insights? Our clients are actively hiring!
5 days ago

Intermediate BI Developer – Johannesburg – R800k to R950k per annum
Location: Johannesburg
Salary: 950000
Intermediate BI Developer – Johannesburg – R800k to R950k per annum
5 days ago

Senior Business Intelligence Analyst - Johannesburg – R800k to R950k per annum
Location: Johannesburg
Salary: 950000
Senior Business Intelligence Analyst - Johannesburg – R800k to R950k per annum
5 days ago

Export Controller
Location: Johannesburg
Salary:
Job Title: Export Controller Location: Johannesburg, Gauteng, South Africa - Kempton Park Job Type: Full-Time Experience Level: Mid-Career (2+ years of relevant experience) Salary: Market Related - Send me your required monthly CTC and notice periodAbout the Role: We are seeking a meticulous and experienced Export Controller to join our logistics team. The Export Controller will be responsible for...
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