Data Analytics Engineer

We are looking for a Data Analytics Engineer, to join our team based in Cape Town(on-site).

Main Responsibilities:

• Define a structured approach to problem solving and delivery against it.
• Create role specific design standards, patterns, and principles.
• Assist and advise the planning and management of the workload of the team.
• Taking a lead in analytical and information layer design solutions and provide guidance to other data analytics engineers in the team.
• Collaborating with other data engineers and data modelers, you will design, implement, and manage the data pipeline to avail data in the information layer.
• Create and automate reports for use by a large user base across our branch network.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing models for greater scalability.
• Monitor and fine-tune the data pipeline, reports and information layer for optimal performance.
• Monitor and manage hardware and software in the SOH Analytics environment regarding maintenance, patching, upgrades and access.
• Use modern development and modelling techniques and tools to implement BI and data management solutions, including data quality, metadata, and reference data.
• Engage with a wide range of technical stakeholders including data scientists, data analysts, business analysts, other data engineers and solution architects.
• Support Data stewards to establish and enforce guidelines for data collection, quality improvements, integration, and processes.
• Design and implement dimensional models, or other structures in analytical layer.

Role Requirements:

Qualifications:

Bachelors degree in computer science, Statistics, Informatics, Information Systems, Engineering or other quantitative fields/ National Diploma in an Information Technology related discipline preferred.

Work Experience:

Must have 2-5 years of relevant experience in a similar environment working with the relevant tools and techniques.

Technical Knowledge and Experience:

• Strong understanding of data, data structures, and data sources.
• Application and data engineering background with a solid knowledge of SQL.
• Knowledge of database management system (DBMS) physical implementation, including tables, joins and SQL querying.
• Experience in Database technologies (e.g. SAP, HANA, and Web IDE, or similar) or Hadoop components including HDFS, Hive, Spark, Oozie & Impala preferred and highly advantageous.
• Knowledge & experience of all BOBJ components is desirable. Create & maintain universes & business layer through IDT, BOBJ report, building, maintenance, scheduling & publications with Web Intelligence and CMC.
• Object- orientated /object functional scripting languages (python, Java, Shell or related).
• Knowledge & experience of structured data, such as entities, classes, hierarchies, relationships & metadata.
• Strong Data Engineering background with a specific focus on staging high quality data.
• Understanding of data warehousing principles (Kimball and Vault).
• Experience in agile development.
• Ability to comply to & manage data assets under strict governance framework.

Preferred Skills include:

• Data Warehousing (Kimball & Data Vault patterns preferred) & dimensional data modelling (OLAP & MDX experience)
• Solid background in SQL, Informati0on Architecture & ETL procedures.
• Experience with object-orientated/functional/scripting languages (e.g. Oython, Unix Shell Scripting, Java, Scala etc.) is preferred but not essential.
• Data Management technologies (Informatica Data Quality (IDQ), Informatica Enterprise Data Catalog (EDC), Axon, EBX).