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 (SAS & Python) - Johannesburg – R450 to R550 per hour
Location: Johannesburg
Salary: 1056000
Senior data Engineer (SAS & Python) - Johannesburg – R450 to R550 per hour
86 days ago

BI Developer – Johannesburg – R650k to R850k per annum
Location: Johannesburg
Salary: 850000
BI Developer – Johannesburg – R650k to R850k per annum
4 days ago

Specialist in Inventory and Warehousing
Location: Johannesburg
Salary:
We are seeking a highly skilled Specialist in Inventory and warehousing to support the global implementation and management of our inventory and logistics strategy. This role plays a critical part in ensuring optimal service levels and the efficient management of working capital across our operations.
5 days ago

BI Developer (Implementation Support)
Location: Johannesburg
Salary: Monthly
A client, with offices based in the heart of Johannesburg East, is looking for a Business Intelligence Developer to join their team, where you will be responsible for implementation support, focusing on data, and will play a crucial role in designing, developing, and maintaining their business intelligence reporting solutions.
5 days ago

CTO
Location: Johannesburg
Salary: Annually
The CTO will play a crucial role in leveraging advanced technologies, optimising data-driven decision-making and ensuring the security and scalability of the infrastructure.
6 days ago

Senior BI Specialist
Location: Johannesburg
Salary: 60000.00 Monthly
Our client is looking for a highly skilled and driven Business Intelligence (BI) Specialist to join their team on-site in Edenvale. Are you a data-driven problem solver with a passion for innovation and technical excellence? Do you thrive in fast-paced environments and enjoy leading impactful BI initiatives using cutting-edge technologies? If so, this opportunity is for you.
6 days ago

BI Developer
Location: Johannesburg
Salary:
Job Title: Senior Business Intellegence DeveloperLocation: Northern SuburbsApplication Submissions: itplacements@alos.co.zaRenumeration: Basic Salary and Benefits
6 days ago

Software Engineer
Location: Midrand
Salary:
6 days ago

Senior Software Engineer
Location: Midrand
Salary:
6 days ago

Business Development Executive
Location: Johannesburg
Salary:
10 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