Job title: Lead Data Engineer
Employment type: Full Time
Experience: 8 to 10 years
Salary: Negotiable
Job published: 13 August 2021
Job reference no: 2014333756

Job Description

Lead Data Engineer

Highly attractive market related salary

Cape Town

Excellent career opportunity with a leader in the Financial Services industry. The Lead Data Engineer is responsible for creating business value by leading a team that apply data engineering and data management disciplines to design and build data solutions that enable data driven decision support, in order to optimize business decisions and processes.

Key Performance Areas:
        1. Data Solutions

           Sourcing data

  • Identify data sources that can add value to decision making.
  • Work with source system owners and analysts to understand source data, e.g. data profiling, definition and mapping.

           Loading data

  • Design and implement efficient data loads, using traditional structured data ETL techniques.
  • Design and implement real time and near real time data load solutions, using technologies like data streaming.
  • Design and implement unstructured data loads, e.g. text speech, images and video.
  • Design and implement load monitoring tools and procedures and perform continuous monitoring and optimising of loads.

            Storing data

  • Work with analysts and architect to design and implement effective and efficient data warehouse data models using appropriate modelling techniques.
  • Design and implement data pipelines for ad hoc, unstructured and other data models.

           Enhancing data

  • Design and implement appropriate aggregation data structures that enhance usability of data, e.g. multi-dimensional OLAP structures, summary tables etc.
  • Design, implement and maintain appropriate indexing on tables to enhance speed of access.

           Managing data

  • Design and implement data monitoring solutions and procedures and continuously monitor and maintain integrity of existing environment, troubleshoot technical and data issues and make appropriate changes where required.
  • Design and implement meta-data solutions that assist with understanding and managing data.
  • Work together with business owners, analysts and IT to manage changes to data in the organization and maintain good data governance.

        2. Personal, People and Functional leadership:

  • Take ownership of own work by delivering high quality work on time.
  • Show initiative and be pre-active in finding opportunities to improve data and/or processes.
  • Responsible for team activities, team dynamics and performance.
  • Manage project and task delivery of team as well as quality control there off.

Functional Competencies:

  • SQL
  • Data analysis
  • Data visualisation
  • Data modelling
  • Microsoft business intelligence data technologies (SSIS, SSAS, SQL Server)
  • Data warehouse concepts and best practices


  • Degree in information technology / mathematics / engineering / actuarial science or related discipline.


  • 8+ Years’ in a technical data role, preferably in a formal data, data warehouse or business intelligence environment. Previous management experience desirable but not essential.

Please apply online.