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:

Cloud Engineer
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 a Cloud data Engineer to join our financial services client based in Sandton for a 12-month contract role.The Cloud data Engineer is responsible for designing, developing, and maintaining enterprise-grade data products that enable advanced analytics and busines...
14 days ago

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

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

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

Principal Database Engineer/Developer
Location: Johannesburg
Salary: Monthly
Are you a seasoned database Engineer with a passion for data architecture, business intelligence, and enterprise-scale data solutions? This is an exceptional opportunity to lead the design of sophisticated data platforms, influence technical strategy, and drive innovation across a high-impact data environment.
1 day ago

Storeman / Storelady (Automotive Logistics)
Location: Pretoria
Salary: Annual Salary
We are seeking a reliable and detail-oriented Storeman/Storelady with experience in automotive logistics and warehouse operations.
1 day ago

DATA ENGINEER
Location: Bryanston
Salary: Market related
Individual must be ready to support financial services data platform in a multi-tenant environment.
2 days ago

Principal Database Engineer
Location: Johannesburg
Salary:
If you're an Oracle Developer who enjoys building enterprise data solutions, developing ETL processes, designing BI repositories, and transforming complex business requirements into scalable reporting platforms, this opportunity will put you at the centre of a business where data drives strategic decisions.
3 days ago

Assistant Operations Manager
Location: Kempton Park
Salary:
ASSISTANT WMS MANAGER - OPERATIONS - KEMPTON PARK
3 days ago

Data Analyst / Business Data Analyst - Contract
Location: Johannesburg Metro
Salary: R0 per hour
data Analyst / Business data Analyst to support a strategic data transformation programme
4 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