Data Engineer

Locations: Gauteng or Cape Town

Working model: Hybrid

 

Specification:

The Data Engineer will have a knack for data analysis, data manipulation, and data modelling. The candidate will be responsible for understanding and driving the overall technical vision and planning of an organisation and translating business needs into technical strategy.

 

Requirements:

• 4 + Years’ working experience as a Data Engineer / Database Developer.
• Experience in data mining, large scale data modelling and business requirements gathering/analysis.
• Understanding and working experience in data integration and transformation.
• Experience implementing data modelling methodologies like Dimensional Modelling and / or Data Vault.
• Working knowledge of data quality processes and master data management.
• Experience implementing design support systems using Database Management Systems (DBMS) such as SQL Server or Oracle.
• Proficiency in designing and implementing data integration and ETL solutions using SSIS, Azure Data Factory and / or SQL Server stored procedures.
• Understanding of several Big Data technologies like Hadoop, MapReduce and Spark as well as event processing or message ingestion services like Kafka, Event Hub and Stream Analytics.
• Experience in database query languages.
• Some experience developing software solutions.
• Experience using SQL Server management Studio and Visual Studio.
• Experience implementing solutions using Azure.

 

Qualifications:

• Tertiary degree, diploma or certificate in a related field.
• DP-203: Data Engineering on Microsoft Azure Certification.

 

Key Responsibilities:

• Identify valuable data sources and automate collection processes.
• Undertake preprocessing of structured and unstructured data.
• Analyse large amounts of information to discover trends and patterns.
• Data Modelling (Relational and Star Schema).
• Database design.
• Database development.
• Data Warehouse Design.
• Database Administration.
• Database Performance Tuning and Optimisation.
• Present information using data visualization techniques.
• Propose solutions and strategies to business challenges.
• Collaborate with engineering and product development teams.
• An understanding and hands on experience on Hadoop/Spark based distributed storage and computing frameworks.
• Real-Time analytics and batch processing.
• Strong experience in architecting analytical applications in cloud environment.

 

Please reach out for more information.