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:

Senior Data Engineer
Location: Johannesburg
Salary:
58 days ago

Senior Specialist Data Scientist
Location: Johannesburg
Salary: 1 200 000
Mission/ Core purpose of the Job:To determine insights and develop statistical models from large quantities of structured and unstructured data to shape or meet specific business needs and goals.Trainingdata science and advanced analytics.data base modelling and data warehousing principles (SQL)Big data tools (Spark, Hive, etc)Strong Programming skills (R, SAS, Python, C++, Java, etc…)Compu...
Today

SQL Developer and Database Administrator
Location: Centurion
Salary: Market Related Salary
SQL, Developer, and, database, Administrator
Today

Data Scientist
Location: Johannesburg
Salary:
Exciting opportunity for a skilled data Scientist passionate about turning complex data into meaningful strategic value.
1 day ago

Warehouse Team Leader
Location: Johannesburg
Salary:
1 day ago

Inventory Supervisor
Location: Johannesburg
Salary:
4 days ago

Senior SAP Integration Specialist (1-year contract) (Banking)
Location: Johannesburg
Salary:
7 days ago

Senior Ab Initio Integration Consultant
Location: Johannesburg
Salary: Monthly
Psybergate is an IT company that builds bespoke software solutions and provides highly skilled resources to its clients.We are looking for an Senior Ab Initio Integration Consultant to join our financial services client based in Sandton for a hybrid 12-months contract role.A skilled Ab Initio developer specialising in implementing data processing solutions. The role encompasses business and system...
8 days ago

Senior SAP Integration Consultant - Ab Initio
Location: Sandton
Salary: R80k - 110k per month
Responsible for designing and developing robust data integration and processing solutions
8 days ago

Health and Safety Officer
Location: Pretoria
Salary:
9 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