TEMP DATA MODELLER – SANDTON
The role entails architecting the data platform layer, data cleansing layer, reporting and analytical layers within a cloud environment. Work closely with Data Scientists to understand model features and link back to transactional environment to understand data quality, data relationships and data availability. Document and define frameworks with the Data Engineer to build the data platform.
Requirements
- Provide Data Architecture (DA) support for the Data Engineering team
- Define DA for the Data Science teams and participate in review and walk-through sessions for model t and model producionization
- Assist with the definition of custom meta data models for ELT/ETL
- Direct data automation capabilities with the Data Engineer and Data Scientist
- Profile new data sources in a variety of formats including Json, XML, etc.
- Define data quality rules with Data Scientists to clean data
- Define data mapping and transformation rules between source and Datawarehouse and data lake
- Work closely with Data Engineer to facilitate Data Governance including access and security control
- Expert documentation of DA for new data sources, metadata and productionized information flow
Qualifications
- Honours degree in BSc Computer Science or BTech
- 5 to 15 years of data modelling experience is preferred
- Expert database knowledge in SQL
- Exceptional data modelling skills, ie physical, dimensional, relational 3N forms, and Kimball
- Datawarehousing experience is critical
- Experience working on large and complex datasets
- Programming in R, Python is advantageous
- Experience with MS Azure and Modern Azure Datawarehouse design skills is advantageous
- DevOps/DataOps and CI/CD experience
[ninja_form id=’1423′]