Senior Data Analytics Engineer at Sanlam Group

What will you do?

Main Responsibilities:
The performance of the Data Analytics Engineer can be described and measured by:

• 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 SDH 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 solutions 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 our analytical layer

What will make you successful in this role?

Role Requirements:

Qualifications:

• Bachelor’s degree in Computer Science, Statistics, Informatics, Information Systems, Engineering or another quantitative field / National Diploma in an Information Technology related discipline preferred

Work Experience:

• The Data Analytics Engineer must have at least 2 to 5 years of relevant experience in a similar environment working with the relevant tools and techniques

Technical Knowledge and Experience:

The Data Analytics Engineer is someone with a strong understanding of data, data structures and data sources. Required skills include:

• Application and data engineering background with a solid knowledge of SQL is required 
• 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 and Impala preferred and highly advantageous.
• Knowledge and experience of all BOBJ components is desirable. Create and maintain universes and business layer through IDT. BOBJ report building, maintenance, scheduling and publications with Web Intelligence and CMC. 
• Object-oriented/object functional scripting languages (e.g. Python, Java, Shell or related)
• Knowledge and experience of structured data, such as entities, classes, hierarchies, relationships and metadata.
• Strong Data Engineering background with a specific focus on staging high quality data
• Understanding of data warehousing principles (e.g. Kimball and Vault).
• Experience in agile development
• Ability to comply to and manage data assets under a strict governance framework

Desirable/ preferred skills include:

• Data warehousing (Kimball and Data Vault patterns are preferred) and dimensional data modelling (e.g. OLAP and MDX experience)
• A solid background in SQL, Information Architecture and ETL procedures
• Experience with object-oriented/functional/scripting languages (e.g. Python, Unix Shell scripting, Java, Scala etc.) is preferred but not essential. 
• Data Management technologies (e.g. Informatica Data Quality (IDQ), Informatica Enterprise Data Catalog (EDC), Axon, EBX) 

Competencies:

• Strong analytical & numerical ability
• Problem solving skills
• Conceptual thinker
• Good communication / interpersonal skills
• Action / results orientation
• Quality orientation
• Knowledge seeking / learning orientation
• IT Data Analysis 
• Database Knowledge and Monitoring 
• Data Security 
• Risk Management 
• Strong analytical-thinking and problem-solving abilities
• Ability to collect, organize, analyze, and disseminate significant amounts of information 
• Strong technical and operational ability 
• Deadline-driven, even in pressurized and fast-paced environments

Personal Attributes

• Decision quality - Contributing independently
• Interpersonal savvy - Contributing independently
• Plans and aligns - Contributing independently
• Optimises work processes - Contributing independently

Core Competencies

• Being resilient - Contributing independently
• Collaborates - Contributing independently
• Cultivates innovation - Contributing independently
• Customer focus - Contributing independently
• Drives results - Contributing independently