Lead Data Engineer (Cape Town, South Africa)

Lead Data Engineer (Cape Town, South Africa)

Our client is a renowned Financial Services firm in South Africa, they are seeking a Lead Database Engineer to join their Credit Risk and Decision Support team.

Role Purpose

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.

Responsibilities

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.
• Design and implement data models that support automated decision making and/or further analytics.
• Continuously search for data elements from other sources to enhance existing data objects to supplement
/ enhance context.

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.
• Provide technical and data related support to source system teams and external parties with whom we
exchange data.
• Manage data growth and usage by implementing effective strategies, e.g. archiving and indexing.
• Manage systems, technology and tools that enable data management and analytics and liaise with IT
infrastructure and IT Operations regarding system and infrastructure management.

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.
• Take ownership of own career development by continuously improving skills, knowledge and the
application thereof in designing and implementing solutions.
• Positive engagement in team activities and actively contribute ideas to improve team dynamics and
performance.
• Cross functional data and team knowledge gathering and sharing.
• Responsible for team activities, team dynamics and performance.
• Manage project and task delivery of team as well as quality control there off

Qualifications

• 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