Investec is a distinctive Specialist Bank serving clients principally in the UK and South Africa. Our culture gives us our edge: we work hard to find colleagues who'll think out of the ordinary and we put them in environments where they'll flourish. We combine a flat structure with a focus on internal mobility. If you can bring an entrepreneurial spirit and a desire to learn and collaborate to your work, this could be the boost your career deserves.
Embedded in our culture is a sense of belonging and inclusion. This creates an environment in which everyone is free to be themselves which helps to drive innovation, creativity and ultimately business performance. At Investec we want everyone to find it easy to be themselves, and to feel they belong. It's a responsibility we all share and is integral to our purpose and values as an organisation.
Research shows that some candidates can be reluctant to apply to a role unless they meet all the criteria. We pride ourselves on our entrepreneurial spirit here and welcome you to do the same – if the role excites you, please don't let our person specification hold you back. Get in touch!
The candidate will be joining a ten person data engineering team. The strength of the team is partly due to the collaboration and knowledge sharing, which is both encouraged and expected. At the same time, due to the small size of the team relative to the Bank, often development is done individually, meaning candidates must be self-reliant.
Investec is looking for an experience Data Engineer to join the Specialist Bank Data Engineering team. The candidate will be required to deliver to all stages of the data engineering process – data ingestion, transformation, data modelling and data warehousing, and building self-service data products.
The data engineer teams primary function is to deliver high quality data to business and end users across the entire Specialist Bank – either directly via self-service data products, or by working closely with the Analytics team, providing modelled data warehouses on which they can add reporting and analytics
The role spans both on-prem (SQL Server) and cloud (Azure) environments. The skills of the candidate will determine their initial focus, but ultimately all on-prem will be migrated to cloud and decommissioned.
Data Engineering sits under the heading of Data & AI, and in addition to the Analytics, the candidate would work closely with Architecture, DevOps, Database Administrators, and upstream Application teams.Responsibilities include:• Working closely with end-users to understand their business and their data requirements• Ad hoc data analysis and ‘data wrangling' using Synapse Analytics and Databricks• Building dynamic meta-data driven data ingestion patterns using Azure Data Factory and Databricks• Building and maintaining the Enterprise Data Warehouse (using Data Vault 2.0 methodology)• Building and maintaining business focused data products and data marts• Building and maintaining Azure Analysis Services databases and cubes• Building ‘infrastructure-as-code' deployment pipelines• Sharing support and operational duties within the engineering team
Experience in the following technologies are key to this role:• Excellent data analysis and exploration using T-SQL• Strong SQL programming (stored procedures, functions)• Extensive experience with SQL Server and SSIS• Knowledge and experience of data warehouse modelling methodologies (Data Vault 2.0, Kimball)• Experience in Azure – one or more of the following: Data Factory, Databricks, Synapse Analytics, ADLS Gen2 • Experience in building robust and performant ETL processes• Build and maintain Analysis Services databases and cubes (both multidimensional and tabular)• Experience in using source control, preferably GIT• Understanding and experience of deployment pipelines
Advantageous technical skills• Knowledge of financial markets• Some programming ability (C#, .Net Core)
We commit to ensure that everyone is fairly assessed during our recruitment process.
Let us know if you need any reasonable adjustments to complete your application.