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 BI Developer (Financial Reporting & Data Warehousing)
Location: Johannesburg
Salary: 750000 Annually
Senior BI Developer (Financial Reporting & data warehousing) | Johannesburg | Financial Services.
12 days ago

Project Manager
Location: Sandton
Salary: R70k - 90k per month
Delivering data-driven and banking-related projects, requiring strong stakeholder engagement
36 days ago

Data Engineer
Location: Johannesburg
Salary:
40 days ago

Project Manager
Location: Sandton
Salary: R70k - 90k per month
Delivering data-driven and banking-related projects, requiring strong stakeholder engagement
43 days ago

Project Manager
Location: Sandton
Salary: R70k - 90k per month
Delivering data-driven and banking-related projects, requiring strong stakeholder engagement
43 days ago

Project Manager
Location: Sandton
Salary: R70k - 90k per month
Delivering data-driven and banking-related projects, requiring strong stakeholder engagement
64 days ago

Senior SQL Developer (JHB)
Location: Johannesburg
Salary:
1 day ago

Relationship Partner
Location: Johannesburg
Salary:
4 days ago

Manufacturing Manager - Cable manufacturing
Location: Johannesburg
Salary: Market related
Manufacturing Manager - Cable manufacturing
4 days ago

BI, Analytics & Data Insights Manager
Location: Johannesburg
Salary:
5 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