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:

Software Engineer: Data Lake / Warehousing
Location: Johannesburg
Salary: negotiable
Software Engineer: data Lake/ warehousing
69 days ago

SAP Datasphere Consultant
Location: Johannesburg
Salary:
Our client based in Rosebank is urgently looking for a SAP datasphere Consultant to join their team12 months renewable contractHybrid
8 days ago

Software Engineer - big data analytics platform
Location: Johannesburg
Salary:
Our client that is based in Gauteng has a vacancy for a suitably qualified Software Engineer to work within a big data analytics platform.
1 day ago

Data Modeller
Location: Pretoria
Salary: Market Related
My client has an opportunity for a data Modeller. The successful candidate will be responsible for designing and implementing data modelling solutions, which include, but are not limited to, the use of relational, dimensional, and NoSQL databases. Perform reverse engineering of physical data models from existing databases and SQL scripts.
3 days ago

Senior SQL DBA
Location: Midrand
Salary:
datacentrix is looking for a certified Senior SQL DBA to be based at our Midrand office. The candidate will be responsible for the provision of day-to-day database administration and support in a large corporation with a multiple database environments, including resolution of database problems, data backup and restore, and the production of database performance statistics.
6 days ago

Senior BI Developer – Johannesburg – R800k up to R1mil per annum
Location: Johannesburg
Salary: 800000
Senior BI Developer – Johannesburg – R800k up to R1mil per annum
7 days ago

Business Intelligence Analyst (SQL) - Johannesburg – R600k to R800k per annum
Location: Johannesburg
Salary: 800000
Business Intelligence Analyst (SQL) - Johannesburg – R600k to R800k per annum
7 days ago

Business Intelligence Manager
Location: Pretoria
Salary: Market related
Our client is looking for an experienced BI (Business Intelligence) Manager to lead the development,
7 days ago

Data Manager
Location: Johannesburg
Salary: 600 Hourly
We are looking for an experienced data Manager to lead the development and management of a large-scale, group-wide Rewards and Loyalty Programme aimed at our customers, members, and coalition partners. This role will integrate advanced data management practices, focusing on data governance, cloud-based architecture, big data, and machine learning, to drive our business growth. As a critical leader...
8 days ago

Intermediate BI Developer – Johannesburg – R600k to R800k per annum
Location: Johannesburg
Salary: 800000
Intermediate BI Developer – Johannesburg – R600k to R800k per annum
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