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.

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:

Data Engineer (AWS and Redshift) - Johannesburg – up to R1mil
Location: Johannesburg
Salary: 1000000
data Engineer (AWS and Redshift) - Johannesburg – up to R1mil
3 days ago

Senior Full Stack Business Intelligence Developer – Johannesburg – up to R1.1mil
Location: Johannesburg
Salary: 1100000
Senior Full Stack Business Intelligence Developer – Johannesburg – up to R1.1mil
17 days ago

Sales Administrator
Location: Centurion
Salary: R 12 000 Monthly
Our client is a well-established medical group of companies in Irene, centurion. They are looking for a Sales Administrator to join their dynamic team.
3 days ago

Data Architect
Location: Johannesburg
Salary:
We are recruiting for a data Architect.
4 days ago

Business Analyst - Intermediate to Senior - Contract
Location: Sandton
Salary: R500 - 520 per hour
Business Analyst - Contract
4 days ago

Business Analyst - Intermediate to Senior - Contract
Location: Sandton
Salary: R500 - 520 per hour
Business Analyst - Contract
4 days ago

Senior Business Analyst - Contract
Location: Sandton
Salary: R500 - 565 per hour
Senior Business Analyst - Contract
4 days ago

Category Manager - Spares and Vehicle Maintenance
Location: Johannesburg
Salary: 800 000 Annually
Leading company in the Logistics and Supply Chain industry is looking for a Category Manager for their Spares and Vehicle Maintenance area. This is an exciting role and requires strong category management experience with parts and components in a spend of approximately R300m or more. South Africans may apply while preference will be given to equity candidates.
5 days ago

Warehousing & Distribution Manager
Location: Johannesburg
Salary: 850000 Annually
My client is a leading SC/Logistics company and they are looking for a competent Warehouse and Distribution Manager for their operations in Johannesburg. Proven experience is essential particularly in managing a multi-site operation. CIPS and/or CSCP is desirable with a related Diploma/Degree.
5 days ago

Debriefing Supervisor (Mix) - Riverfields
Location: Johannesburg
Salary: Monthly
Our National Listed client within the Logistics / Supply Chain sector is looking to appoint an experienced Debriefing Supervisor. This is for their branch in Rivervields / Kempton Park.
5 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

Jobseekers

Recruiter

General