Senior Data Analyst and Modeller - Johannesburg, South Africa - H2R Africa

H2R Africa

Verified Company

Johannesburg, South Africa

1 week ago

Posted by:

Thabo Mthembu

beBee Recruiter

Description

Our client, a leading and International Mining Company, has a contract vacancy for a Senior Data Analyst and Modeller.

The senior data analyst will be responsible for building, optimizing, and maintaining conceptual and logical data models to ingest and curate data from source systems into an
Azure data lake.

The models must comply with the governance and requirements of the Central Data Platform.

The senior data analyst will have a key role to interface with business users to understand the data requirements and must further interface with the CDP data architecture and modelling teams to ensure unified data models

Minimum 5 years in a datacentric environment working in either SQL Data-Warehousing, Analytics or as a dedicated Data-Modeller
Above average TSQL and SQL server
Logical, and Physical Data-Modelling
Experience with Forward and Reverse Engineering of Existing
Good understanding of Star Schemas, Snowflake Schemas, and Kymbal
Skilled at formulating Dimensions, measures and attributes and building multidimensional
Experienced with metadatamodelling
Experience with Data-Governance principles and Data-Cleansing
Experienced at keyformulation: primary keys, foreignkeys, alternatekeys, surrogatekeys, indexes, deltacontrol
Experience of working with Data-Modelling
Some exposure to Cloud
Exposure to mining production and operations data would be beneficial
Develop Logical and physical data models
Conformance of data models to CDP enterprise data model
Adherence to data architecture
Adherence to data governance
Serve as an interface between business analysts and technical
Provide input to technical implementation documents for all levels of curation from Level 0 to Level
Assist with testing and validation of data ingestion pipelines