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:

Financial Services Data Management
Location: Johannesburg
Salary:
Job Purpose:We require a Big data Specialist to assist with harmonising data from diverse sources, to analyse, problem solve, reconcile, develop solutions, and build reporting in various tool sets, to enable Business understanding and decision making
2 days ago

Data Analyst and Business Intelligence Developer
Location: Johannesburg
Salary:
2 days ago

Inventory and Planning Manager
Location: Midrand
Salary:
Are you a detail-oriented supply chain professional with a knack for planning and logistics? My client is looking for an Inventory and Planning Manager to oversee inventory control, warehousing, production planning, and sales order fulfilment across multiple sites.
6 days ago

Data Engineer
Location: Johannesburg
Salary: 840000 Annually
Apply here to showcase your data Engineer skills! Work with modern tech, big data, and a team that loves clean, scalable solutions.
7 days ago

Software Engineer.
Location: Johannesburg
Salary: Negotiable on experience
B.Degree Computer / Software Engineering/ Computer Science. At least 2 - 5 years experience. Knowledge of data lake and warehousing solutions. Experience with either Python, Java, C++, C#, SQL databases
7 days ago

PAM 16000 - Warehouse Controller (Manufacturing) – East Rand
Location: Johannesburg
Salary: R400K – R700K CTC
Warehouse Controller (Manufacturing) – East Rand
7 days ago

BI Developer
Location: Johannesburg
Salary:
Are you a BI Developer with strong skills in Power BI or Tableau? Ready to turn data into insight and help businesses make smarter decisions? Then this one’s for you!
7 days ago

Senior Advisor: ICT Services
Location: Pretoria
Salary:
8 days ago

Data Analyst
Location: Johannesburg
Salary: 320000
On the hunt for a data Analyst in JHB!
9 days ago

Power BI Developer (12 Months Contract)
Location: Centurion
Salary:
We are recruiting for a Power BI Developer role, for a period of 12 months. The ideal candidate will work closely with business stakeholders to understand their requirements, transform data into actionable insights, and support data-driven decision-making across the organisation.
11 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