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).
