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:

Intermediate Cloud Data Engineer – Johannesburg – up to R600k per annum
Location: Johannesburg
Salary: 600 000
Intermediate Cloud data Engineer – Johannesburg – up to R600k per annum
Today


Business Intelligence Developer – Constantia Kloof – R720k PA
Location: Johannesburg
Salary: 720 000
Business Intelligence Developer – Constantia Kloof – R720k PA
13 days ago


Team Leader – Business Intelligence (BI)
Location: Johannesburg
Salary:
Are you an experienced Business Intelligence leader ready to drive strategy, mentor a high-performing team, and architect data solutions that shape enterprise-wide decisions? We’re seeking a Team Leader: Business Intelligence to guide the end-to-end development and execution of BI capabilities across a leading financial services group. This is a strategic and hands-on role for a visionary wi...
13 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.
16 days ago


Lead Data Engineer
Location: Centurion
Salary:
An exciting opportunity has become available for an experienced Lead data Engineer to join a forward-thinking investment and technology-driven environment on a 12-month contract, based on-site in centurion. This role is ideal for a senior-level data engineering professional ready to take on a pivotal leadership position in driving modern data solutions, team performance, and enterprise-wide data i...
26 days ago


Intermediate Cloud Data Engineer – Johannesburg – up to R600k per annum
Location: Johannesburg
Salary: 600 000
Intermediate Cloud data Engineer – Johannesburg – up to R600k per annum
27 days ago


Data Engineer (SAS to Databricks) – Johannesburg – R800k to R1mil per annum
Location: Johannesburg
Salary: 800000
data Engineer (SAS to databricks) – Johannesburg – R800k to R1mil per annum
42 days ago


Support Data Engineer – Johannesburg – R450k to R650k per annum
Location: Johannesburg
Salary: 650 000
Support data Engineer – Johannesburg – R450k to R650k per annum
42 days ago


Power BI Specialist – Johannesburg - R700k to R900k per annum
Location: Johannesburg
Salary: 700 000
Power BI specialist – Johannesburg - R700k to R900k per annum
46 days ago


BI Developer – Johannesburg – R650k to R850k per annum
Location: Johannesburg
Salary: 850000
BI Developer – Johannesburg – R650k to R850k per annum
55 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 2025 Job Placements. All Rights Reserved.