International Company with a focus on delivering customised data warehousing design and development and data visualization to a global client base. Offers a fully remote work environment on an 8-hour day contract basis, specifically skilled persons based in SA. It is expected that successful persons have suitable work environment setup from power and connectivity perspective to work remotely. Liaise with Clients and develop an understanding of business processes and data reporting needs. Critically analyze business requirements and architect and implement design flows and data integration Develop data warehouse models and lineage documentation which will be used by ETL developers to build out the data warehouse Produce technical/architectural specification and design/technical documents Design and create ETL/ELT scripts for data warehouse and reporting tables Implement stored procedures and effectively query databases Design and program data quality and exception reports Participate in defining and optimizing software development process and best practices Identify and test for defects and bottlenecks in the ETL solution to ensure high performance and no data quality concerns Provide support and fix ETL/ELT issues Relevant degree and certification Knowledge of data modelling 6 years in a relevant environment applying relevant skills 5 years ETL experience Indepth knowledge of systems architecture, distributed development, web-services Strong knowledge of data warehouse architecture techniques such as EDW, ODS, DM, ROLAP and MOLAP Understanding and coding of concepts such as incremental load, slowing changing dimension types Experience writing complex SQL scripts used for ETL development or testing 1 years' experience in Azure SQL Data Warehouse and related technologies including one or more of: Azure Data Factory, Azure Data Lake, Azure HDInsight, Azure Databricks, etc. Experience with SSIS or Talend and SQL Server; ability to deploy to and debug a production SSIS environment. XML experience Experience with tuning databases for optimal performance Team leader skills Apply Now

Share this job with someone you think should apply!

Facebook

Data Developer Remote - South Africa

Related Jobs

Data Engineer - Johannesburg

Data Engineer Johannesburg North - North Johannesburg

Senior Data Engineer - Stellenbosch

Senior Data Engineer Cape Winelands: Stellenbosch - Stellenbosch

Data Engineer - Gauteng

Want to do another search?