Description:
QUALIFICATIONS & EXPERIENCE:Matric/Grade 12 Degree or 3-year diploma (not required but would be an advantage)Microsoft certification-Designing and Implementing Enterprise-Scale Analytics Using Microsoft Azure and Microsoft Power BI (not required but would be an advantage) Microsoft Azure Fundamentals (not required but would be an advantage.1+ years relevant experience with sufficient knowledge to develop solutions using the following technologies:High Level Knowledge of Dimensional model design principlesData analysis Knowledge of ETL frameworkData exploration using Microsoft T-SQLMicrosoft SQL server programming (stored procedures, functions) Understanding of various data sources i.e. Microsoft SQL server, Oracle Database, APIs, flat files (csv, tab etc).Monitoring ETL jobs.JOB PURPOSE:Design and build ETL solutions that will extract data from multiple systems, transforming and loading into data marts/data warehouse Improve existing ETL solutions Support the existing platform and assist with migration to new platforms Troubleshoot data errors and perform root cause analysis where necessary Assist Data/BI analysts with technical guidance
25 Apr 2024;
from:
gumtree.co.za