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:

Analytics Engineer
Location: Pretoria
Salary: 1 100 000 Annually
data is your passion, and you thrive on turning complex datasets into meaningful business insights. If you're an experienced data Analyst with strong Microsoft data Platform expertise and a drive to deliver impactful reporting and analytics solutions, this could be the opportunity you've been waiting for.
2 days ago

AI Analytics Internal Auditor
Location: Johannesburg
Salary: Monthly
Are you passionate about combining Artificial Intelligence, data Analytics, and Internal Audit to drive smarter business decisions? This is an exciting opportunity to leverage advanced analytics and AI technologies to identify risks, enhance audit effectiveness, and deliver meaningful business insights within a highly analytical and innovative environment.
5 days ago

Advanced Specialist: Data Governance
Location: Johannesburg
Salary: Annually
A leading organisation within a highly regulated and data-driven environment is seeking an experienced Advanced specialist: data Governance to help drive enterprise-wide data governance initiatives. This is an excellent opportunity for a governance professional with expertise in data quality, compliance, metadata management, and information governance to play a strategic role in ensuring trusted, ...
12 days ago

Senior BI Analytics Engineer
Location: Pretoria
Salary: Annually
Senior BI Analyst responsible for transforming data into actionable business insights through reporting, analytics, and Business Intelligence solutions. Develops datasets, semantic models, dashboards, and reports that support data-driven decision-making, while partnering with stakeholders to gather requirements and deliver scalable reporting and analytics solutions.
1 day ago

Client Relationship Manager (CRM) - Onsite
Location: Centurion
Salary: R0 per month
Client, Relationship, Manager, CRM, Onsite
2 days ago

Client Relationship Manager
Location: Randburg
Salary: Market related
Client, Relationship, Manager
2 days ago

Client Service Coordinator
Location: Randburg
Salary: Market related
Client, Service, Coordinator
2 days ago

HR & Payroll Administrator
Location: Roodepoort
Salary: Monthly
Leading supplier of kitchen utensils, industrial cookware, commercial kitchens & appliances to the hospitality & food service industries based in the Roodepoort is looking for an experienced and organised HR & Payroll Administrator to join their Human Resources team.Reporting to the HR Manager, the successful candidate will support the full HR function, with a focus on payroll administ...
2 days ago

Analytics Engineer (Business Intelligence and Reporting) - Hybrid
Location: Pretoria
Salary: ZAR 0
Our client is searching for an Analytics Engineer to join their data & Analytics team in Pretoria (Hybrid)This role is ideal for someone passionate about transforming data into meaningful business insights thro...
2 days ago

Operations Manager
Location: Rosslyn
Salary: 50000
Operations ManagerPretoria
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

Jobseekers

Recruiter

General