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

JOB 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.

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:

Logistics - Talent
Location: Johannesburg
Salary:
If you are a senior Logistics Manager with a proven track record of delivering operational excellence, driving cost optimisation, and leading high-performance teams — this is for you.I’m Kavian Naidoo, specialist Recruiter at Network Recruitment, partnering with leading organisations across FMCG, Manufacturing, and Logistics.I represent professionals who are not just looking for jobs &...
4 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.
8 days ago

Junior BI Developer
Location: Johannesburg
Salary:
Launch your career in Business Intelligence by working handsâon with SQL, reporting platforms, and modern Microsoft data technologies in a supportive, growthâfocused environment.
15 days ago

Customer Service Specialist – Contract Logistics
Location: Johannesburg
Salary:
73 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...
3 days ago

SAP K4 LE (Logistics Execution) Specialist
Location: Centurion
Salary:
86 days ago

Mid-level Goods & Receiving Clerk
Location: Pretoria
Salary: R 144K
2–4 years’ experience in goods receiving, warehousing, or stock control.
2 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...
2 days ago

Senior Data Specialist
Location: Johannesburg
Salary:
Are you a senior data professional looking to apply advanced analytics and data science in a highly regulated environment where your insights directly influence strategy, cost management, and risk mitigation? This is an opportunity to work at the centre of decisionâmaking, using sophisticated data tools to drive meaningful business impact.
2 days ago

Junior BI Developer
Location: Johannesburg
Salary:
Are you detail-driven, curious, and eager to grow your career in Business Intelligence?Our client, a leading direct selling company, is seeking a Junior BI Developer to join their development team and help design, deliver, and maintain BI solutions that power smarter decision-making across the organisation.This is the perfect role for someone with foundational Microsoft data skills who is ready to...
4 days ago

Data Warehousing Specialist - Centurion

Similar jobs you might be interested in:

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