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
Location: Johannesburg
Salary:
69 days ago

Operations Manager – Contract Logistics (Johannesburg South)
Location: Johannesburg
Salary:
1 day ago

Site Agent
Location: South Africa
Salary:
Due to continued growth, Measured Ability Outsourcing Group is a leading Temporary Employment Services agency, looking to employ a permanent Site Agent
4 days ago

Senior Data EngineerÂ
Location: Johannesburg
Salary: Annually
To design, build, and maintain robust, scalable data infrastructure that ensures secure, real time access to operational and supply chain data
6 days ago

Senior Data Engineer
Location: Johannesburg
Salary:
6 days ago

SAP K4 LE (Logistics Execution) Specialist
Location: Centurion
Salary:
7 days ago

BI Developer
Location: Centurion
Salary: Monthly
Psybergate is an IT company that builds bespoke software solutions and provides highly skilled resources to its clients.We are looking for a BI Developer to join our client based in Centurion for a hybrid role.
7 days ago

Group Marketing Manager
Location: Centurion
Salary:
TechBridge Recruitment is partnering with a well-established national organization within the automotive parts, warehousing, and logistics industry to appoint an experienced Group Marketing Manager.This is a senior leadership role suited to a strategic, hands-on marketing professional who understands high-volume distribution environments and can drive brand growth, market presence, and commercial ...
1 day ago

Senior BI Data Engineer - Boksburg - Engineering / Logistics / Supply Chain sectors preferred
Location: Johannesburg
Salary: R840 000
Senior data Engineer - Boksburg - Engineering / Logistics / Supply Chain sectors preferred
7 days ago

BI Developer
Location: Johannesburg
Salary: Hourly
Brief Description:Are you an experienced BI Developer with a passion for transforming data into meaningful insights? I’m currently partnering with leading organisations to identify Business Intelligence Developers for upcoming contract and permanent opportunities across South Africa.
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