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:

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


Senior ETL Developer & Database Administrator (DBA)
Location: Johannesburg
Salary: Monthly
Are you a Senior ETL Developer with strong database Administration expertise and a passion for building high‑performance data solutions? This is an exciting opportunity to take ownership of end‑to‑end data workflows, optimise enterprise databases, and contribute to a data‑driven environment where your expertise will make a real impact.
28 days ago


Senior Business Application Analyst
Location: Johannesburg
Salary:
Are you a data-driven problem solver with a passion for finance and technology? Step into a senior role where you’ll bridge the gap between business, data, and systems to drive impactful digital transformation and business intelligence solutions.
18 days 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 Analyst (Betting & iGaming)
Location: Johannesburg
Salary: 50 000
About the CompanyOne of South Africa's leading organisations in the sports, entertainment and online gaming industry is seeking an experienced data Analyst to join its growing Commercial Analytics team. Operating in a highly transactional, data-driven environment, the business leverages advanced analytics to optimise customer acquisition, retention, marketing performance and commercial decisi...
9 days ago


Data Analytics Lead
Location: Johannesburg
Salary:
We are looking for a data Analytics Lead to be responsible for driving data strategy execution, overseeing analytics and engineering initiatives, mentoring technical teams, and ensuring successful delivery of strategic projects including data warehousing, optimization, automation, and data science initiatives. We have a permanent role in Johannesburg.
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.