Senior Data Engineer/Modeller

Apply now »

Date: 22-Jun-2022

Location: Bellville, Western Cape, South Africa

Company: Sanlam Group

Who are we?

Sanlam Group Technology is responsible for the provision of a digitally enabled technology service as a group COE, drive business and transformation and provide group-wide digital and data architecture. We operate the various technology platforms and shared services, ensure Cyber and Information Security resilience, and act as technology governance and risk orchestrator for technology across Sanlam.

What will you do?

The successful incumbent will be responsible for sourcing and loading a wide range of data across our business so that it can be used by analysts and developers to develop data solutions to business. You need to understand and continuously seek techniques to ingest data and ensure a high degree of quality and confidence. In addition, you should be able to use the technology and seek to make use of the features therein to deliver value to the business. You will not only design and develop, but also required to coordinate with security and infrastructure as well as investigate issues, troubleshoot technical issues and devise solutions in line with best practice. You will be responsible for a team of engineers and it will be required that you guide, assist and grow the individuals in that team.

What will make you successful in this role?

  • Provide technical leadership to the team
  • Own, plan and manage the workload of the team and ensure delivery
  • Act as the escalation point for any issue the team is experiencing
  • Act in technical leadership capacity and design, develop and enhance the ingestion frameworks that can load data consistently with a high degree of confidence
  • Load large, complex data sets to and make data available for data engineers
  • Source data from internal and external data sources, engaging with technical subject matter experts
  • Build the infrastructure required for optimal Extraction, Transformation, and Loading (ETL) of data from a wide variety of data sources using various ‘big data’ technologies
  • Identify, design, and implement internal process improvements: automating manual processes, optimising data delivery, re-designing models for greater scalability
  • Engage with a wide range of technical stakeholders including data scientists, business analysts, other data engineers and solutions architects
  • Work with data analysts and data engineers to understand the dynamic nature that is required to support the solution that needs to be built
  • Support data stewards to establish and enforce guidelines for data collection, quality improvements, integration and processes
  • Mentor Junior Data Engineers
  • Comply to and manage data assets under a strict governance framework

Qualification

Grade 12
National Diploma in an Information Technology related discipline or Bachelor’s Degree in Computer Science, Statistics, Informatics, Information Systems or any other quantitative field (preferred) 

 

Experience
5+ years' experience as a Data Engineer in a BI environment
ETL toolsets (e.g. SAP Data Services)
Database technologies (e.g. SAP Hana, Teradata or similar) and Hadoop components including HDFS, Hive, Spark, Oozie and Impala is required.   
Object-oriented/functional/scripting languages (e.g. Python, Unix Shell scripting, Java, Scala etc.) is required
Agile development is recommended

 

Knowledge
SQL development skills using SQL and procedural extensions
Strong Data Engineering with a specific focus on staging high quality data
Information Architecture and ETL procedures
Understanding of data warehousing principles (e.g. Kimball and Vault) is recommended

Knowledge and Skills

Profile source data and determine all source data and metadata characteristics
Advanced analytics to address business requirements
Vendor Management
Data Warehouse Modeling
Statistical analysis and data

Personal Attributes

Manages complexity - Contributing through others
Tech savvy - Contributing through others
Plans and aligns - Contributing through others
Optimises work processes - Contributing through others

Build a successful career with us

We’re all about building strong, lasting relationships with our employees. We know that you have hopes for your future – your career, your personal development and of achieving great things. We pride ourselves in helping  our employees to realise their worth. Through its four business clusters – Sanlam Life and Savings, Sanlam Investment Group, Sanlam Emerging Markets, Santam, as well as MiWay and the Group Office – the group provides many opportunities for growth and development.

Core Competencies

Being resilient - Contributing through others
Cultivates innovation - Contributing through others
Customer focus - Contributing through others
Collaborates - Contributing through others
Drives results - Contributing through others

Turnaround time

The shortlisting process will only start once the application due date has been reached. The time taken to complete this process will depend on how far you progress and the availability of managers. 

Our commitment to transformation

The Sanlam Group is committed to achieving transformation and embraces diversity.  This commitment is what drives us to achieve a diverse, inclusive and equitable workplace as we believe that these are key components to ensuring a thriving and sustainable business in South Africa.  The Group's Employment Equity plan and targets will be considered as part of the selection process.