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:

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

Jnr Warehousing and Process Engineer (Logistics Industry)
Location: Kempton Park, Gauteng
Salary: Negotiable
To assist business in optimizing internal processes and implementing best practice in warehousing operations whilst also assisting in developing and reviewing Quality Work. to provide internal data analysis support. Finally, to develop analytics, systems and data management capabilities, including metrics and reports.
6 days ago

Senior Ab Initio Integration Consultant
Location: Johannesburg
Salary: Monthly
Psybergate is an IT company that builds bespoke software solutions and provides highly skilled resources to its clients.We are looking for an Senior Ab Initio Integration Consultant to join our financial services client based in Sandton for a hybrid 12-months contract role.A skilled Ab Initio developer specialising in implementing data processing solutions. The role encompasses business and system...
20 days ago

Senior SAP Integration Consultant - Ab Initio
Location: Sandton
Salary: R80k - 110k per month
Responsible for designing and developing robust data integration and processing solutions
20 days ago

Operations Manager – Contract Logistics (Johannesburg South)
Location: Johannesburg
Salary:
2 days ago

Site Agent
Location: South Africa
Salary:
Due to continued growth, Measured Ability Outsourcing Group is a leading Temporary Employment Services agency, looking to employ a permanent Site Agent
5 days ago

Senior Data EngineerÂ
Location: Johannesburg
Salary: Annually
To design, build, and maintain robust, scalable data infrastructure that ensures secure, real time access to operational and supply chain data
7 days ago

Senior Data Engineer
Location: Johannesburg
Salary:
7 days ago

BI Developer
Location: Centurion
Salary: Monthly
Psybergate is an IT company that builds bespoke software solutions and provides highly skilled resources to its clients.We are looking for a BI Developer to join our client based in centurion for a hybrid role.
8 days ago

Group Marketing Manager
Location: Centurion
Salary:
TechBridge Recruitment is partnering with a well-established national organization within the automotive parts, warehousing, and logistics industry to appoint an experienced Group Marketing Manager.This is a senior leadership role suited to a strategic, hands-on marketing professional who understands high-volume distribution environments and can drive brand growth, market presence, and commercial ...
2 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