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:

Data Engineer - Lumos - Sandton- 12 months - Start Date - January 2025
Location: Sandton
Salary: Market related
data, Engineer, Lumos, Sandton, 12, months, Start, Date, January, 2025
2 days ago

Senior Power BI Reports Support Engineer - Johannesburg - R800k to R1mil per annum
Location: Johannesburg
Salary: 1 000 000
Senior Power BI Reports Support Engineer - Johannesburg - R800k to R1mil per annum
3 days ago

DATA AND MODELLING SPECIALIST
Location: Johannesburg
Salary:
Are you ready to play a pivotal role in shaping the future of data architecture across Africa? Join a leading Pan-African telecommunications company as we establish a world-class Software Engineering Centre of Excellence. We are looking for a Platform Architect (data) who will drive innovation, build robust big data solutions, and empower business decisions through cutting-edge technologies.
5 days ago

Business Intelligence
Location: Midrand
Salary:
Business Intelligence - ITC Infrastructure (Gauteng)
5 days ago

Business Intelligence Developer
Location: Johannesburg
Salary: 400 Hourly
Business Intelligence DeveloperUnemployed and urgently looking for employment?
10 days ago

Finance and Administrative Clerk
Location: Centurion
Salary:
10 days ago

Senior BI Analyst
Location: Johannesburg
Salary: 600000.00 Monthly
Are you an experienced Senior BI Analyst with a passion for turning data into actionable insights? Our client, based in Bryanston, is looking for a dynamic, results-driven individual to join their team. If you have over 5 years of experience in business intelligence and data analysis, along with a strong background in strategic reporting, data storytelling, and mentorship, this is the perfect oppo...
13 days ago

POD Administrator
Location: Johannesburg
Salary:
A global leader in the logistics industry is looking for a POD Administrator with experience in POD management to join their team on a 6-month contract.Candidates who are immediately available are encouraged to apply.
16 days ago

Data Engineer – Johannesburg - R800k to R1mil per annum
Location: Johannesburg
Salary: 800000
data Engineer – Johannesburg - R800k to R1mil per annum
16 days ago

Senior BI Analyst
Location: Johannesburg
Salary: 58000 Monthly
Our client in the bureau industry is seeking an experienced and strategic Senior BI Analyst to join their team. You will lead advanced data analysis and reporting initiatives, transforming massive datasets into actionable insights that guide our organization’s strategic decision-making.
17 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