Data Warehousing Specialist - Centurion

 

Recruiter:

Career Circuit

Job Ref:

Data Warehousing Spe..

Date posted:

Tuesday, April 19, 2022

Location:

centurion, Gauteng, South Africa

Salary:

Market Related


SUMMARY:
Data Warehousing Specialist - Centurion

JOB DESCRIPTION:

Main Job Purpose:

vMaintain and support:
ØExisting MIS databases.
ØExisting reports and dashboards.
ØExisting data warehouses.
vDevelop, test, deploy, maintain and support new databases, and reporting, data warehouse and business intelligence applications from high-level business requirements and designs, through the Software Development Life Cycle.
vRemain informed about developments and trends in the data enablement field to assist the business to keep its data analytics and management capability up-to-date, and able to meet the future needs of the business in a constantly maturing and increasingly complex short-term insurance industry.
v

Minimum Experience:

vMethodologies:
ØThe candidate must have ability to elicit data requirements from stakeholders.
ØThe candidate must have clear documentation skills.
vPrinciples:
ØThe candidate must be familiar with design patterns in data development industry.
ØThe candidate must have solid understanding of Metadata constructs & EDW.
ØKnowledge of Domain driven design would be an advantage.
ØMust be familiar with the concept of Data Marts & abstraction techniques.
vModelling:
ØThe candidate must have proven data modelling techniques (3 years).
ØThe candidate must have knowledge and experience in Ralph Kimball data warehouse modelling (3 years).
ØKnowledge of Immon data warehouse modelling techniques would add an advantage.
ØThe candidate must have data normalization skills most especially the 2nd Normal form.
vData Transportation:
ØThe candidate must have solid experience of ETL systems.
ØThe candidate must have solid experience of sourcing, staging and loading.
ØMust be familiar with parallel loading principles & source to target mapping.
vDevelopment Software:
ØThe candidate must have advanced knowledge of T-SQL (4 years) and the following concepts:  Dynamic T-SQL,  Multi-threading,  Performance optimisation and tuning.
ØThe candidate must have practical experience of SQL Server Database Engine (4 years), / MS SSIS ETL software (4 years), MS SSAS OLAP software (4 years).
ØThe candidate must have practical experience of MS Visual Studio Data Tools (4 years).
ØKnowledge of Database Administration would add an advantage.
ØExpert knowledge in configuration of database hardware resources.
vRepository type:
ØThe candidate must be able to source data from different repositories.
ØThe candidate must be fully acquainted with Microsoft SQL Server repository.
ØKnowledge of Data Lake & Oracle would be an advantage.
ØKnowledge of Hadoop is not essential but will also be an advantage.

 

NB! This job is now closed. You can apply for other jobs by uploading your CV.


 

 

 

Similar jobs you might be interested in:

Cost Accountant
Location: Johannesburg
Salary: 620000 Annually
My client is a well‑established manufacturing and warehousing business, looking for an experienced Cost Accountant to take ownership of their cost accounting function. This is a hands‑on, on‑site role focused on standard costing, cost control, and operational cost analysis within a manufacturing and storage environment.
3 days ago


Financial Accountant
Location: Johannesburg
Salary: 380000 Annually
A well-established company within the distribution and warehousing industry is seeking a skilled and detail-oriented Financial Accountant to join its dynamic team based in Springs.
16 days ago


Customer Service Specialist – Contract Logistics
Location: Johannesburg
Salary:
81 days ago


BI Data Engineer
Location: Johannesburg
Salary:
As a Senior data Engineer in Business Intelligence, you’ll be the architect behind scalable, secure data systems that power real-time insights across the logistics value chain. From building high-performance ELT pipelines and integrating complex platforms to delivering clean, trusted datasets, you’ll enable automation, cost optimisation, and smarter decision-making. This role is all ab...
11 days ago


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


Senior Integration Developer (TIBCO) – Contract
Location: Johannesburg
Salary:
1 day ago


Logistics Director: Logistics Industry
Location: Johannesburg
Salary: 2,5 Million
Are you a strategic thinker with a passion for optimizing supply chains and leading high-performing teams? Join our client an industry-leading company as a Logistics Director and drive operational excellence in a fast-paced, dynamic environment. As Logistics Director, you will spearhead the development and execution of comprehensive logistics strategies, oversee transportation, warehousing, and di...
2 days ago


Lead BI Developer - EE (Centurion)
Location: Centurion
Salary: 45000 Monthly
Job Purpose:Developing and maintaining data strategies aligned to supporting overall business goals. Management & technical execution of strategic business data projects and reportingTranslate complex data findings for various stakeholders across relevant departments as a decision support service.Managing subordinates & ensuring they achieve KPIs and achieve business goals.Qualifications a...
7 days ago


Mid-level Goods & Receiving Clerk
Location: Pretoria
Salary: R 144K
2–4 years’ experience in goods receiving, warehousing, or stock control.
10 days ago


SQL DBA
Location: Midrand
Salary:
A SQL DBA will be responsible for the provision of day-to-day database administration and support in a large corporation with a multiple database environment, including resolution of database problems, data backup and restore, and the production of database performance statistics. Includes the installation, configuration, upgrade, administration, and monitoring of databases and associated software...
10 days ago


Create a free job alert for Data Warehousing Specialist - Centurion in centurion, Gauteng

Enter your email address below and we will email you similar jobs when they become available:

You can cancel at any time. We will not spam you.
By giving us your email address your agree to our Terms and Conditions

 

Jobseekers

Register your CV Search jobs CV writing

Recruiter

Advertise jobs Search the CV database

General

Disclaimer Terms and conditions Privacy policy Cookie policy POPIA manual Unsubscribe

© Copyright 2026 Job Placements. All Rights Reserved.