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:

Power BI Specialist
Location: Johannesburg
Salary: market related Monthly
Role Summary:Our client is seeking a Power BI specialist with expertise in developing interactive dashboards, complex data models, and insightful analytics solutions. The successful candidate will have a strong grasp of data visualisation best practices and the ability to work with multiple data sources. Responsibilities:Design and develop Power BI reports, dashboards, and datasets.Build and ...
20 days ago

Power BI Specialist - Contract
Location: Johannesburg
Salary: R650 - 720 per hour
Power BI specialist - Contract
22 days ago

Junior BI Developer – Johannesburg – up to R350k per annum
Location: Johannesburg
Salary: 300000
Junior BI Developer – Johannesburg – up to R350k per annum
42 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
86 days ago

Senior Data Engineer - Onsite - JHB or CPT - Contract
Location: South Africa
Salary: R600 - 690 per hour
Senior data Engineer - Onsite - JHB or CPT - Contract
Today

Senior Data Engineer
Location: Johannesburg
Salary: market related Monthly
Job Summary:Our client is seeking a highly skilled Senior data Engineer with deep expertise in Snowflake and Matillion to design, build, and optimize scalable data pipelines and integration solutions. The ideal candidate will have a strong background in cloud data warehousing, ETL/ELT processes, and modern data architecture. Responsibilities:data Management and API integration.Design, develop...
1 day ago

Internal Sales Administrator
Location: Johannesburg
Salary: Monthly
A well-known established plastics/packaging group requires the above to provide commercial and operational support to the manufacturing and sales teams by coordinating, liaising with customers, principals and colleagues and handling all key internal sales administrational responsibilities for the company ensuring that customers expectations are met at all times.
3 days ago

Business Intelligence Analyst
Location: Johannesburg
Salary:
An industry leading Bank has an exciting opportunity available for a Business Intelligence Analyst to join their team.
7 days ago

Senior Database Developer
Location: Centurion
Salary: Annually
Gijima Staffing Solutions is recruiting on behalf of a client for a Senior database Developer.
9 days ago

Senior Database Developer
Location: Centurion
Salary:
JOB PURPOSEDesign, develop and maintain high performance scalable and secure database solution in order to ensure successful and efficient database solutions meeting the business requirements.
9 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