Description

Investec is looking for an experienced Data Engineer to join the Private Bank Tech Data team in Sandton.   The successful candidate will have strong experience designing BI solutions using Microsoft stack preferably within Investment banking or Financial services experience (general products and processes knowledge; market, reference and regulatory data).

•    Designing and building end to end BI solutions, that will extract data from multiple systems, transforming and loading into multiple reporting data warehouses
•    Working with end users and analysts on requirements and translate them into technical specification, provides estimation to the management
•    Supporting existing BI Platform, reverse engineer and improve processes
•    Following and contributing to departmental development process in terms of standards, methodologies, testing, version control and documentation, mentor junior members, drive and implement industry best practices, evaluate, and introduce new tools, design, and improve existing ETL framework, data validation framework
•    Assist in the migration to an off-prem Cloud Solution (Specifically Microsoft Azure)

Experience, skill and capability

•    Excellent data analysis and exploration using T-SQL, and strong SQL programming (stored procedures, functions).
•    Knowledge and experience of data warehouse modelling methodologies 
•    Microsoft SQL Server 2005/2008/2008R2/2012/2014/2016, performance tuning, backup and recovery, data encryption, capacity planning, understanding of database engine internals and all database objects. Experience of loading data from different sources – xml, csv, excel, web services, different databases, MQ messages etc.
•    Extensive experience of using SSIS, script tasks, custom plugins
•    Significant experience designing solutions following Kimball methodology and good knowledge of data modelling concepts
•    Post release support of deployed BI solutions
•    Experience of building solutions with SSAS, advanced knowledge of SSAS, MDX, performance tuning, best practices, 2008 onwards
•    Experience of building reports using SSRS, PowerPivot, integration with SharePoint, building corporate reporting portals, KPIs, dashboards, self-service BI

Azure Cloud Data Engineer Competencies (advantageous):
•    Deliver to all stages of the data engineering process
•    Data ingestion, transformation, data modelling and data warehousing, and building self-service data products.
•    Experience in Azure, in particular Data Factory, Synapse, and Databricks 
•    Good understanding of Data Lakes, in particular Azure Data Lake Gen2 
•    Experience in building robust and performant ETL processes 
•    Building and maintain Analysis Services databases and cubes (both multidimensional and tabular)

General
•    Experience of working in a team following agile development practices, using team development tools, working on the same objects 
•    Wide knowledge of other tools, vendors, solutions available on the market and applicable to BI space, upcoming releases of new software packages, etc.
•    Experience of any modelling tools is a plus

Personal attributes and other requirements
•    Ownership
•    Self-motivated
•    Delivery focused
•    Excellent attention to detail
•    Agile Mind-set

The Investec Culture
At Investec we look for intelligent, energetic people filled with passion, integrity and curiosity. We value individuals who in turn value our culture that is, a flexible attitude comfortable to live with ambiguity and willing to challenge the status quo. Diversity, talent and leadership are respected in pursuit of the growth of our business. People who can manage themselves and build strong relationships in order to get things done, will perform in out of the ordinary ways in our environment. 

We are committed to diversity and inclusion when recruiting internally and externally.